Database Engineering Associate - Snowflake Developer

Job Description

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

Pay and Benefits:

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

• Design, develop, and maintain database solutions across cloud and on-premise environments.
• Write and optimize complex SQL queries, stored procedures, views, and database objects.
• Build and support ETL/ELT pipelines using tools such as DBT, Snowpipe, and COPY INTO.
• Develop and maintain data models, including relational, dimensional, star, and snowflake schemas.
• Manage and optimize databases on platforms such as Snowflake, SQL Server, Oracle, PostgreSQL, Databricks, and AWS.
• Implement data integration solutions using APIs, SFTP, and batch processing methods.
• Ensure data quality through validation, reconciliation, and data profiling activities.
• Monitor database and pipeline performance, troubleshoot issues, and implement performance enhancements.
• Implement security controls including RBAC, database roles, and access management.
• Maintain version control using Git and GitHub.
• Support Agile delivery processes, including participation in Scrum ceremonies and Jira-based project management.

• Minimum of 5 years of related experience
• Bachelor's degree preferred or equivalent experience.

• Strong experience with SQL and database development.
• Hands-on experience with Snowflake and at least one major database platform (SQL Server, Oracle, PostgreSQL, or Databricks).
• Experience designing data models and data warehouse solutions.
• Knowledge of ETL/ELT frameworks and data transformation techniques.
• Experience with AWS cloud services and data platforms.
• Understanding of database security, monitoring, and performance tuning.
• Familiarity with Git, GitHub, Jira, and Agile/Scrum methodologies.
• Strong problem-solving and analytical skills with excellent communication abilities.
• Good communication skills with the ability to explain technical concepts to non-technical stakeholders.
• Experience working in Agile/Scrum delivery environments.

DTCC is the premier post-trade market infrastructure for the global financial services industry. The firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem.