1 to 25 of 35 Dimensional Modelling Jobs in England

engineers and driving adoption of DevOps and CI/CD best practices within the data function Contribute to the evolution of a modern event-sourcing architecture, enabling efficient data modelling, streaming, and transformation across platforms Collaborate with cross-functional teams - including Business Analysts, Product Owners, and fellow Senior Data Engineers - to translate business needs into robust technical solutions Champion … Lake and streaming Strong programming skills in Python with experience in software engineering principles, version control, unit testing and CI/CD pipelines Advanced knowledge of SQL and data modelling (dimensional modelling, fact/dimension structures, slowly changing dimensions) Managing and querying data lakes or Lakehouse's Excellent communication skills with the ability to explain complex technical More ❯

warehousing Minimum 2 years in hands-on development capacity Expertise in one or more modern cloud data platforms: Snowflake, Databricks, AWS Redshift, Microsoft Fabric, or similar Understanding of data modelling principles, dimensional modelling, and database design Proficiency in SQL and query optimization Comprehensive knowledge of ETL/ELT processes and data pipeline architecture Excellent communication skills with More ❯

warehousing Minimum 2 years in hands-on development capacity Expertise in one or more modern cloud data platforms: Snowflake, Databricks, AWS Redshift, Microsoft Fabric, or similar Understanding of data modelling principles, dimensional modelling, and database design Proficiency in SQL and query optimization Comprehensive knowledge of ETL/ELT processes and data pipeline architecture Excellent communication skills with More ❯

months), ensuring that near-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 to communicate technical concepts to both technical and non-technical audiences Proven experience in delivery of More ❯

Senior Analytics Engineer/Data Modeller role offers the chance to make a significant impact within an innovative, tech-driven organisation. You'll work at the forefront of data modelling, analytics engineering, and AI-enablement, helping shape scalable data products that power enterprise reporting, machine learning, and self-service insights. Senior Analytics Engineer/Data Modeller Responsibilities Design, build … and maintain analytical and AI-ready data marts sourced from the enterprise data lakehouse. Develop semantic models and dimensional structures optimised for BI, dashboarding, and machine learning. Ensure documentation, governance, and data consistency across domains. Collaborate with data engineers to support robust ETL/ELT pipelines and maintain end-to-end data lineage. Deploy analytics engineering solutions using dbt … single source of truth for reporting. Work with business teams to translate complex requirements into scalable, high-impact models. Support agile delivery of data products and continuous improvement of modelling standards. Senior Analytics Engineer/Data Modeller Requirements Proven experience as an Analytics Engineer, Data Modeller, or similar position in a modern cloud-based data environment. Strong SQL skills More ❯

Spotfire Lead Consultant (Spotfire to Power BI Migration) Location: Central London & Remote Type: Contract Spotfire Architect with strong data modelling skills to lead and support the migration of complex Spotfire reports to Power BI. The role requires deep technical expertise in Spotfire s visual and scripting frameworks, alongside the ability to reverse-engineer, redesign and optimize data models for …/dashboards in Spotfire 8+ years of experience in BI & analytics with at least 5 years in Spotfire (including architecture, scripting, and advanced configurations). Strong experience with data modelling for BI platforms; dimensional modelling, fact/dimension tables, normalisation/denormalisation. Hands-on expertise with IronPython scripting, custom expressions, data functions (TERR/Python/R More ❯

Commissioner's Office. Skills & Experience A degree in statistics, mathematics or a statistically-related discipline Demonstrate work experience with Microsoft Fabric, Mulesoft, BI Developer or Data Scientist Strong data modelling background with experience working with multiple data sources both cloud and on-premise Industry experience in delivering Power BI/Microsoft Analytics solutions, with a good grounding in all … BI Report Server or Cloud based Service, or similar visualisation experience. Database including MS-SQL, Oracle Database, Data warehousing, SQL and XML. Microsoft Fabric experience R or Python predictive modelling/classification Experience in building dashboards, reports and cubes using SQL, MDX, DAX, Power Query M Code, Power BI or other visualisation tools. Detailed understanding or experience of how … requirements and understand the business on different levels. Experience in developing new or maintaining and improving existing ETL processes. Experience in establishing and maintaining collaborative relationships with stakeholders. Understanding dimensional modelling ideally for Public Sector Good communications, interpersonal and presentation skills in order to influence internal stakeholders. Ability to self-manage and work in a dynamic environment. Experience More ❯

and Warehouse environments Implement CI/CD processes using Azure DevOps for secure, reliable deployment Technical Skills: Strong expertise in: Power BI and paginated reporting SQL and data architecture Dimensional modelling (star schema, snowflake, denormalised structures, SCD handling) DAX, Visual Studio and data transformation logic Azure Fabric, Azure Data Factory, Synapse, Data Lakes and Lakehouse/Warehouse technologies … for structured and unstructured data Proficiency in: PySpark, T-SQL, Notebooks and advanced data manipulation Performance monitoring and orchestration of Fabric solutions Power BI semantic models and Fabric data modelling DevOps deployment using ARM/Bicep templates End-to-end delivery of enterprise BI/data warehouse solutions Reasonable Adjustments: Respect and equality are core values to us. We More ❯

with Data Engineer in the design, build, and maintain scalable data pipelines using Azure Data Factory and Databricks to automate data ingestion, transformation, and processing workflows. DCreate 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 to create clean, well-documented … and modern data transformation tools (dbt strongly preferred), with experience in cloud data platforms (Azure Databricks, Snowflake, or similar). 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, code testing, and infrastructure as More ❯

with Data Engineer in the design, build, and maintain scalable data pipelines using Azure Data Factory and Databricks to automate data ingestion, transformation, and processing workflows. DCreate 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 to create clean, well-documented … and modern data transformation tools (dbt strongly preferred), with experience in cloud data platforms (Azure Databricks, Snowflake, or similar). 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, code testing, and infrastructure as More ❯

complex queries, stored procedures, and CTEs, with experience in query optimization, performance tuning, and designing data models for relational databases. Good understanding of relational databases, data warehousing concepts, and dimensional modelling (Kimball or similar). Experience collaborating within agile scrum delivery teams, throughout SDLC and contributing to iterative development cycles. Methodologies. Familiarity with best practices for credential management More ❯

into data solutions. Design, build, and maintain data pipelines and transformations that turn raw data into structured, analysis-ready datasets. Develop and optimise data models (including Data Vault and dimensional modelling) to support large-scale analytics. Implement and enforce data quality, governance, and validation frameworks . Write complex SQL to ensure accuracy, performance, and scalability. Collaborate with data … functional teams to deliver insights and recommendations that drive business outcomes. Key Skills: Strong proficiency in SQL for data transformation and analytics. Hands-on experience with Snowflake , dbt , Data Modelling , and Data Vault methodologies. Solid understanding of data warehousing concepts and version control (GitHub) . Experience with cloud platforms (AWS or Azure) and scripting in Python . Familiarity with More ❯

Data Modelling Consultant Location: London (3 days per week onsite) Salary: £50,000 - £65,000 + benefits The Company Join a global management consultancy known for delivering large-scale data and digital transformation projects across financial services, capital markets, and energy. You will be part of a collaborative, fast-growing Data Architecture practice that helps some of the world … with stakeholders to gather and interpret data requirements Support metadata management, documentation, and governance activities Contribute to ETL design and data movement between systems Gain hands-on experience with modelling tools such as ERWin, Sparx, or RSA Your Skills and Experience 2-4 years of experience in data modelling or data architecture Exposure to relational and dimensional modelling (3NF, star, snowflake) Strong SQL and data warehousing knowledge Experience in financial services or consulting is highly desirable Strong communication and stakeholder engagement skills More ❯

and deliver robust reporting solutions. You’ll bring: Strong SQL and ETL development skills Experience with Azure Data Factory and Power BI Solid understanding of data warehousing principles and dimensional modelling A collaborative mindset — you enjoy sharing ideas and improving processes Why Join You’ll join a growing BI function within a business that genuinely values its engineering More ❯

team development etc) Very strong technical skills that will include - SQL, SSIS, SSRS, SAS, Power BI, Power Platform, Azure Data Factory, Azure Data Lake, Databricks A good understanding of dimensional modelling techniques, including Kimball's Business Development Lifecycle Ability to design hybrid data solutions across on-prem and cloud data sources Expert with data engineering tools and automation More ❯

Role – Technology Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – UK Business Unit – DNAINS Compensation – Competitive (including bonus) Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. … strong understanding of Insurance domain 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. You will analyse existing data … teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. A strong understanding of the Insurance domain—including Specialized Insurance, London Market operations, and Regulatory Data—is essential. You will apply this domain More ❯

Role – Technology Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – UK Business Unit – DNAINS Compensation – Competitive (including bonus) Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. … strong understanding of Insurance domain 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. You will analyse existing data … teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. A strong understanding of the Insurance domain—including Specialized Insurance, London Market operations, and Regulatory Data—is essential. You will apply this domain More ❯

a team of data engineers, analytics engineers, data scientists and AI specialists to design and evolve scalable data platforms and modern data products that enable self-service analytics, advanced modelling, and AI-driven decision-making across our insurance business. What you’ll do: Design and manage scalable cloud data platforms (Databricks on AWS) across development, staging, and production environments … ensuring reliable performance and cost efficiency. Integrate and model data from diverse sources – including warehouses, APIs, marketing platforms, and operational systems – using DBT, Delta Live Tables, and dimensional modelling to deliver consistent, trusted analytics. Enable advanced AI and ML use cases by building pipelines for vector search, retrieval-augmented generation (RAG), feature engineering, and model deployment. Ensure security … contributing to architectural decisions, authoring ADRs, and participating in reviews, data councils, and platform enablement initiatives. What we’d love you to bring: Proven, hands-on expertise in data modelling, with a strong track record of designing and implementing complex dimensional models, star and snowflake schemas, and enterprise-wide canonical data models Proficiency in converting intricate insurance business More ❯

experience as a Senior or Lead data engineer Experience handling large datasets, complex data pipelines, big data processing frameworks and technologies AWS or Azure cloud experience Experience with data modelling, data integration ETL processes and designing efficient data structures Strong programming skills in Python, Java, or Scala Data warehousing concepts and dimensional modelling experience Any data engineering … in the office). To apply, press apply now or send your CV to Keywords: Lead Data Engineer/Azure Databricks/AWS/ETL/Python/data modelling Flexible working - Preston - Blackpool - Manchester - Warrington - Liverpool - Bolton - Blackburn Circle Recruitment is acting as an Employment Agency in relation to this vacancy. Earn yourself a referral bonus if you More ❯

and Airflow. Good understanding of service-oriented architecture; experience of exposing and consuming data via APIs, streams and webhooks. Experience designing scalable data models, warehouse/lakehouse architectures, and dimensional modelling for analytics. Confidence in coding, scripting, configuring, versioning, debugging, testing and deploying. Skilled in optimising queries, pipelines, and storage for cost and performance efficiency. Good understanding of More ❯

and Airflow. Good understanding of service-oriented architecture; experience of exposing and consuming data via APIs, streams and webhooks. Experience designing scalable data models, warehouse/lakehouse architectures, and dimensional modelling for analytics. Confidence in coding, scripting, configuring, versioning, debugging, testing and deploying. Skilled in optimising queries, pipelines, and storage for cost and performance efficiency. Good understanding of More ❯

as a lead data engineer/Data Engineering Manager with some management experience Experience handling large datasets, complex data pipelines, big data processing frameworks and technologies Experience with data modelling, data integration ETL processes and designing efficient data structures Strong programming skills in Python, Java, or Scala Data warehousing concepts and dimensional modelling experience Any data engineering … week in the office). To apply, press apply now or send your CV to Keywords: Head of Data Engineering/Azure Databricks/ETL/Python/data modelling Flexible working - Preston - Blackpool - Manchester - Warrington - Liverpool - Bolton - Blackburn Circle Recruitment is acting as an Employment Agency in relation to this vacancy. Earn yourself a referral bonus if you More ❯

all data projects while engaging 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 , ensuring robust data lineage and … Visio , and handling semi-structured 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 and dimensional modelling More ❯

all data projects while engaging 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 , ensuring robust data lineage and … Visio , and handling semi-structured 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 and dimensional modelling More ❯

ll bring: Experience in analytics, AI/data science, or data product environments - ideally within ad tech, media, or digital. Strong grasp of data warehousing concepts - data flows, ETL, dimensional modelling, and data quality. Solid SQL skills and the ability to interrogate complex data from diverse sources. Hands-on understanding of cloud-based data architectures A proven ability More ❯