Software Engineer (ETL with Snowflake)

Responsibilities

• Design, develop, and maintain ETL pipelines to ingest, transform, and load data from diverse sources into Snowflake and Oracle platforms
• Build and optimize data ingestion frameworks and REST API integrations for real-time and batch processing
• Develop reusable components using Java and Python for data transformation, orchestration, and pipeline automation
• Optimize query performance and data models to support analytics and reporting needs
• Troubleshoot data pipeline issues and provide production support, including root cause analysis
• Ensure adherence to data governance, security, and compliance standards
• Participate in CI/CD pipeline setup, code reviews, and DevOps practices

Requirements

• Strong programming experience in Java and/or Python
• Hands-on experience building ETL/data pipelines in enterprise environments
• Experience working with REST APIs for data ingestion and integration
• Strong database knowledge with Oracle and/or Snowflake
• Proficiency in SQL for data transformation and performance tuning
• Bachelor’s degree in Computer Science, Information Systems, or a related field
• Typically 3–6+ years of experience in ETL/Data Engineering roles

Preferred Qualifications

• Familiarity with CI/CD tools such as Jenkins, Git, or Bitbucket
• Knowledge of data ingestion frameworks and enterprise integration tools
• Experience working in Snowflake-based data platforms or modern data pipelines

Benefits

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits
• Pension and retirement benefits
• Paid Time Off and various leaves of absence to support well-being
• Flexible/hybrid work model (3 days onsite, 2 days remote)

About the Company

DTCC is the premier post-trade market infrastructure for the global financial services industry. With over 50 years of experience, DTCC automates, centralizes, and standardizes the processing of financial transactions to mitigate risk and increase transparency for thousands of broker/dealers, custodian banks, and asset managers worldwide.