Data Engineer Reporting & Analytics, Associate

About the role

DWS Corporate Functions Technology, within its SIMS application team, is hiring a Data Engineer Reporting & Analytics Associate in Madrid. SIMS is a financial data warehouse that delivers management KPIs, quarterly and annual reporting and other business-critical reports. The role covers two areas: maintaining and optimising the current SIMS reporting landscape, and helping shape the move toward a more modern data and analytics platform.

Key responsibilities

• Deliver new reporting requirements for SIMS, including Private Pension Reform-related reporting changes
• Work with business stakeholders and business analysts to turn reporting needs into scalable solutions
• Maintain, enhance and optimise SIMS reporting datasets, SQL queries, data models and report performance
• Support the migration of existing reports from legacy BI tools to Tableau and other modern tools, simplifying reports where possible
• Build and enhance data pipelines, datasets and analytical structures for management KPIs, financial reporting and self-service analytics
• Support reporting governance, including data quality, lineage, provenance, controls and consistency of outputs
• Keep reporting solutions aligned with application, data and technology architecture, and contribute to the evolution of the reporting architecture

Required profile

• Degree or equivalent qualification in Computer Science, Business Information Technology, Engineering, Finance Technology or a related discipline
• Strong hands-on experience with relational databases, preferably Oracle, including SQL development, query optimisation and large datasets
• Strong understanding of reporting data models, analytical data structures and data warehouse concepts
• Experience building, maintaining or optimising ETL/ELT pipelines for reporting and analytics
• Fluency in written and spoken English
• Ability to use AI tools productively while applying critical judgment to data and AI outputs

Required skills

• Tableau development (dashboards, reporting datasets, user-facing reports)
• Cognos or other BI/reporting platforms (desirable)
• Experience with reporting migration, rationalisation or modernisation initiatives (advantageous)
• Self-service reporting implementation, including design standards, access models and governance (advantageous)
• Advantageous: Snowflake, BigQuery or similar cloud data warehouses, and knowledge of financial or regulatory reporting

What we offer

• A personalised benefits plan covering healthcare, company perks and retirement planning
• A hybrid working model, with the office-to-home split discussed during the application and interview process