Database Engineer, Assistant Vice President

About the role

DWS Corporate Functions Technology provides technology solutions for Finance, Risk, ALM and AFC, and this role sits within the SIMS application team. SIMS is a financial data warehouse delivering management KPIs, quarterly and annual reporting and other core business outputs, currently built on an Oracle database with a Java web front end. The position focuses on the database engineering and data platform side of SIMS, complementing reporting-focused roles.

Key responsibilities

• Design and implement database changes and interfaces for new business requirements, including the Private Pension Reform integration.
• Work with business analysts, reporting colleagues and stakeholders so that new data is correctly integrated, validated and available for reporting.
• Maintain, enhance and optimise the Oracle-based SIMS database, including PL/SQL development, performance tuning and process improvements.
• Analyse and resolve data-related business and production queries to ensure stability, reliability and timely delivery.
• Build a deep understanding of the current SIMS data model, interfaces, controls and processes, then contribute to the future Snowflake-based platform and microservice architecture.
• Contribute to future-state data modelling, data lineage, data quality controls, migration approach and platform engineering patterns.
• Maintain and enhance reporting data marts built on a Data Vault architecture.
• Collaborate with the wider engineering team to support the SIMS modernisation strategy.

Required profile

• Master's degree or equivalent experience in Computer Science, Business Information Technology, Engineering, Data Management or a related discipline.
• Strong professional experience in database engineering, with deep hands-on expertise in Oracle PL/SQL and relational database development.
• Experience designing, developing and optimising database objects, interfaces, stored procedures, data pipelines, data quality checks and performance-critical processes.
• Experience supporting business-critical database applications, including production issue analysis, root-cause investigation and performance tuning.
• Fluency in written and spoken English.
• Proven ability to leverage AI tools to improve productivity, with critical judgment on their use.

Required skills

• Oracle PL/SQL and relational database development
• Data modelling and complex data structures, preferably in financial services or regulated environments
• Snowflake experience strongly desirable; willingness to build deep Snowflake expertise is valued
• Advantageous: Data Vault, Medallion Architecture, data lineage, data quality controls, migration from legacy platforms, cloud data platforms, monitoring and observability

What we offer

• A personalised benefits plan covering healthcare, company perks and retirement planning.
• A hybrid working model balancing office collaboration and working from home, with the split clarified during the interview process.