Data Warehouse Consultant (Nur SV-Pflichtig) (m/f/d)

Data Warehouse Consultant (Nur SV-Pflichtig) (m/f/d)

Reference: 838936/1-en
Start: asap
Duration: 5 MM++

Main tasks:
You facilitate the process of connecting various source systems to the central IT governance toolsYou work together with the IT product owners of the source systems and the team responsible for the IT governance tools to transform the data into the common data model of E.ON’s DT Family and make it centrally availableYou design and implement interfaces for data extraction, data transformation and data loading to and from the IT governance toolsYou design and implement Medallion-layered pipelines (ingest ? refine ? serve) using DatabricksYou optimize the schema for analytics (star/snowflake) and for operational read patternsYou implement Unity Catalog, data lineage, access controls, PII handling, and quality checksYou’ll design Medallion (Bronze/Silver/Gold) data pipelines, craft robust database schemas for inventory operationsYou create technical and functional documentation and publish them regularly

Main qualifications:
You have proven experience with the Microsoft Azure technology stack, especially Azure Data Factory (ADF) and Azure DatabricksYou have strong dimensional and 3NF modeling knowledge; are comfortable with CDC, late/dirty data, and schema evolutionYou have proven experience developing with Python and SQLYou have experience implementing Medallion architecture, Delta Lake, Unity Catalog, Workflows, SQL Warehouse, and Delta Live TablesYou show strong analytical and structured thinking abilitiesYou show strong problem-solving skills and the ability to work collaboratively in a team environmentYou are fluent in English language

Main advantages:
Support throughout the entire application process

About us:
IT is and always has been our core business that laid the foundation for Hays' success. We are the biggest privately owned IT recruitment agency in Germany and offer the best jobs for every career level – whether you are interested in vacancies in agile SMEs or international DAX groups. Hays masters the entire IT job spectrum, from support to software architecture or digitalisation – thanks to our broad portfolio, we have something for everyone. In the last decades, we were able to support numerous IT experts with choosing the right path for a successful career, positioning ourselves as their lifelong partner. Our highly specialised consultants can cater to your every wish and expectation and will prepare you for interviews and contract negotiations. Give it a try and learn what the market has to offer – our services are free of charge, non-binding and discreet! We look forward to hearing from you.

My contact at Hays:

Referencenumber:
838936/1

Make contact:
Email: positionen@hays.de
Telefone: + 49 621 1788-4297