Employer: DWS Group
Title: Senior Data Engineer - Snowflake
Location: Madrid
Job Code: placeholder for LinkedIn job wrapping
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.
We’re looking for creative thinkers and innovators to join us as the world continues to transform. As whole markets change, one thing remains clear; our people always work together to capture the opportunities of tomorrow.
As investors on behalf of our clients, it is our role to find investment solutions. Ensuring the best possible foundation for our clients’ financial future. And in return, we’ll give you the support and platform to develop new skills, make an impact and work alongside some of the industry’s greatest thought leaders. This is your chance to achieve your goals and lead an extraordinary career.
This is your chance to invest in your future.
Read more about DWS and who we are here.
Team / division overview
DWS’s data infrastructure team provides the secure, scalable and trustworthy foundation for storing, processing and distributing critical enterprise data. As a Senior Data Engineer, you will design, build, and operate scalable data pipelines and platform components that power decision-making, reporting, and enterprise analytics. You will work closely with data governance teams, platform engineering, and business stakeholders to raise the bar on data quality and reliability.
Your responsibilities –
As Senior Data Engineer - Snowflake, you will:
- Design and implement robust ELT pipelines using dbt on Snowflake, following established data modeling standards
- Build and maintain data products for core domains including fund accounting, positions, NAV, and regulatory reporting
- Define and enforce data contracts, expectations and alerts with
- Design and develop infrastructure components in Terraform or other IaC and infrastructure automation tools
- Collaborate with architects, security engineers, control functions, the Chief Data Office and other stakeholder to improve compliance, security posture and reliability
- Work with product owners to translate product vision and demand into platform capabilities
We are looking for
- 10+ years of experience in data engineering roles
- 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
- Experience with common enterprise data modeling, such as dimensional modeling, SCD or Data Vault
- Familiarity with cloud platforms (e.g. GCP), StreamSets and Airflow
- Previous exposure to data governance tooling (e.g. Collibra)
- Understanding of asset management and the financial services data domain would be a plus
- Strong problem-solving skills, strategic thinking and attention to detail
- Fluent in English (written and spoken)
- Proven ability to leverage AI tools to enhance productivity, optimise workflows to solve business problems, while applying critical judgment to ensure responsible and ethical use of data and AI outputs.
What we’ll offer you:
At DWS we’re serious about diversity, equity and creating an inclusive culture where colleagues can be themselves and it’s important to us that you enjoy coming to work - feeling healthy, happy and rewarded. At DWS, you’ll have access to a range of benefits which you can choose from to create a personalised plan unique to your lifestyle. Whether you’re interested in healthcare, company perks, or are thinking about your retirement plan, there’s something for everyone.
DWS’ Hybrid Working model is designed to find the right balance between in-person collaboration and engagement in the office, which is core to our working culture, and working from home. Each business group varies on the split between time spent in the office and at home, but this will be discussed and made clear as part of your application and interview process. We will continue to review and evolve our working environments and methods to ensure that we are working in the best way possible for our people.
If you require any adjustments or changes to be made to the interview process for any reason including, or related to a disability or long-term health condition, then please contact your recruiter and let them know what assistance you may need. Examples of adjustments include providing a change to the format of the interview, or providing assistance when at the DWS office. This will not affect your application and your recruitment team will discuss options with you.
We 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.
Skills Required
- 10+ years of experience in data engineering roles
- 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
- Experience with enterprise data modeling (dimensional modeling, SCD, Data Vault)
- Design and develop infrastructure components in Terraform or other IaC
- Familiarity with cloud platforms (e.g. GCP), StreamSets and Airflow
- Previous exposure to data governance tooling (e.g. Collibra)
- Understanding of asset management and the financial services data domain
- Fluent in English (written and spoken)
- Proven ability to responsibly leverage AI tools to enhance productivity and workflows
What We Do
DWS Group (DWS) with EUR 933bn of assets under management (as of 30 June 2024) aspires to be one of the world's leading asset managers. Building on more than 60 years of experience, it has a reputation for excellence in Germany, Europe, the Americas and Asia. DWS is recognized by clients globally as a trusted source for integrated investment solutions, stability and innovation across a full spectrum of investment disciplines. We offer individuals and institutions access to our strong investment capabilities across all major liquid and illiquid asset classes as well as solutions aligned to growth trends. Our diverse expertise in Active, Passive and Alternatives asset management – as well as our deep environmental, social and governance focus – complement each other when creating targeted solutions for our clients. Our expertise and on-the-ground knowledge of our economists, research analysts and investment professionals are brought together in one consistent global CIO View, giving strategic guidance to our investment approach. DWS wants to innovate and shape the future of investing. We understand that, both as a corporate as well as a trusted advisor to our clients, we have a crucial role in helping to navigate the transition to a more sustainable future. With approximately 4,500 employees in offices all over the world, we are local while being one global team. We are committed to acting on behalf of our clients and investing with their best interests at heart so that they can reach their financial goals, no matter what the future holds. With our entrepreneurial, collaborative spirit, we work every day to deliver outstanding investment results, in both good and challenging times to build the best foundation for our clients’ financial future.
