Data Engineer&Architect AWS (DIA Datamarts)_2981

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.