Lead Data Engineer – Snowflake & Data Platforms
About The Position
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. 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. 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.
Requirements
- 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.
- 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.
Nice To Haves
- 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.
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.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
