Data Engineer Reporting & Analytics, Associate

Employer:              DWS Group Title:                       Data Engineer Reporting & Analytics , Associate 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 Corporate Functions Technology provides technology solutions for key corporate functions including Finance, Risk, Asset and Liability Management, AFC and other control functions. This position sits within the SIMS application team. SIMS is a financial data warehouse used to deliver management KPIs, quarterly and annual reporting, and other business-critical reporting capabilities.  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. The role therefore requires someone comfortable working with established reporting environments while also helping shape the move towards a more modern data and analytics platform.  Your responsibilities – As a Data Engineer Reporting & Analytics, Associate, you will: 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,