Director - Data Engineering Lead - Snowflake

Position Overview

Employer:DWS Group

Job Title: Enterprise Data Engineer

Corporate Title: Director
Location: Pune

About DWS

Today, markets face a whole new set of pressures - but also a whole lot of opportunity too. Opportunity to innovate differently. Opportunity to invest responsibly. And opportunity to make change.
Join us at DWS, and you can be part of an industry-leading firm with a global presence. You can lead ambitious opportunities and shape the future of investing. You can support our clients, local communities, and the environment.
Read more about DWS and who we are

Team / Division Overview

The Chief Operating Office (COO), CTO DWS Tech Division is a key enabler for DWS and is integral to the future success of the company by delivering world-class services across a set of key functions. It covers essential Technology and Operations capabilities, and aims to deliver a platform which is efficient, scalable, resilient and agile.

What we'll offer you

As part of our flexible scheme, here are just some of the benefits that you'll enjoy

• Best in class leave policy
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Flexible working arrangements
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term Life Insurance
• Complementary Health screening for 35 yrs. and above

Role Summary

DWS is seeking a Director-level Enterprise Data Engineer with 18+ years of experience in data engineering, architecture, and enterprise platforms. Deep hands-on expertise in Snowflake implementation and a strong background in data modeling within asset management domain. The ideal candidate will have designed and implemented complex investment data models, especially on Aladdin (BlackRock), and will play a strategic role in shaping our enterprise data strategy while being actively involved in hands-on engineering.

Key Responsibilities

. Lead the design and implementation of enterprise-scale data models in Snowflake to support investment data, portfolio analytics, risk, and performance workflows.
. Develop and maintain ETL/ELT pipelines integrating Aladdin data, market/reference data providers, and internal financial systems.
. Build investment data models such as:
. Portfolio & Holdings Model (positions, transactions, performance)
. Benchmark & Index Model (tracking error, benchmark alignment, relative performance)
. Risk Model (VaR, factor exposures, scenario analysis)
. Compliance & Regulatory Model (pre-trade/post-trade checks, regulatory filings, client mandates)
. Performance Attribution Model (security-level attribution, multi-factor attribution)
. Ensure data governance, lineage, and quality frameworks are built into the data layer.
. Partner with principal engineers and enterprise architects to align technical solutions with investment processes.
. Mentor engineering teams and establish best practices for Snowflake optimization, data security, and cloud integration.
. Support AI/ML use cases by preparing high-quality data feeds for quantitative models and analytics.

Must have Skills & Experience
. Total 18+ years of experience in data engineering, data architecture, and enterprise data management, with strong exposure to financial services/asset management.
. Deep expertise in Snowflake (performance tuning, role-based access, data sharing, zero-copy cloning, materialized views, etc.), Snow spark, Cortex AI SQL, Cortex Agents.
. Proven ability to design conceptual, logical, and physical data models for investment workflows, including:
. Portfolio & Risk data structures from Aladdin.
. Trade/Order data models integrating OMS/EMS platforms.
. Client reporting and performance attribution models.
. Advanced skills in SQL and Python/Scala for building scalable data pipelines.
. Strong understanding of investment management workflows (portfolio construction, risk management, performance measurement, compliance, reporting).
. Experience in leading large-scale enterprise data initiatives with cross-functional stakeholders.

Desirable skills that help you excel
. Prior experience with BlackRock Aladdin model customization and integration with Snowflake.
. Knowledge of alternative data integration and AI-driven investment analytics.
. Familiarity with visualization & BI tools (Power BI, Tableau, Looker).
. Experience with cloud-native platforms (GCP) and enterprise integration patterns.

• Performance and cost optimization in snowflake
  

Educational & Technical Qualification Requirements

- Bachelor's Degree in Computer Science, Engineering, or related discipline.
- More than 10 years experience in enterprise architecture and full-stack development.

How we'll support you

• Training and development to help you excel in your career
• Flexible working to assist you balance your personal priorities
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression
• A range of flexible benefits that you can tailor to suit your needs

About us and our teams

Please visit our company website for further information:

We strive for a in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively.
Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group.
We welcome applications from all people and promote a positive, fair and inclusive work environment.