Data Engineer&Architect AWS (DIA Datamarts)

Joinimagine; Barcelona; Hybrid; EUR 70,000 - 100,000; Full time

Benefits offered by this job

Hybrid work model

Employee shares/bonus scheme

Job summary

Allianz is migrating over 200 data products as part of the OneDIA data ecosystem, moving from legacy systems to Snowflake and AWS. The role involves modeling data, building ETL pipelines, and establishing landing zones and data stores for ingesting raw data.

You will implement staging, data vaults, and data warehouses across multiple domains, collaborating in agile teams. Ideal candidates have 5+ years in data engineering, with Snowflake, DBT, and AWS expertise, plus experience with data

Qualifications

• Proficient with data platforms (Snowflake, AWS) and ETL design.
• Experience designing data solutions architecture.

Responsibilities

• Model data structures for tables and datamarts.
• Implement end-to-end ETL processes per OneDIA architecture.
• Define landing zone and data stores for raw ingestion.
• Perform staging with data lake architecture and processes.
• Set up raw and business data vaults across OE.
• Build customer data warehouses and data marts.

Skills

Snowflake

DBT

Agile

AWS

Data Architecture

GenAI

Communication

Tools

UC4

IDMC

Job description

About the Job

As part of the Allianz in Germany data ecosystem OneDIA, more than 200 data products need to be migrated from the legacy technology stack toward Snowflake and AWS.

What you do

• Create data models for all elements to be modelled (tables, datamarts, etc.).
• Implement the entire ETL processes as part of the architecture and processes specified by the OneDIA ecosystem.
• Define and implement the necessary landing zone and data store for ingesting the raw data.
• Carry out the staging using data lake architecture and processes.
• Set up the raw data vault for the OE and across the board as well as the business data vault for OE and across the board.
• Create customer-specific data warehouses and data marts within the scope of the Consumption Layer using data from different sources.
• Create the necessary pipelines for the creation and orchestration of the entire ETL process. Connect the Data Catalog to check the input data and verify the results of the processing procedures.

What you bring

• At least 5 years of experience on the following: Snowflake, DBT (incl. GitHub), Agile teams and agile delivery, AWS-based components for data, IaaS and container.
• Experience in design and implementation of data solutions architecture
• Team player, solution-oriented, open-minded and strong communication skills.
• Proficient in English, both written and spoken.
• ETL environment and tools: Snowflake, DBT, AWS components for data processing.
• Orchestration: AWS step functions, UC4.
• Data Catalog and Quality: IDMC.
• Experience in GenAI and Machine learning

What we offer

• We offer a hybrid work model which recognizes the value of striking a balance between in-person collaboration and remote working incl. up to 25 days per year working from abroad.
• We believe in rewarding performance and our compensation and benefits package includes a company bonus scheme, pension, employee shares program and multiple employee discounts (details vary by location).
• From career development and digital learning programs to international career mobility, we offer lifelong learning for our employees worldwide and an environment where innovation, delivery and empowerment are fostered.
• Flexible working, health and wellbeing offers (including healthcare and parental leave benefits) support to balance family and career and help our people return from career breaks with experience that nothing else can teach.