1 to 25 of 42 Semantic Layer Jobs in the UK

will own the design and implementation of our Databricks Lakehouse, drive the migration of complex legacy SQL into clean, governed pipelines, and build the semantic layer that powers self-service analytics in Omni. If you are energized by performance optimization, dimensional modeling, and infrastructure that lasts — this role … dollar. Build and maintain CI/CD pipelines (GitHub Actions or equivalent) to automate testing, validation, and deployment of data models. Architect the semantic layer in Omni — designing data models built for self-service reporting with sub-second dashboard latency. Occasionally take on the BI Developer role, building ...

enablement. You'll transform raw data into well-structured, trusted datasets that support decision-making across the business - while also helping shape a semantic layer designed for future AI and LLM-powered use cases. You'll be joining at a pivotal moment: the platform is in place, proof … concepts are underway, and the team needs someone who can own modelling, testing and semantic design from day one. What You'll Be Doing Designing and building clean, scalable data models for analytics, reporting, and self-serve Writing highly efficient SQL to transform raw data into business-ready datasets ...

Assessments, Cases), aligning with the DSFS data model and existing Netezza structures. Produce the EDW logical and physical data models, dimensional models for the Semantic Layer, and Data Lake zone architecture (Bronze/Silver/Gold). Define Enterprise Semantic Layer design, including pre-computed aggregations … equivalent. Proficiency in dimensional modelling (Kimball methodology) and enterprise data modelling. Experience with Databricks (Unity Catalog, Delta Lake) or Snowflake on AWS. Knowledge of Semantic Layer design patterns: pre-computed aggregations, business-facing views, Tableau integration. Experience migrating from legacy EDW platforms (Netezza, Teradata, Oracle) to cloud-native ...

systems) to create a unified, well-modelled, and accessible data layer. Your responsibilities will include: Integrating and modelling operational data into a cohesive analytics layer Building and maintaining robust data pipelines Developing standardised data models using SQL and dbt (analytics engineering best practices) Designing and maintaining transformations aligned … semantic/reporting layer Identifying and resolving data quality issues, including duplicates and inconsistencies Creating clean, reliable datasets to support downstream reporting and analytics Building and supporting dashboards and reporting in Lightdash Supporting and enhancing the use of Lightdash across the business Collaborating with Ops, Data, Product ...

data models. Experience with enterprise systems such as SAP BW/HANA. A track record of building reusable datasets or maintaining a metrics/semantic layer. Basic Python for automation or analytics engineering tooling. Experience collaborating in cross-functional analytics or data product teams. Why Join Us Help shape ...

cloud data warehouses Establish orchestration standards (Dagster or equivalent) Drive decisions across batch, streaming, and real-time pipelines Champion data modelling standards, semantic layers, and metric governance 🤖 AI & ML Enablement at Scale Architect data foundations supporting the ML lifecycle Design feature stores, embedding pipelines, and AI-ready datasets Enable ...

emerging tools. What you bring Expertise in Power BI. Strong SQL; Python or R is a bonus. Experience with data modelling (dimensional, star schema, semantic layers). Understanding of data pipelines and cloud platforms (AWS, Azure, Snowflake, GCP). Strong business acumen — able to turn strategy into analytics. ...

emerging tools. What you bring Expertise in Power BI. Strong SQL; Python or R is a bonus. Experience with data modelling (dimensional, star schema, semantic layers). Understanding of data pipelines and cloud platforms (AWS, Azure, Snowflake, GCP). Strong business acumen - able to turn strategy into analytics. ...

agnostic best practices. Create and maintain data mapping artifacts to support analytics, integration, and migration initiatives. Establish modeling patterns suitable for lakehouse, medallion, and semantic-layer architectures. Ensure alignment between physical analytical models and enterprise semantic definitions. 2. BusinessTechnical Translation Act as the primary interface between business ...

requirements into robust, maintainable, and reusable data products Partner with stakeholders and Analytics Business Partners to deliver impactful data solutions Build and evolve a semantic layer (e.g. Looker/LookML) to enable self-serve analytics Ensure data quality through automated testing, validation, and monitoring, proactively identifying, investigating ...

Engineering . Strong experience with SQL and relational databases . Hands-on experience building dashboards in Power BI . Experience designing data models and semantic layers for BI reporting. Knowledge of ETL tools or frameworks (SSIS, Azure Data Factory, Informatica, etc.). Experience with data warehouse platforms (e.g., Snowflake ...

Hybrid working: typically 12 days in the London office (flexible) The Analytics Engineer sits between Data Engineering and the business, owning the transformation layer and turning raw data into trusted, scalable insights. This is an exciting time to join this fast paced & growing Insurance company. Youll take ownership … analytics/BI layer and help build a single source of truth for the organisation and external partners. What youll do Build and maintain robust data models and curated datasets in the warehouse Own metric logic across the semantic layer (consistent definitions, reliable reporting) Partner with Data ...

Hybrid working: typically 1–2 days in the London office (flexible) The Analytics Engineer sits between Data Engineering and the business, owning the transformation layer and turning raw data into trusted, scalable insights. This is an exciting time to join this fast paced & growing Insurance company. You’ll take … ownership of the analytics/BI layer and help build a “single source of truth” for the organisation and external partners. What you’ll do Build and maintain robust data models and curated datasets in the warehouse Own metric logic across the semantic layer (consistent definitions, reliable ...

within Microsoft Fabric and Azure Integrate data from third-party systems and internal platforms into the data lake environment Build scalable data models and semantic layers for business reporting Build and optimise SQL queries, data models and dimensional schemas for reporting Support the continued growth of the organisation ...

Python. • Hands-on experience working with Databricks, or a strong desire to deepen expertise in it. • Expert understanding of data modelling principles and semantic layer concepts. • Experience working with Azure Data Factory or similar orchestration tools. • Ability to translate business needs into logical, scalable data models. • Comfortable working … across multiple data sources and handling pipeline design. • Experience with Power BI, including semantic models or Tabular Editor. • Curious, collaborative mindset with the ability to push back constructively and guide stakeholders. ...

will Partner with business stakeholders to design and deliver impactful dashboards, analytical products, and metric frameworks. You will build high-quality analytics datasets, semantic layers, and reusable data models that power reporting and advanced insights. You will be responsible for : Develop and maintain CI/CD pipelines for analytics ...

profile existing data sources (apps, databases, files, SaaS). Design and implement data cleansing and standardisation pipelines. Maintain data dictionaries, lineage diagrams, and semantic layers. Establish pragmatic governance: data ownership, KPIs, thresholds, and access controls. Implement automated data quality checks, dashboards, and root-cause remediation. Ensure trust, consistency ...

Design dimensional models (facts, dimensions, hierarchies, slowly changing dimensions) for BI/analytics and performance at scale. Create and manage canonical data models and semantic layers to enable consistent metrics and self-service analytics across domains. Optimise models for performance and cost (partitioning, clustering, indexing, compression, surrogate keys, distribution ...

high-quality, easy to understand, and well-documented. Create an environment that allows safe experimentation and innovation. Power BI & Analytics Leadership Lead on our semantic layer, data models, and Power BI architecture. Build and govern standard datasets used for: Executive reporting Self-service BI Data science ...

Semantic Architect Location - Erskine, Newcastle, Farnborough or London Candidates are required to be eligible for clearance What Youll Do Design Ontologies: Develop and maintain ontologies using OWL/RDF to model enterprise data domains and relationships. Build Knowledge Graphs: Create and manage enterprise knowledge graphs that unify diverse data … sources. Semantic Querying: Develop and optimise SPARQL queries for advanced data retrieval and analytics. Ensure Data Quality: Implement semantic validation rules (e.g., SHACL, OWL constraints) for data integrity and interoperability. Integrate with Enterprise Systems: Embed semantic models into data pipelines, APIs, and enterprise workflows. Collaborate with ...

Databricks, Snowflake, and similar modern data platforms Infrastructure automation, DevOps, and secure deployment patterns Data governance, metadata, and secure access frameworks Analytics, semantic layers, and enterprise reporting platforms Seniority and Leadership Expectations Operate at Principal Consultant or equivalent leadership level Own architecture strategy across large, complex client programmes Lead ...

evolve enterprise-grade data architectures, ensuring scalability, sustainability and alignment with client objectives. Solution Design & Governance Lead the design of cloud-based data platforms, semantic layers, integration patterns and data models. Establish governance standards, frameworks and principles that guide engineering teams. Stakeholder & Client Engagement Act as a trusted technical … components such as DevOps, Azure Data Factory, BigQuery, Databricks, MS Fabric, Airflow, Snowflake etc. Demonstrated experience architecting solutions using medallion architectures , including curated gold-layer models designed for analytics consumption. Strong knowledge of unity catalog (or similar), data governance, lineage, cataloguing and metadata-driven design. Awareness of cloud economics ...

about designing systems, deploying AI agents, and transforming how a business makes decisions . What you’ll own The data foundation: Build a scalable semantic layer —the single source of truth for people and AI AI in action: Create and orchestrate multi-agent systems that automate workflows ...

maintain data pipelines for a new reporting solution within the business. You'll be responsible for the build across ingestion, modelling and creating semantic layers using their GCP stack. Successful applicants will have experience with: Looker BigQuery GCP Gemini Exceptional candidates would have worked with: Retail Data ...

maintain data pipelines for a new reporting solution within the business. You'll be responsible for the build across ingestion, modelling and creating semantic layers using their GCP stack. Successful applicants will have experience with: Looker BigQuery GCP Gemini Exceptional candidates would have worked with: Retail Data ...