Data Engineer Reporting & Analytics, Associate

We are seeking a Data Engineer Reporting & Analytics, Associate to join our team at DWS Group in Madrid.

As a Data Engineer focused on Reporting and Analytics, you will work across two connected areas. The first is the current SIMS reporting landscape, where the focus will be on maintaining, enhancing, and optimising existing reporting capabilities. This includes delivering Private Pension Reform-related requirements, improving report performance, strengthening reporting datasets and supporting the rationalisation and migration of a large number of existing Cognos reports to Tableau or other modern reporting technologies.

The second area is more future-facing and will evolve as the target reporting architecture is implemented. This may include contributing to new reporting capabilities on Snowflake and modern BI technologies, either by building new reports directly on a cloud data platform or by taking a phased approach where existing SIMS/Cognos reports are first rationalized and migrated before being further evolved.

Your responsibilities will include:

• Delivering new reporting requirements for the SIMS application, including Private Pension Reform-related reporting changes.
• Working with business stakeholders and business analysts to understand reporting requirements and translate them into scalable reporting solutions.
• Maintaining, enhancing and optimising the existing SIMS reporting landscape, including reporting datasets, SQL queries, data models and report performance.
• Supporting the rationalisation and migration of existing reports from legacy BI tooling to Tableau and other modern reporting technologies.
• Helping redesign and simplify existing reports where appropriate, rather than simply recreating legacy reporting outputs in a new tool.
• Building and enhancing data pipelines, reporting datasets and analytical data structures to support management KPIs, financial reporting and self-service analytics.
• Supporting reporting governance, including data quality, lineage, provenance, controls and consistency of reporting outputs.
• Working with the wider engineering team to ensure reporting solutions remain aligned with the application architecture, data architecture and broader technology standards.
• Contributing to the evolution of the reporting architecture as the platform continues to modernise.

We are looking for candidates with:

• 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 working with large datasets.
• Strong understanding of reporting data models, analytical data structures and data warehouse concepts.
• Experience building, maintaining or optimising ETL/ELT data pipelines that support reporting and analytics use cases.
• Strong professional experience in Tableau development, including dashboards, reporting datasets and user-facing reporting solutions.
• Knowledge of, or hands-on experience with, Cognos or other BI/reporting platforms is desirable.
• Experience supporting reporting migration, report rationalisation or reporting modernisation initiatives would be advantageous.
• Experience implementing self-service reporting capabilities, including associated design standards, access models and governance processes.
• Understanding of data quality, data lineage, data provenance, reporting controls and consistency of reporting outputs.
• Exposure to modern data platforms or cloud data warehouses such as Snowflake, BigQuery or similar technologies would be advantageous.
• Understanding of financial reporting, management information, regulatory reporting or corporate functions data would be advantageous.
• Strong analytical and problem-solving skills, with the ability to work collaboratively across business and technology teams.
• Strong communication skills, with the ability to explain data and reporting topics clearly to both technical and non-technical stakeholders.
• Fluency in written and spoken English.
• 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.

In return, we offer a range of benefits, including a hybrid working model, access to a range of benefits to create a personalised plan unique to your lifestyle, and a commitment to creating a diverse and inclusive workplace.