Data Engineer&Architect AWS (DIA Datamarts)

Allianz Technology; Barcelona; On-site; EUR 65,000 - 90,000; Full time

Benefits offered by this job

Company bonus scheme

Pension

Employee shares program

Employee discounts

Job summary

Allianz Technology is seeking a data engineering professional to join the OneDIA migration effort. You will model data, build ETL pipelines, and establish landing zones and data stores for raw ingestion.

Responsibilities include staging with data lake architectures, implementing raw and business data vaults, and creating customer data warehouses using diverse sources, with strong emphasis on data catalog integration.

Qualifications

• At least 3 years of experience with Snowflake, DBT and AWS data components.
• Proficient in English with strong communication skills.

Responsibilities

• Create data models for tables and datamarts.
• Implement ETL processes per the OneDIA ecosystem.
• Define landing zone and data store for raw data ingestion.
• Carry out staging using data lake architecture.
• Set up raw and business data vaults across OE and related areas.
• Create data warehouses and data marts using diverse data sources; connect to Data Catalog for validation.

Skills

Snowflake

DBT

Agile delivery

AWS data services

IaaS & containers

Tools

Snowflake

DBT

AWS Step Functions

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 3 years of experience on the following: Snowflake, DBT (incl. GitHub), Agile teams and agile delivery, AWS-based components for data (e.g. Glue), IaaS and container.
• 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.
• Machine learning knowledge is a strong advantage.

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 well-being 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.

About Allianz Technology

With its headquarters in Munich, Germany, Allianz Technology is Allianz's global IT service provider and delivers IT solutions that drive the group's digitalization. With more than 11,000 employees in over 20 countries around the world, Allianz Technology is tasked to run, optimize, transform and innovate the infrastructure, applications and services together with Allianz companies to co-create the best customer experience.

We service the entire spectrum of digitalization - from one of the industry's largest IT infrastructure projects that spans data centres, networks and security, to application platforms ranging from workplace services to digital interaction.

In short: We deliver comprehensive end-to-end IT solutions for Allianz in the digital age. We are the backbone of Allianz.

Find us at: www.linkedin.com/company/allianz-technology.

Commitment to Integrity, Fairness & Inclusion

Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges, is what makes us a unique employer. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us.

We at Allianz believe in a strong inclusive culture that encourages people to speak their minds, get involved and question the status quo. We are proud to be an equal opportunity employer and encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love, or what you believe in. We therefore welcome applications regardless of race, ethnicity or cultural background, age, gender, nationality, religion, social class, disability, sexual orientation, or any other characteristics protected under applicable local laws and regulations.

Job Details

Full-Time | Permanent