19 of 19 Dimensional Modelling Jobs in London

Cleared Data Warehouse Engineer Fully Remote About the Role We are seeking an experienced Data Warehouse Engineer with strong expertise in Kimball dimensional modelling to support secure, large-scale data programmes. You will design and enhance modern data warehouse environments across cloud platforms such as Azure, Fabric … Snowflake , working within a high-security setting that requires an active SC clearance . Key Responsibilities Design and deliver Kimball-based dimensional data models Build and optimise robust ETL/ELT pipelines Develop data warehouse solutions across platforms including Azure , Microsoft Fabric , AWS , Snowflake , and related technologies Improve data ...

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

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

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

strategies. Experience integrating data via APIs and services. Clear communication skills and experience working in Agile delivery teams. Nice to Have: Data warehousing and dimensional modelling (e.g. dbt). Basic Power BI knowledge. Relevant Microsoft or Azure certifications. Reasonable Adjustments: Respect and equality are core values to us. ...

Google Cloud Platform (GCP) Experience with orchestration tools (e.g., Apache Airflow) Experience with version control (e.g., Git) Solid understanding of data warehousing concepts and dimensional modeling To apply for this role please submit your CV or contact Dillon Blackburn on or at . Tenth Revolution Group ...

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

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

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

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

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

experience with complex data transformations Experience with cloud platform - Azure Familiarity with ETL/ELT tools Strong understanding of data warehousing concepts and dimensional modelling Responsibilities Design, develop, and maintain data pipelines and data models in Snowflake Implement ELT/ETL processes using Snowflake and associated tools Optimise ...

Blocks Source system classification and data contracts Ingestion and landing architecture Standardisation validation and data quality layers Master and reference data integration Analytical and dimensional modelling approaches Semantic layer and BI consumption patterns Metadata lineage observability and monitoring Architecture Leadership Act as architectural authority and design reviewer Produce ...

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