25 of 25 Permanent Dimensional Modelling Jobs in the UK

GraphQL APIs using Azure Data Factory and metadata-driven patterns. Apply data quality and validation rules using Lakeflow Declarative Pipelines expectations. Curated Layers & Data Modelling Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas. Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs … . Strong PySpark and Spark SQL skills within distributed compute environments. Experience working in a Lakehouse/Medallion architecture with Delta Lake. Understanding of dimensional modelling (Kimball), including SCD Type 1/2. Exposure to operational concepts such as monitoring, retries, idempotency and backfills. Mindset Good energy ...

scalability. Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity. Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics. Apply expert T-SQL and SQL Server skills for query optimisation and advanced data manipulation. Support … processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python, and R, to help drive innovation. The postholder will be line managed by the Principal BI Developer and will work closely ...

Data Warehouse Engineer, or similar. Strong hands-on knowledge of Microsoft Fabric and related services. End-to-end DWH development knowledge, from ingestion to modelling and consumption. Strong background in data modelling, including star schema, dimensional modelling and semantic modelling. Ability to orchestrate, monitoring and optimise ...

engineering standards, own key architectural decisions, and deliver scalable, reliable pipelines and models. You will: Lead the technical strategy for data engineering across ingestion, modelling, orchestration, and automation. Build and maintain high‐quality ETL pipelines using modern tooling and cloud‐native infrastructure. Develop robust data models and frameworks … similar). Experience with modern data warehouses such as Snowflake, Redshift, or BigQuery. Infrastructure‐as‐code experience (Terraform or Pulumi). Strong data modelling capability (dimensional modelling, Data Vault, etc.). Background in software engineering or backend development is highly desirable. Experience in high‐growth or smaller ...

regulatory reporting processes. This role requires a strong understanding of insurance data structures, market-specific standards, and advanced data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyd's market standards, including Core Data Record … rules. Ensure compliance with Lloyd's market regulations, GDPR, and Solvency II requirements. Required Skills & Experience Technical Expertise 10+ years of experience in data modelling within the Lloyd's of London or London Market insurance sector. Proficiency in ER modelling, relational and dimensional modelling, and data ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server … concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You’ll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you’ll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

quality, and availability across core data assets. Data Platforms, Governance & Maturity Develop and maintain enterprise data models, including master data management (MDM) and core dimensional models. Establish and embed data governance frameworks covering data quality, security, access, and regulatory compliance. Support the introduction of data standards, cataloguing, and best ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years’ hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

pipelines across operational and analytical layers, working heavily with SQL and Python-based orchestration. You’ll contribute to schema design, scalable data modelling, and metadata-driven frameworks that enable repeatable, production-ready outputs. The role also involves CI/CD automation, environment governance, and supporting the integration of machine … expertise (T-SQL, PostgreSQL or similar) Python for orchestration and data tooling Experience building ETL/ELT pipelines in cloud environments Strong understanding of dimensional modelling and data architecture principles Experience working with CI/CD pipelines and Git-based workflows Exposure to Azure, AWS or GCP Comfortable ...

tools such as SSIS and Azure Data Factory, and cleansing and manipulating datasets via SQL. , You will also be adept at designing and implementing dimensional models including star schemas, and implementing Slowly Changing Dimensions (SCD Type 1 or 2) to support accurate historical reporting and analytics. You should have ...

closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential. Responsibilities Snowflake Development: Build and optimise Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors). ETL/… Pipelines: Develop and maintain robust data pipelines using tools like dbt, Airflow, Azure Data Factory, or similar. Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics. Performance Tuning: Optimise queries, manage clustering, caching, and warehouse sizing for cost and speed. ...

between core systems (e.g. Finance, HR, CRM, case/matter management systems) Own and evolve the organisation's data architecture blueprint across ingestion, transformation, modelling, and consumption layers Provide architectural oversight for data warehousing and BI semantic models Work closely with data engineers, integration developers, BI teams, and third … security, and regulatory requirements Required Experience 5+ years' experience in data architecture, integration architecture, or senior data engineering roles Strong knowledge of data warehousing, dimensional modelling, and slowly changing dimensions Experience with iPaaS and integration platforms (MDM experience highly desirable) Exposure to cloud-based data platforms (e.g. Azure ...

experience Strong experience with the Microsoft BI stack (SSIS, SSAS, SSRS, Power BI) and SQL/relational databases. Knowledge of ETL processes, data warehousing, dimensional modelling (Kimball), and analytics/OLAP cube development. High analytical capability with strong numerical, logical, and problem-solving skills. Effective communication and stakeholder ...

develop advanced analytical models. Engagements typically begin with building high-quality semantic models and dashboards, before progressing into deeper analytical work including predictive modelling and workflow automation. This role suits someone who is technically strong, commercially aware, and comfortable working independently in a client-facing environment. Technical Skills (Essential … Strong Power BI experience (advanced DAX, dimensional modelling, performance optimisation) Professional dashboard and semantic model development Fluent SQL (complex joins, transformations, optimisation) Python for analysis (pandas, statistics, scikit-learn) Advanced Excel skills Experience & Background: proven experience in consulting or fast-moving commercial environments Strong academic background ...

experience with modern data warehouses (e.g. BigQuery) -3+ years of experience in Analytics Engineering or a related field -Technical experience with advanced modelling techniques in dbt -Understanding of ETL/ELT processes -Experience with BI semantic layers and data visualisation tools -Understanding of dimensional modelling, analytics ...

business. Knowledge Required - Knowledge of operations and supply chain centric KPI calculations methods Experience building data models and flows from various sources using Kimball Dimensional Modelling techniques. Good knowledge of data warehousing and data modelling. Knowledge of a cloud data warehouse (ideally Snowflake). Strong ETL skills ...

Required experience Proven experience (3+ years) developing complex reports and composite models. Strong SQL skills for querying data warehouses and creating views. Knowledge of Dimensional Modeling (Star Schema). Ability to translate technical data concepts for non-technical legal and business stakeholders. Experience in working with Snowflake is desirable. ...