Senior Data Engineer - Snowflake

About the role

DWS, an investment firm with a global presence, is hiring a Senior Data Engineer in Madrid. The data infrastructure team builds the secure, scalable foundation for storing, processing and distributing enterprise data. As Senior Data Engineer, you will design, build and operate scalable data pipelines and platform components that power decision-making, reporting and enterprise analytics, working closely with data governance teams, platform engineering and business stakeholders.

Key responsibilities

• Design and implement robust ELT pipelines using dbt on Snowflake, following established data modeling standards
• Build and maintain data products for core domains such as fund accounting, positions, NAV and regulatory reporting
• Define and enforce data contracts, expectations and alerts
• Design and develop infrastructure components in Terraform or other IaC and infrastructure automation tools
• Collaborate with architects, security engineers, control functions and the Chief Data Office to improve compliance, security and reliability
• Work with product owners to turn product vision and demand into platform capabilities

Required profile

• 10+ years of experience in data engineering roles
• Experience with common enterprise data modeling such as dimensional modeling, SCD or Data Vault
• Previous exposure to data governance tooling (e.g. Collibra)
• Understanding of asset management and the financial services data domain is a plus
• Fluent English (written and spoken)
• Proven ability to use AI tools to improve productivity and workflows, with responsible and ethical use of data and AI outputs

Required skills

• Deep hands-on expertise with Snowflake, including architecture, performance tuning, Snowpark, OpenFlow and Streamlit
• Strong dbt proficiency (models, macros, packages, testing, deployment)
• Very strong Python skills for pipeline development and tooling
• Familiarity with cloud platforms (e.g. GCP), StreamSets and Airflow

What we offer

• A choice of benefits tailored to your lifestyle, covering healthcare, company perks and retirement planning
• A hybrid working model balancing office collaboration and working from home, with the split discussed during the application and interview process