Data Modeller – BI Semantic Layer

Location: Bengaluru

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 Direct Query .

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 Direct Query 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  Direct Query
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 Direct Query  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 Dev Ops  or  JIRA