Senior Data Modeler

Our client is the largest specialist in geotechnical contracting globally.

Their diverse techniques, whether used individually or in combination, address various challenges across the construction industry. This includes industrial, commercial, and residential developments, as well as critical infrastructure projects like dams, tunnels, transportation, and water treatment facilities, alongside initiatives to tackle environmental issues.

The global expertise and extensive experience provide access to innovative solutions led by the brightest minds in the industry.

With approximately 10,000 employees and operations spanning five continents, we bring the resources, skill, and stability needed to respond swiftly, execute projects effectively, and maintain a strong focus on safety.

This project focuses on designing and building dimensional data models for an enterprise data platform.

The Data Modeler will lead the design of conceptual, logical, and physical data models, working closely with business stakeholders and SQL Developers.

The goal is to create scalable, reusable, and well-structured data models that support business intelligence, reporting, and analytics.

You will work closely with SQL Developers, business stakeholders, and technical teams in an international environment.

The Data Modeler will lead the modelling activities, define standards, and guide the SQL Developers during implementation to ensure the models meet business and technical requirements.

• Interview process that respects people and their time
• Professional and open IT community
• Internal meet-ups and resources for knowledge sharing
• Time for recovery and relaxation
• Bright online and offline events
• Opportunity to become part of our internal volunteer community

• Lead the end-to-end data modelling process, from business requirements to conceptual, logical, and physical data models.
• Design dimensional models using Kimball methodology, including star schemas, fact tables, dimensions, and slowly changing dimensions.
• Work with business stakeholders to understand processes, define KPIs, and translate requirements into data models.
• Design data structures for Lakehouse and Medallion Architecture (Bronze, Silver, Gold).
• Analyse source systems and define source-to-target mappings, ideally using Microsoft Dynamics 365 data.
• Define data modelling standards, naming conventions, and best practices.
• Create and maintain data dictionaries, business glossaries, metadata, and data lineage documentation.
• Collaborate with SQL Developers on implementation, performance optimisation, and data quality.
• Review and validate SQL implementations against approved data models.
• Ensure data models support Power BI reporting and analytics.
• Participate in Agile delivery and communicate regularly with technical teams and business stakeholders.

• Strong experience in enterprise data modelling, covering conceptual, logical, and physical models.
• Expert knowledge of Kimball dimensional modelling, including star schemas, fact and dimension tables, surrogate keys, slowly changing dimensions (SCD Types 1, 2, and 3), and enterprise bus matrices.
• Experience gathering business requirements and translating them into scalable data models.
• Strong understanding of Data Warehousing, Lakehouse architecture, and Medallion Architecture (Bronze, Silver, Gold).
• Experience designing physical models using Delta/Parquet tables, including partitioning and performance considerations.
• Experience with source data analysis, profiling, and source-to-target mappings.
• Proficiency with data modelling tools such as Erwin, ER/Studio, Sparx EA, PowerDesigner, or Visio.
• Strong SQL skills for data validation and model prototyping.
• Experience with data governance, metadata management, data dictionaries, and data lineage.
• Understanding of Power BI semantic models and reporting requirements.
• Strong communication and stakeholder management skills.
• Experience working independently in Agile delivery teams.

Nice to have:

• Microsoft Fabric (Lakehouse, Warehouse, OneLake).
• Experience with Microsoft Dynamics 365 (Customer Engagement and Finance & Operations) or similar ERP platforms.
• Microsoft Purview or similar data governance tools.
• Experience with Power BI Direct Lake.
• Experience in large enterprise or regulated environments.