Director - Data Engineering Lead - Snowflake

Employer: DWS GroupJob Title: Enterprise Data EngineerCorporate Title: DirectorLocation: PuneAbout DWSToday, 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 here.Team / Division OverviewThe 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 youAs part of our flexible scheme, here are just some of the benefits that you?ll enjoyBest in class leave policyGender neutral parental leaves100% reimbursement under childcare assistance benefit (gender neutral)Flexible working arrangementsSponsorship for Industry relevant certifications and educationEmployee Assistance Program for you and your family membersComprehensive Hospitalization Insurance for you and your dependentsAccident and Term Life InsuranceComplementary Health screening for 35 yrs. and aboveRole SummaryDWS 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 youTraining and development to help you excel in your careerFlexible working to assist you balance your personal prioritiesCoaching and support from experts in your teamA culture of continuous learning to aid progressionA range of flexible benefits that you can tailor to suit your needsAbout us and our teamsPlease visit our company website for further information:https://www.db.com/company/company.htmWe at DWS are committed to creating a diverse and inclusive workplace, one that embraces dialogue and diverse views, and treats everyone fairly to drive a high-performance culture. The value we create for our clients and investors is based on our ability to bring together various perspectives from all over the world and from different backgrounds. It is our experience that teams perform better and deliver improved outcomes when they are able to incorporate a wide range of perspectives. We call this #ConnectingTheDots.