Data Modeller – BI Semantic Layer

Job Title: Data Modeller – BI Semantic Layer

We are looking for a Data Modeller with a strong focus on BI semantic layers to join our BI & Analytics function. While the underlying physical data models are owned by a central Data Management team, this role is critical in shaping, defining, and communicating semantic layer requirements to ensure Power BI models are business-aligned, performant, and scalable .

The ideal candidate will act as a bridge between business stakeholders, BI developers, and data engineering teams, ensuring that analytical needs are translated into well-structured fact and dimension models optimized for Power BI DirectQuery .

Key Responsibilities

Collaboration with Data & Engineering Teams

• Translate business and analytical requirements into clear semantic layer specifications, including fact and dimension table definitions
• Work closely with Data Engineering teams (including Snowflake specialists) to ensure data models are optimized for Power BI DirectQuery performance
• Align semantic models with enterprise data standards and governance frameworks

Semantic Modelling & Power BI Development

• Design, build, and maintain scalable and high-performance Power BI data models using DirectQuery
• Define and manage KPIs, calculated columns, DAX measures, hierarchies, and relationships
• Ensure consistency of business logic across dashboards and reports
• Maintain and document semantic layer designs and assumptions

Business Engagement & Requirement Gathering

• Partner with stakeholders across functions to understand reporting and analytical needs
• Translate business questions into semantic modelling and KPI requirements
• Create and present semantic layer diagrams and documentation using tools such as dbt docs, dbdiagram.io, Lucidchart, or Power BI model view
• Act as a trusted advisor on best practices for BI modelling and analytics

Integration, Validation & Testing

• Collaborate with UI/UX designers and report developers to ensure semantic models are intuitive and easy to consume
• Validate data outputs against source systems and business expectations
• Drive model testing, reconciliation, and data integrity checks across key reports and dashboards
• Support production issues related to data models and semantic logic

Essential Skills & Experience

Technical Skills

• Strong expertise in dimensional modelling and semantic layer concepts
• Advanced proficiency in Power BI , including data modelling, DAX , and relationship management
• Hands-on experience with Snowflake or similar cloud data platforms
• Strong understanding of Power BI DirectQuery limitations and optimization techniques
• Experience with other semantic layer tools (e.g., AtScale, CubeJS ) is a strong advantage

Communication & Stakeholder Management

• Ability to clearly communicate data modelling concepts to both technical and non-technical stakeholders
• Proven experience in leading requirement-gathering discussions and managing stakeholder expectations
• Strong documentation and presentation skills

Soft Skills

• Ability to manage multiple priorities and switch effectively between projects
• High attention to detail while maintaining a big-picture perspective
• Excellent verbal and written communication skills
• Comfortable working in fast-paced, cross-functional environments

Desirable Tools & Experience

• Experience with data modelling and diagramming tools such as Lucidchart, dbt, ER/Studio, or similar
• Familiarity with Agile delivery methodologies
• Experience using Agile tools such as Azure DevOps or JIRA