Lead Data Engineer - Snowflake & Data Platforms

As a Lead Database Engineer, you will drive the design, development, and evolution of DTCC's enterprise data warehouse platform supporting IT, Cyber Security, and Business Operations analytics. Leveraging Snowflake, SQL, and modern data engineering technologies, you will build scalable data pipelines, optimize data platforms, and deliver trusted data solutions that power critical business decisions.

In this role, you will provide technical leadership across the full software development lifecycle, partnering with architects, product owners, and stakeholders to solve complex business challenges, advance DTCC's data modernization initiatives, and ensure the reliability, scalability, and performance of enterprise data platforms.

Your Primary Responsibilities:

• Lead the design, development, and delivery of enterprise data warehouse and analytics solutions from concept through production.
• Build and optimize scalable data pipelines, ETL/ELT processes, and reporting datasets using Snowflake and modern data technologies.
• Partner with Product Owners and business stakeholders to translate requirements into scalable technical solutions.
• Apply data warehousing best practices to ensure data quality, performance, reliability, and scalability.
• Lead and mentor a team of engineers, providing technical guidance and promoting development best practices.
• Develop reporting datasets, metrics, and analytical solutions using infrastructure, security, and operational data.
• Provide technical leadership and operational support for enterprise data platforms.
• Troubleshoot production issues and support incident, problems, and change management activities.
• Collaborate across technology teams to deliver high-quality solutions on time.
• Align risk and control practices with day-to-day responsibilities to appropriately monitor and mitigate risk.

• Bachelor's degree preferred or equivalent practical experience
• 6-8 years of experience in Data Engineering, Business Intelligence, Data Warehousing, Analytics, or related technology disciplines.

Talent Needed for Success

• Strong expertise in SQL and relational databases, with hands-on experience in Snowflake.
• Deep understanding of data warehousing architecture, data modeling, and data engineering best practices.
• Experience designing, developing, and optimizing data pipelines and ETL/ELT frameworks.
• Strong experience with query optimization, performance tuning, and large-scale data processing.
• Proven ability to lead projects, mentor team members, and deliver technical solutions with minimal oversight.
• Strong understanding of Agile methodologies, SDLC processes, and enterprise development practices.
• Excellent analytical, problem-solving, and troubleshooting skills.
• Strong communication and stakeholder management capabilities.
• Ability to manage multiple priorities and thrive in a fast-paced environment.
• Experience supporting production environments and resolving complex technical issues.

Preferred Skills

• Experience with Python for data engineering, automation, or analytics.
• Experience with Power BI, Amazon QuickSight, or similar analytics and visualization platforms.
• Experience with CI/CD tools such as Bitbucket.
• Experience working with cloud-based data platforms and modern analytics ecosystems.
• Knowledge of Windows and Unix/Linux operating systems.
• Experience supporting large-scale enterprise data platforms.
• Financial services, capital markets, post-trade processing, clearing, or settlement experience.

• 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).

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., With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, 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. In 2024, DTCC's subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC's Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually. To learn more, please visit us at www.dtcc.com or connect with us on LinkedIn, X, YouTube, Facebook and Instagram. 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. Serves as a dedicated technology resource for advancing DTCC's business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC's mission to support the financial markets.