Data Modeler

PRIMUS Global Solutions (PRIMUS UK & Europe); Stockholms län; On-site; SEK 900,000 - 1,350,000; Full time

Job summary

PRIMUS Global Solutions (PRIMUS UK & Europe) seeks a Senior Data Modeler to design scalable enterprise data models supporting analytics, reporting, and modernization. You will work on data warehousing, governance, and cloud platforms, collaborating with architects and business stakeholders.

Key focus areas include conceptual/logical/physical modeling, dimensional modeling (star/snowflake), Data Vault 2.0, and historical/SCD techniques to ensure scalable, governed data solutions.

Qualifications

• Proficiency in ANSI-SQL and dbt for modeling and transformations.
• Experience designing enterprise data models (conceptual, logical, physical).
• Strong knowledge of Snowflake and data warehousing concepts.

Responsibilities

• Develop conceptual, logical, and physical data models.
• Design dimensional models (star/snowflake) and Data Vault 2.0 approaches.
• Implement historical/temporal modeling and SCD techniques.
• Collaborate with architects and engineers on data architecture.
• Support cloud data platforms and lakehouse architectures.

Skills

ANSI-SQL

dbt

Snowflake

Data Modeling

Data Warehousing

Job description

Seeking a Senior Data Modeler with strong expertise in enterprise data modeling, data warehousing, ANSI-SQL, dbt and Snowflake. The role involves designing scalable, governed data models supporting analytics, reporting, integration and data modernization initiatives.

Key Responsibilities

• Develop Conceptual, Logical and Physical Data Models.
• Design Dimensional, Star/Snowflake, 3NF, Data Vault 2.0 and Hybrid models.
• Implement Historical/Temporal Modeling, SCD, Fact, Event, Master and Reference Data models.
• Create Data Dictionaries, Business Glossaries, Metadata and Business-to-Data mappings.
• Perform data profiling, source-to-target mapping, transformation and reconciliation for migration/modernization projects.
• Collaborate with architects, engineers and business stakeholders on data architecture and solution design.
• Ensure data models meet governance, quality, performance and scalability standards.
• Support modern cloud data platforms and lakehouse/Medallion architectures.

Mandatory Skills

ANSI-SQL | dbt | Snowflake | Data Modeling | Data Warehousing

Good to Have

Data Vault 2.0 | SCD | Data Governance | Data Lineage | Data Migration | Lakehouse | Medallion Architecture