Principal Software Engineer - Principal 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're 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).

• Lead needed technical processes and designs considering reliability, data integrity, maintainability, reuse, extensibility, usability and scalability
• Serve as a technical expert in Snowflake and Python-based data engineering solutions.
• Design and implement efficient, scalable data pipelines using Snowflake and Python, optimizing for performance and cost.
• Leverage new Snowflake features (e.g., Snowpark, Cortex, dynamic tables) to enhance data workflows and automation.
• Collaborate with business analysts and stakeholders to ensure solutions meet functional and non-functional requirements.
• Develop and maintain robust SQL procedures, ensuring data integrity and alignment with business logic.
• Participate in solution design discussions, contributing technical insights and best practices.
• Support testing, deployment, and production maintenance of data workflows and automation scripts.
• Apply software development methodologies appropriate to project needs, including Agile practices.
• Align risk and control processes into day-to-day responsibilities to monitor and mitigate risk; escalate appropriately.

• Minimum of 12 years of related experience in Data Engineering and Automation
• Bachelor's degree preferred or equivalent experience

• Deep expertise in Snowflake, including architecture, performance tuning, and advanced features
• Strong Python programming skills for data engineering, automation, and integration
• Experience with Java is a plus
• Experience building enterprise-scale ETL pipelines and data workflows
• Proficiency in writing complex SQL queries and procedures
• Familiarity with CI/CD tools (e.g., Jenkins, Bitbucket), version control (Git), and Agile delivery
• Understanding of data governance, security, and compliance in cloud data platforms
• Ability to communicate technical concepts clearly and collaborate across teams
• Proactive in staying current with emerging technologies and Snowflake ecosystem updates
• Knowledge of Capital Markets is a big plus
• Demonstrates strong analytical and interpersonal skills
• Experienced working with a geographically separated (onshore and offshore) team
• Experience in Python and related libraries are good to have