1 to 25 of 27 Dimensional Modelling Jobs in the UK excluding London

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

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

advanced analytics or ML use cases where relevant. About You We are looking for a rigorous data engineer with strong experience in integration, modelling and delivering reliable, well-documented data solutions. You should be confident moving data from operational systems into governed analytical environments, with strong attention to quality … Fabric skills and proven experience building robust automated data pipelines. Experience with lake, lakehouse, warehouse or similar analytical platforms. Strong grasp of data modelling, quality, documentation, lineage and governance. Understanding of secure data access, GDPR and privacy-preserving methods. Ability to create trusted data assets for reporting, analytics ...

hybrid role.Key Responsibilities: Design, build, and maintain data solutions using Microsoft Fabric. Develop and optimise data pipelines, Lakehouses, and Data Warehouses. Create and maintain dimensional data models and semantic models. Support Power BI reporting and analytics requirements. Ensure data quality, performance, security, and governance. Collaborate with business stakeholders … deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge of ETL/ELT processes ...

Scala for data processing and automation. Experience with BI and visualisation tools such as Power BI, Tableau, or Looker. Understanding of data warehousing concepts, dimensional modelling, and modern data architecture. Experience integrating APIs and third-party SaaS platforms. Must have excellent stakeholder management and communication skills, with ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

grade pipelines. Expert-level SQL , including optimization and data modelling. Azure Cloud experience (ADF, Functions, Storage, Key Vault). Deep understanding of data warehousing, dimensional modelling, and scalable architectures . Proficiency in Git, CI/CD, automated testing, and modern engineering best practices. Experience with API and SFTP … Experience with Medallion/Lakehouse patterns or Databricks-style ecosystems. Experience in regulated or high-assurance data environments. Collaboration with modeling teams in engineering-modelling interfaces ...

reporting layer within the data warehouse using SQL Create and maintain reporting tables and views Work closely with data engineers to ensure outputs follow dimensional modelling best practices Investigate and resolve data quality issues, ensuring outputs reconcile with source systems Improve performance across both SQL queries and Power … Service, including publishing, workspace management, and scheduled refreshes Advanced T-SQL skills, including views, stored procedures, CTEs, and window functions Solid understanding of data modelling concepts such as fact and dimension tables, and star schemas Desirable Experience Experience with Azure Synapse or similar cloud data platforms Knowledge of Power ...

requirements Deliver insights through reports and visualisations Translate business needs into technical solutions Maintain and enhance data platforms and analytics systems Build and manage dimensional data models Conduct testing, troubleshooting and performance tuning Evaluate and improve existing BI systems Collaborate with technical teams to integrate systems Create and maintain … also required. What you'll need to succeed Essential Skills & Experience Proven experience in a data-focused role Strong background in data warehousing and dimensional modelling Understanding of database management systems, OLAP and ETL frameworks Experience with cloud data platforms (ideally Microsoft Fabric) Familiarity with Power ...

stakeholders across finance, operations and commercial teams. Roles & Responsibilities Define the technology stack and architecture for the organisation's enterprise data warehouse Establish data modelling standards, semantic layers and reusable datasets Oversee ETL pipelines across ERP, CRM and operational systems Implement data quality, governance and DataOps best practices Lead … technical authority across the data estate Requirements Experience with modern data warehouse tooling; Snowflake, Synapse, Fabric or similar Strong SQL and dimensional modelling expertise Experience designing scalable ETL/ELT pipelines Experience working with ERP and financial data environments Experience leading distributed, offshore or third-party delivery teams ...

looking for Essential skills and experience Strong, hands-on experience with Power BI development Advanced capability in DAX, Power Query and data modelling Proven experience delivering BI solutions within a structured IT environment Strong SQL skills Solid understanding of data warehousing and dimensional modelling Additional strengths Excellent ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...

existing ELT pipelines Skills and Experience: Essential to have 3+ years experience in: SQL Python DBT Cloud techs such as Snowflake, BigQuery or Databricks Dimensional Modelling such as Kimball Desirable to have experience with: CI/CD pipelines Kafka; real-time streaming Snowflake as a data warehouse Interview ...

processes that support scalable analytics and reporting Your Skills and Experience Strong commercial experience as a Data Engineer with solid foundations in SQL and dimensional modelling Experience working with Snowflake or similar cloud data warehouses such as BigQuery Good Python capability, including orchestration tools such as Airflow Proven ...

processes that support scalable analytics and reporting Your Skills and Experience Strong commercial experience as a Data Engineer with solid foundations in SQL and dimensional modelling Experience working with Snowflake or similar cloud data warehouses such as BigQuery Good Python capability, including orchestration tools such as Airflow Proven ...

partnering closely with stakeholders across the organisation. The Role Support a major data platform migration, helping to build strong architectural foundations. Design and implement dimensional models and a robust semantic layer to enable trusted, self service analytics. Introduce and embed dbt as part of the transformation and modelling … where needed. Your Skills and Experience Strong commercial experience as a BI Data Architect or BI Engineer in modern analytics environments. Proven capability in dimensional modelling and designing semantic layers for BI tools. Hands on experience with Databricks and lakehouse style architectures. Working knowledge of Unity Catalog ...

partnering closely with stakeholders across the organisation. The Role Support a major data platform migration, helping to build strong architectural foundations. Design and implement dimensional models and a robust semantic layer to enable trusted, self service analytics. Introduce and embed dbt as part of the transformation and modelling … where needed. Your Skills and Experience Strong commercial experience as a BI Data Architect or BI Engineer in modern analytics environments. Proven capability in dimensional modelling and designing semantic layers for BI tools. Hands on experience with Databricks and lakehouse style architectures. Working knowledge of Unity Catalog ...

will have the following skills and experience: Strong commercial SQL capability Experience with Power BI, Looker or similar modern BI tools Confidence working with dimensional models and semantic layers Comfortable engaging directly with stakeholders and translating business questions into analytics solutions Experience rebuilding or rationalising BI estates rather than ...

Proficiency in Azure Data Factory and DBT, with a demonstrated ability to build scalable and reliable data pipelines and transformation processes. Familiarity with data modelling concepts and techniques, including dimensional modelling. Strong problem-solving and analytical skills, with the ability to analyse complex data-related issues and provide ...

confident, data driven decisions. Key Responsibilities Design, build, and maintain analytics models that convert raw data into trusted, business-ready datasets. Own the full modelling lifecycle (staging → core → marts). Define and maintain consistent metrics, dimensions, and business logic. Implement testing, data quality checks, and SLAs to ensure reliability. … accurate, consistent, and actionable. A degree in Computer Science, Engineering, Maths, Economics, Data Science is desirable. Advanced SQL skills and experience with analytical/dimensional modelling. Practical experience with modern ELT tools (Dataform/dbt) and Git workflows. Knowledge of cloud data warehouses, ideally BigQuery. Familiarity with orchestration tools ...

interacts with these technologies. Designing scalable enterprise architectures, not ad-hoc integrations. Modern Data Architecture Lakehouse, data mesh, ELT/ETL patterns, MDM and dimensional modelling. Steering the "doers" in the team-architecting the solution, not building it yourself. Team & Practice Growth Mentoring and guiding a growing data team. … DevOps pipelines and Agile delivery. Experience with ML, generative AI and cognitive services. Expertise in lakehouse, data mesh, ELT/ETL, MDM and modelling techniques. Ability to guide delivery teams without being the hands-on builder. Willingness to travel for client sessions (primarily London). Ready to Take ...

Knowledge of Docker and containerisation Understanding of encryption techniques (Server Side and client-side) Familiarity with Amazon Textract and Comprehend Strong understanding of data modelling concepts, including dimensional models and slowly changing dimensions Additional Skills: Ability to translate customer requirements into functional technical solutions Familiarity with engineering best ...