23 of 23 Dimensional Modelling Jobs in the UK

to translate requirements into high-impact analytical products. Design, build, and maintain Power BI dashboards that inform strategic business decisions. Use PySpark , Databricks or Microsoft Fabric , and relational/dimensional modelling (Kimball methodology) to structure and transform data. Promote best practices in Git , CI/CD pipelines (Azure DevOps), and data governance. Lead the rollout, adoption, and training … commercial, product, and operations teams. What We're Looking For 3 to 5 years of experience in data analysis, BI development, or data engineering. Strong knowledge of relational and dimensional modelling (Kimball or similar). Proven experience with: Power BI (advanced DAX, data modelling, RLS, deployment pipelines) PySpark and Databricks or Microsoft Fabric Git and CI/… a modern analytics ecosystem within Financial Services. This is a highly visible position where you will work closely with business leaders and own the full delivery process from data modelling to executive-ready insight. You will also be supported to complete the Microsoft Certified: Power BI Data Analyst Associate qualification within your first six months. Interested? Apply today or More ❯

and Microsoft Fabric using PySpark and Python Support the medallion architecture (bronze, silver, gold layers) to ensure a clean separation of raw, refined, and curated data Design and implement dimensional models such as star schemas and slowly changing dimensions Work closely with analysts, governance, and engineering teams to translate business requirements into data solutions Apply data governance and lineage … on experience in PySpark Exposure to Azure Databricks, Microsoft Fabric, or similar cloud data platforms Understanding of Delta Lake, Git, and CI/CD workflows Experience with relational data modelling and dimensional modelling Awareness of data governance tools such as Purview or Unity Catalog Excellent analytical and problem-solving ability with strong attention to detail Nice to More ❯

together! The Role As a Senior Principal Data Scientist in the Advanced Quantitative Scientists group you will be responsible for the discussion and implementation of data science and high-dimensional modelling methodologies applied to patient-level data (including various biomarker, clinical and outcomes data) across clinical development in Neuroscience. You will combine your data science and AI skills … or medicine to identify opportunities for influencing internal decision making and research collaborations. You will perform hands-on analysis of integrated clinical, imaging, digital, fluid biomarkers outcomes and high-dimensional, patient-level biomarker data from clinical trials and the real world to generate fit-for-purpose evidence that is applied to decision making in drug development programs. You will … data in a clinical trial (GxP) setting. Strong knowledge and understanding of (multivariate implementations of) statistical methods such as time to event analysis, machine learning, meta-analysis, mixed effect modelling, longitudinal modelling, Bayesian methods, variable selection methods (e.g., lasso, elastic net, random forest), design of clinical trials. Familiarity with statistical and analytical methods for high dimensional data 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 ❯

We are seeking a Data Engineer with strong experience in SQL, data modelling, and ETL development, ideally complemented by exposure to cloud data platforms and business intelligence tools. The ideal candidate will have hands-on experience designing and maintaining data pipelines, ensuring data integrity, and supporting analytical initiatives across the business. This role is perfect for someone with a … Experience with ETL tools such as SSIS, Azure Data Factory, or similar. Familiarity with relational databases (e.g., MS SQL Server, MySQL, PostgreSQL). Exposure to data warehousing concepts and dimensional modelling (e.g., star/snowflake schemas). Experience working with cloud platforms (preferably Azure, but AWS or GCP also valuable). Understanding of data governance, data quality, and More ❯

across the organisation. What you'll be doing: Build and maintain scalable data pipelines using Azure Data Factory and Databricks Develop transformation workflows in dbt, SQL, and Python Design dimensional models and semantic layers to support analytics use cases Implement automated data quality checks, monitoring, and alerting systems - linking issues to business impact Create reusable data assets and documentation … related roles Strong proficiency in SQL, Python, and dbt (strongly preferred) Hands-on experience with Azure Databricks and cloud-based data platforms (Snowflake experience also valued) Solid understanding of dimensional modelling, lakehouse/warehouse design, and modern data stack Familiarity with Git, CI/CD, and software engineering best practices Experience with Power BI (or Tableau/Looker More ❯

across the organisation. What you'll be doing: Build and maintain scalable data pipelines using Azure Data Factory and Databricks Develop transformation workflows in dbt, SQL, and Python Design dimensional models and semantic layers to support analytics use cases Implement automated data quality checks, monitoring, and alerting systems - linking issues to business impact Create reusable data assets and documentation … related roles Strong proficiency in SQL, Python, and dbt (strongly preferred) Hands-on experience with Azure Databricks and cloud-based data platforms (Snowflake experience also valued) Solid understanding of dimensional modelling, lakehouse/warehouse design, and modern data stack Familiarity with Git, CI/CD, and software engineering best practices Experience with Power BI (or Tableau/Looker 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 ❯

integration Integration & Interoperability Experience connecting Microsoft BI tools with Tableau, Amazon QuickSight , or similar platforms Understanding of REST APIs , Power BI Embedded , and programmatic data access patterns Data Engineering & Modelling Strong T-SQL skills for data retrieval and performance tuning Knowledge of dimensional modelling , star/snowflake schemas , and data warehouse best practices Preferred Qualifications Microsoft certifications More ❯

inflight activities using Microsoft information architecture. Contribute to ERP implementation projects and data migration activities. Ensure data governance and compliance standards are maintained throughout all initiatives. Core Requirements Data Modelling Expertise: Strong experience in developing and maintaining logical and conceptual data models. Microsoft Information Architecture: Solid understanding of Microsoft Purview and related data governance tools ERP Implementation: Hands-on … principles. ETL/ELT Processes: Experience designing and implementing data integration workflows. Business Intelligence: Knowledge of reporting and analytics platforms (Power BI, SSRS, or similar) Data Warehousing: Experience with dimensional modelling and data warehouse architecture patterns API Integration: Understanding of REST/SOAP APIs and data service architectures. Data Security: Knowledge of data privacy regulations (GDPR) and security More ❯

in an Agile environment. Expert data reporting and visualisation using Power BI & strong Power Query and DAX skills. Experience of working with large data sets in an enterprise environment. Dimensional model design and implementation. Experience in Microsoft data components including: Azure Analysis Services Databricks Azure SQL Data Warehouse (Synapse Analytics) Tools and techniques for ensuring data quality, security, validation 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 ❯

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 ❯

manoeuvres obstacles to deliver results Critical thinking skills to identify root cause and permanent resolution Experience with REST based API Experience with PowerBI Experience in data warehouse design (e.g., dimensional modelling) Experience with cloud technologies and Python would be considered as advantage. Commercial experience of Business Intelligence development using SQL Server 2017 and higher version, SSDT Including IS More ❯

and steer end-to-end implementations across FP&A, Workforce, Operational, and Supply Chain planning. Responsibilities: Discovery, blueprinting, sprint planning, build, SIT/UAT, cutover, and hypercare. Solution architecture, dimensional modelling, Rules/Feeders strategy, TurboIntegrator (TI) processes, performance tuning, security, and governance. Build PAW books, visualisations, and guided workflows; enable Planning Analytics for Excel (PAfE). Define …/Feeders, TI scripting, PAW and PAfE, hierarchies, security, and performance optimisation. Consulting skills such as requirements facilitation, stakeholder management, and strong written/verbal communication. SQL and data modelling fundamentals. UK-based and able to travel to client sites when needed. Nice-to-haves Experience with Bedrock, Arc, Pulse, IBM Planning Analytics on Cloud, or containerised/DevOps … Salesforce/Snowflake/Databricks. Cognos Analytics exposure and report packs for financial close/management reporting. Domain depth in FP&A (budgeting/forecasting, driver-based planning, scenario modelling) and/or S&OP/IBP. Professional certification in IBM Planning Analytics or related EPM tools. More ❯

either at enterprise level or in large-scale delivery.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 methodologiesAnalytics Engineering lean, with experience within BigQuery (GCP) with data modelling in DBT and mobile/telecoms industry experience would be beneficial … Considerable experience designing and building 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 and or use of unity catalog alongside core More ❯

a team of Data Engineers on 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 industry experience would be … Considerable experience designing and building 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 and or use of unity catalog alongside core More ❯

Engineering Architect and implement cloud-native data platforms (AWS S3, Glue, Athena, Redshift, QuickSight). Build reliable, governed data pipelines with CI/CD and infrastructure as code. Design dimensional models and deliver robust SQL/Python transformations. Systems Integration & Application Support Provide expert-level support for transport, warehouse, and fleet systems (TMS/WMS/FMS). Develop … Proven track record in designing and deploying production-grade ETL/ELT pipelines. Experience supporting and integrating operational systems (TMS/WMS/FMS). Solid understanding of data modelling, performance tuning, and infrastructure as code. Desirable Skills & Certifications AWS or Microsoft certifications (e.g., Data Analytics Speciality, DP-203, PL-300). Experience with Azure Data Factory, Kafka/ More ❯

Server, Prep, Bridge, Data Management, etc.) or Qlik (specifically Sense, NPrinting) Experience in designing ETL processes including knowledge of data warehousing strategies and theories Intermediate to advanced understanding of dimensional modelling (Star/Snowflake Schema) Ability to both optimize your own report performance as well as audit existing reports for optimization opportunities Clear track record of forward-thinking More ❯

real impact. You'll collaborate with engineers, analysts, and stakeholders to deliver clean, trusted, and accessible data. Key Responsibilities: Develop and maintain data pipelines using Databricks and ADF Create dimensional models and transformation workflows using dbt Implement automated data quality checks and monitoring systems Empower business users through self-service analytics using Power BI Document technical processes and uphold … ll Bring: 5+ years in data or analytics engineering roles Proficiency in SQL, Python, and dbt Experience with Azure or similar cloud data platforms Strong understanding of data architecture, modelling, and governance Familiarity with CI/CD, Git, and infrastructure as code principles Excellent problem-solving and communication skills If this sounds like a good fit, and you can More ❯

Data Delivery Team in designing and building scalable, future-proof data assets within the Microsoft Azure ecosystem. This role involves technical consulting, hands-on development, and leadership in data modelling, orchestration, and semantic layer design. Key Responsibilities: Provide technical consulting to the Data Engineering Manager during the design phase. Collaborate with a small team of Business Data Engineers to … build new data assets. Lead the design and development of dimensional data models and Power BI semantic models. Replace legacy SAP Business Objects universes with modern Azure-based solutions. Utilize Azure Data Factory (ADF), stored procedures, and Azure Synapse for data processing. Guide the team on best practices, architecture, and documentation standards. Engage with stakeholders to ensure solutions are … Experience: 10+ years of experience in data engineering, BI, or data architecture roles. Strong expertise in Azure Synapse, ADF, SQL, and Power BI. Proven experience in designing and implementing dimensional models and semantic layers. Familiarity with metadata management tools (e.g., Collibra) and model curation tools (e.g., Tabular Editor). Excellent communication and stakeholder management skills. Experience working in agile More ❯

feedback efficiently in an iterative manner Develop and abide by standard methodologies for scalable and repeatable insights. Translate existing spreadsheets/mockups and business problems into sophisticated Anaplan multi-dimensional models Modify existing models as part of a connected solution, optimization, or to incorporate new functionality Implement standard processes and documentation for Anaplan models Lead data integration and migration More ❯

data systems You Will Demonstrate Deep knowledge of the Azure data stack (Azure SQL Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server More ❯