1 to 25 of 26 Dimensional Modelling Jobs in England

world of data and technology, read on! The Role We are looking for an experienced, driven, and hands-on data engineer with strong data modelling experience, to join our growing consultancy and lead the delivery of a key migration project. You will play a key role in the migration … modern AWS-based environment. This position focuses on analysing current ETL processes, understanding existing data structures, and re-engineering them in line with dimensional and analytical modelling best practices. There will be a strong emphasis on data modelling, transformation logic, and data quality. Key to this role ...

Engineer, you will be responsible for transforming raw data into well modelled, business ready data marts and semantic layers. You will take ownership of dimensional modelling, dbt transformations, and core metrics that power BI tools used across the business. This role blends hands on technical delivery with technical … managing 2 to 3 Analytics Engineers while working closely with senior data leaders and stakeholders on multi market initiatives. Key Responsibilities * Design and own dimensional data models using Kimball methodology* Build and maintain dbt pipelines from raw to gold layer marts* Define and enforce modelling, testing, and documentation ...

Databricks (PySpark, Spark SQL) Hands-on experience with Azure Synapse Analytics (dedicated and/or serverless pools) Solid understanding of data warehousing concepts and dimensional modeling Proficiency in SQL and Python Experience with Azure data services such as Azure Data Lake Storage (ADLS Gen2) , Azure Data Factory , and Azure ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data wareho using concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data wareho using concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data wareho using concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data wareho using concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data wareho using concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

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

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

Azure cloud services. * Strong proficiency in Databricks, including PySpark, Spark SQL, notebooks, Delta Lake, and job orchestration. * Strong SQL and data modeling skills (e.g., dimensional modeling, data vault). * Experience with Azure Data Factory or other orchestration tools. * Understanding of data lakehouse architecture and distributed computing principles. * Experience with ...

spreadsheets and legacy tools. Collaborate with stakeholders to define reporting needs, translating complex requirements into actionable technical specifications. Provide expert guidance on data architecture, modelling, and analytics approaches. Contribute to policies on data governance and promote best practices across the organisation. Mentor junior BI developers and train stakeholders … Power BI for data visualisation and reporting. Hands-on experience with Azure services (Azure Data Factory, Azure SQL Server). Strong understanding of dimensional modelling (e.g., Kimball methodology). Proficiency in sourcing, manipulating, and interpreting complex datasets. Strong analytical mindset with excellent attention to detail and accuracy. Experience ...

revenue domains, enabling trusted reporting in tools such as Looker, Power BI, and Tableau. This is a hands on role with real influence over modelling standards, semantic definitions, and how data is consumed across the business. Key responsibilities Data modelling and transformation Design and build Kimball style dimensional … pipelines that are performant, tested, and easy to use Partner with Data Engineers to shape upstream data structures and improve handoffs from ingestion to modelling Implement data quality testing using dbt tests and expectations frameworks Semantic layer and analytics enablement Help define and maintain a consistent semantic layer across ...

design, build, and maintain scalable data pipelines using Azure Data Factory and Databricks to automate data ingestion, transformation, and processing workflows. Create and maintain dimensional data models and semantic layers that support business intelligence and analytics use cases. Build and optimise data transformation workflows using dbt, SQL, and Python … modern data transformation tools ( dbt strongly preferred), with experience in cloud data platforms ( Azure Databricks ) Proven experience designing and implementing scalable data architectures, including dimensional modelling, data lakehouse/warehouse concepts, and modern data stack technologies. Strong software engineering practices including version control (Git), CI/CD pipelines ...

such as Data Factory, Synapse and Azure SQL Experience using Databricks and Python in data processing workflows Strong SQL skills and practical knowledge of dimensional modelling and warehouse design Familiarity with CI/CD approaches for data and analytics solutions Confident communicator with the ability to work across ...

/Silver/Gold) patterns Build metadata-driven ingestion pipelines and transformation frameworks Develop advanced PySpark/Spark SQL notebooks for data cleansing and modelling Create production-ready semantic models and support BI teams Implement governance, security, and CI/CD best practices Engage with clients to translate business … scale transformations Integration with Dynamics 365, Dataverse, and/or Business Central CI/CD implementation using Azure DevOps or GitHub Solid understanding of dimensional modelling and Power BI optimisation Desirable Microsoft Fabric certifications Familiarity with Azure services and Power Platform Experience in consultancy environments and large enterprise ...

responsibilities: Design, build and maintain data pipelines using Azure Data Factory and Azure Databricks Develop and optimise PySpark and SQL transformations Model data using dimensional modelling principles Support ingestion of data from various data sources and formats Collaborate with BI developers, analysts and business stakeholders to understand data ...

with business stakeholders and technical teams. Key Responsibilities Administer and optimise Microsoft SQL Server environments, including performance tuning & security Own Data Warehouse operations, including dimensional modelling, indexing, and optimisation for large datasets. Design and maintain ETL/ELT pipelines with strong data quality controls. Develop and govern Power ...

Strong SQL skills and experience working with cloud data warehouses (BigQuery, Redshift, Snowflake, etc.) Solid experience building models and transformations using dbt Understanding of dimensional modelling and data transformation principles Exposure to BI tools (Looker, Power BI, or similar) and how they consume data Experience working with cloud ...

technical concepts clearly to non-technical audiences Act as a positive, approachable technical lead and support other team members Maintain robust data dictionaries and dimensional data models Apply strong analytical thinking and stay up to date with existing and emerging technologies Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources Skills, Experience & Knowledge: Development experience in SQL programming and systems integration Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology Experience within Insurance or Broking (preferred) Proven ...

experience with Power BI, SSAS, Snowflake, ADF, and HVR Proven track record running enterprise BI operations and reporting cycles Solid understanding of data warehousing, dimensional modelling, and analytics best practices Excellent communication skills and ability to work across time zones Nice to Have Experience with modern data platforms ...

data engineering with experience in cloud-based platforms. Hands-on experience with Databricks or Fabric. Strong SQL and PySpark skills. Understanding of ETL and dimensional modelling. Excellent communication and problem-solving mindset. Why Join? Work on modernisation projects including real-time reporting and AI. Structured learning and certification opportunities. ...

implement optimisation strategies. Develop and maintain a strategic roadmap for platform scalability and accuracy. Design and develop integrated data models using DBT and dimensional modelling best practices. Your Experience We’re looking for a proactive, problem-solving professional with strong technical and communication skills. Essential experience: 3+ years ...

various projects Proven experience in data engineering and architecture, with a focus on developing scalable cloud solutions in Azure, GCP or AWS. Data Modelling using Kimball, 3NF or Dimensional methodologies Analytics Engineering lean, with experience within BigQuery (GCP) with data modelling in DBT and mobile/telecoms … operationally efficient pipelines, utilising core Cloud components, such as Azure Data Factory, Big Query, AirFlow, Google Cloud Composer and Pyspark etc Proven experience in modelling data through a medallion-based architecture, with curated dimensional models in the gold layer built for analytical use Strong understanding ...

with senior stakeholders to deliver impactful solutions. Specifically, you can expect to be involved in the following: Designing and implementing both relational (3NF) and dimensional (star/snowflake) data models for large-scale financial systems and analytical platforms. Working hands-on with ETL design, metadata management, and data cataloguing … data formats (JSON, XML, Parquet). SKILLS AND EXPERIENCE The successful Data Modeller will have the following skills and experience: Proven experience in data modelling within consulting or financial services environments. Strong expertise in ERWin (or equivalent tools such as Sparx, RSA, Visio). Hands-on experience with relational ...