We are seeking a Senior Semantic Layer Consultant to design and implement a business-ready semantic layer that connects enterprise data platforms with consistent, trusted metrics for analytics and reporting. You will partner with leaders, analysts, and data teams to define governed KPIs and drive alignment—apply to help build clarity and confidence in decision-making.
Responsibilities
- Design the semantic layer to translate business logic into reusable, scalable metric definitions
- Define semantic modeling standards, governance practices, and implementation guidelines for long-term maintainability
- Own metric and KPI definitions, including business rules, hierarchies, aggregation logic, and grain
- Document naming conventions, calculation methodologies, assumptions, and edge-case handling for KPIs
- Facilitate workshops with business and technology teams to gather requirements and align on definitions
- Drive consensus when metric interpretations conflict and record final decisions and rationale
- Review dimensional models, joins, and aggregation strategies to ensure accurate and performant calculations
- Collaborate with data architecture, governance, and analytics engineering teams to align semantics with underlying data models
- Support BI and analytics teams to adopt, extend, and correctly use the semantic layer
- Maintain comprehensive documentation for semantic models, business definitions, and governance standards
- Establish processes to review, approve, and manage changes to metric definitions
- Promote consistency, transparency, and trust across reporting and analytics initiatives
Requirements
- 5+ years of experience in semantic layer design, BI architecture, analytics engineering, or data modeling
- Proven leadership in facilitating stakeholder workshops and driving alignment across business and technical teams
- Strong project delivery skills to define standards, governance practices, and change-control processes for metrics
- Hands-on semantic layer platform experience with dbt Semantic Layer, LookML, Cube.dev, AtScale, or Microsoft Analysis Services
- Strong SQL skills and familiarity with analytics engineering best practices
- Strong communication skills with ability to translate business requirements into scalable semantic models
- Advanced English proficiency (C1, Advanced)
- Consultancy experience advising clients on semantic modeling and metric governance
Nice to have
- Experience with dbt and modern analytics engineering workflows
- Familiarity with data governance, metadata management, and data catalog tools
- Experience defining enterprise-wide KPI frameworks and reporting standards
- Exposure to data quality, lineage, and observability practices
- Experience working in Agile delivery environments