Lead Data Engineer – Snowflake & Data Platforms

The Depository Trust & Clearing Corporation (DTCC); Jersey City (NJ); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive compensation

Health insurance

Pension / Retirement benefits

Paid Time Off

Hybrid onsite 3 days / remote 2 days

Job summary

The Depository Trust & Clearing Corporation (DTCC) is seeking a Lead Database Engineer in Jersey City to drive design, development, and evolution of the enterprise data warehouse platform, leveraging Snowflake, SQL, and modern data technologies.

You will lead a team of engineers, collaborate with architects and stakeholders, ensure data quality, performance, and scalability, and mentor staff while delivering data pipelines and analytics solutions across IT, Cyber Security, and Business

Qualifications

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

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.

Skills

SQL

Snowflake

Data warehousing

ETL/ELT

Python

Power BI

CI/CD

Bitbucket

Cloud platforms

Education

Bachelor's degree

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

The Impact You Will Have in This Role

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.

Qualifications

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

The salary range is indicative for roles at the same level within DTCC across all US locations. 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. Please contact us to request accommodation.