Software Engineer (ETL with Snowflake)

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork.  When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.

Learn more about Clearance and Settlement by clicking here.

IT Architecture and Enterprise Services are responsible for enabling digital transformation of DTCC. The group manages complexity of the technology landscape within DTCC and enhances agility, robustness and security of the technology footprint. It does so by serving as the focal point for all technology architectural activities in the organization as well as engineering a portfolio of foundational technology assets to enable our digital transformation.

We are seeking a skilled ETL Developer / Data Engineer to design and build scalable data pipelines for enterprise data platforms. The role focuses on integrating multiple data sources into Snowflake/Oracle-based data warehouses, leveraging Java/Python, REST APIs, and modern data engineering practices.
 

Primary Responsibilities:

• Design, develop, and maintain ETL pipelines to ingest, transform, and load data from diverse sources (databases, APIs, files) into target data platforms such as Snowflake and Oracle 

• Build and optimize data ingestion frameworks and REST API integrations for real-time and batch processing 

• Develop reusable components using Java/Python for data transformation, orchestration, and pipeline automation 

• Optimize query performance and data models in Snowflake/Oracle to support analytics and reporting needs 

• Troubleshoot data pipeline issues and provide production support, including root cause analysis and resolution 

• Ensure adherence to data governance, security, and compliance standards in all ETL processes 

• Participate in CI/CD pipeline setup, code reviews, and DevOps practices for data engineering workflows 

• Contribute to design, testing, and deployment of scalable data solutions. 

 

Required Skills and Experience:

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

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field
• Typically 3–6+ years of experience in ETL/Data Engineering roles
• Strong analytical, problem-solving, and communication skills

Good to Have

• Familiarity with CI/CD tools (Jenkins, Git, Bitbucket, etc.)
• Knowledge of data ingestion frameworks and enterprise integration tools
• Experience working in Snowflake-based data platforms or EDI/modern data pipelines (aligned with enterprise data ecosystems)

 Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.