Job
- Level
- Experienced
- Job Field
- Database, Back End
- Employment Type
- Part Time/Full Time
- Contract Type
- Permanent employment
- Location
- Ratingen
- Working Model
- Hybrid, Onsite
Job Summary
In this position, you will develop a stable enterprise data model on Azure and Snowflake while transforming fragmented data sources into consistent, high-quality data products and ensuring essential modeling standards.
Job Technologies
Your role in the team
- You serve as the central bridge between complex source systems and a robust, unified enterprise data model, and are responsible for the conceptual, logical, and structural integrity of our Core Data Model as well as the Gold Layer on Azure, Snowflake, and dbt.
- You ensure that fragmented data sources are transformed into consistent, reusable, and decision-relevant data products, actively preventing the platform from breaking down into team-specific, incompatible models.
- You define and maintain core business objects, canonical dimensions, shared metrics, and facts, ensuring that the Core Data Model provides a stable, business-oriented foundation across all domains.
- You develop modeling standards, naming conventions, layering concepts (Staging, Intermediate, Gold), reuse patterns, as well as dbt design guidelines, and ensure their consistent implementation across all teams.
- You ensure the semantic consistency of the entire data model, resolve conflicts between domains, ensure that identical business terms are modeled only once, and review changes that impact core layers.
- You act as the technical design authority for model changes in Snowflake/dbt, balancing local requirements with long-term model coherence and ensuring that all models remain performant, scalable, maintainable, and of high quality.
This text has been machine translated. Show original
Our expectations of you
Qualifications
- You possess solid expertise in analytical and dimensional data modeling (e.g., hybrid models, conceptual data models, conformed dimensions) and think in terms of durable, stable data products.
- You have expert-level proficiency in SQL and confidently use Python for data processes, transformations, automation, and quality checks.
- You think strongly in architectural terms, communicate precisely, set standards without blocking, and ensure the long-term maintainability, performance, and scalability of the entire data model.
Experience
- You have extensive experience with Azure Data Services (ADLS, Azure Data Factory / Synapse Pipelines, Azure Databricks), Snowflake, and dbt as a central transformation tool.
- You bring experience in dbt governance - including modularization, testing strategies, versioning, documentation, and clean architecture approaches.
- You speak fluent English (C1) and good German; experience with Kafka or event-streaming architectures would be a plus.
This text has been machine translated. Show original
What we offer
- This position can be filled on a full-time basis or in near-full-time part-time (at least 30 hours/week; excluding working students and explicitly advertised part-time positions).
- DKV Mobility is looking for the best talents and knows that they are not always available on a full-time basis.
- Many of our employees work part-time or in flexible working models.
- Please discuss with us during the application process the flexibility you require.
This text has been machine translated. Show original
Benefits
Health, Fitness & Fun
Work-Life-Integration
More net
Food & Drink
Topics that you deal with on the job
Job Locations
This is your employer
DKV Euro Service GmbH + Co KG
As a leading European mobility service provider, we devote ourselves to efficient mobility solutions for controlling commercial fleets. Our portfolio includes smart products and services around refueling, alternative propulsion options, toll handling, liquidity benefits and innovative connected services.
Description
- Founding year
- 1934
- Company Type
- Established Company
- Working Model
- Hybrid, Onsite
- Industry
- Logistics, Transportation
Data Architect
- Location
- Ratingen
- Working Model
- Hybrid, Onsite
- Diversity
- Open for all genders
