2 months ago
Madrid, SpainStaff+
Responsibilities
- Design and implement database changes and interfaces for new business requirements, including the Private Pension Reform integration.
- Collaborate with business analysts, reporting teams, engineers, and stakeholders to integrate, validate, and deliver data for reporting.
- Maintain, enhance, and optimize the Oracle-based SIMS database application using PL/SQL development, performance tuning, and process improvements.
- Analyze and resolve data-related business and production issues while ensuring application stability and reliable delivery.
- Contribute to the future Snowflake-based platform, data modeling, data lineage, data quality controls, migration approach, and platform engineering patterns.
- Maintain and enhance reporting data marts built on a Data Vault architecture.
- Support the long-term SIMS modernization strategy through current-state analysis and future-state platform design.
Requirements
- 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 optimizing database objects, interfaces, stored procedures, data pipelines, data quality checks, and performance-critical data processes.
- Strong understanding of data modeling and experience working with complex data structures, preferably in financial services or regulated environments.
- Experience supporting business-critical database applications, including production issue analysis, root-cause investigation, performance tuning, and operational improvements.
- Hands-on Snowflake experience is strongly desirable, or demonstrated ability and willingness to develop deep Snowflake expertise.
- Experience with areas such as Data Vault, Medallion Architecture, data lineage, data quality controls, legacy platform migration, cloud data platforms, monitoring, or observability is advantageous.
- Ability to understand existing systems deeply and contribute to future-state platform design and modernization.
- Strong analytical, problem-solving, collaboration, and stakeholder communication skills.
- Fluency in written and spoken English.
- Ability to use AI tools productively while applying critical judgment for responsible and ethical use of data and AI outputs.
Benefits
- Personalized benefits covering healthcare, company perks, and retirement planning.
- Hybrid working model combining office collaboration with working from home; the specific split is discussed during the application and interview process.
- Interview adjustments and assistance are available for disabilities or long-term health conditions.
- Inclusive workplace focused on diversity, equity, collaboration, and diverse perspectives.
About DWS Group
DWS Group is a global asset manager that provides active, passive (Xtrackers ETFs), and alternative investment products for institutions, financial intermediaries, and individual investors. It earns management and performance fees across mutual funds and bespoke mandates, managing over €1 trillion in assets. Founded in 1956 and headquartered in Frankfurt, DWS is publicly listed in Germany and remains majority-owned by Deutsche Bank.