Senior BI Engineer – Semantic Layer & Data Modeling

Kansas City, KS - USA

Monthly Salary: Not Disclosed

Posted on: 9 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Description

Senior BI Engineer Semantic Layer & Data Modeling

A Senior BI Engineer with deep expertise in semantic layer data modeling and analytics engineering. This role will be responsible for designing governing and delivering trusted analytical data products that power enterprise BI self service analytics and embedded use cases.

The ideal candidate has a strong command of both open source semantic layer technologies and enterprise BI semantic models with a proven ability to translate complex business requirements into intuitive governed analytical models consumed by a wide range of stakeholders.

Key Responsibilities

Semantic Layer & Analytics Modeling

Design and maintain enterprise grade semantic layers including fact/dimension models relationship definitions metrics and calculated measures.
Build and evolve analytical models that balance performance usability and governance across BI tools.
Apply best practices in dimensional modeling star/snowflake schemas and metric standardization.
Define and manage business friendly metrics and KPIs to ensure consistency across all consuming tools.

Tooling & Platform Expertise

Develop and manage open source semantic layers (e.g. Cube) for headless BI and API driven use cases.
Design and support enterprise semantic models including:
- Microsoft Fabric / Power BI Tabular Models (DAX)
- LookML (Looker)
Enable interoperability and reuse of semantic definitions across multiple BI and analytical platforms.

Governance & Data Product Ownership

Establish and enforce semantic layer governance including metric definitions naming conventions versioning and access controls.
Partner with data governance teams to ensure alignment with enterprise standards and data policies.
Own analytics as data products ensuring clarity of purpose documentation quality checks and reliable delivery to end consumers.
Support auditability lineage and trust in analytical outputs.

End to End BI Delivery

Collaborate closely with business stakeholders data engineers and platform teams to gather requirements and translate them into scalable analytical models.
Drive solutions from raw data curated models semantic layer BI consumption.
Support downstream use cases including dashboards self service exploration and embedded analytics.
Optimize semantic models for performance cost efficiency and scalability.

Technical Skills

Strong experience in BI and semantic layer modeling in enterprise environments.
Deep understanding of data modeling for analytics including relationships hierarchies measures and aggregations.
Hands on experience with:
- Open source semantic layer tools (e.g. Cube)
- Microsoft Fabric / Power BI Tabular Models
- LookML
Solid SQL expertise and familiarity with modern cloud data warehouses.
Understanding of API driven analytics and headless BI patterns.

Job Description Senior BI Engineer Semantic Layer & Data Modeling A Senior BI Engineer with deep expertise in semantic layer data modeling and analytics engineering. This role will be responsible for designing governing and delivering trusted analytical data products that power enterprise BI sel...