51 to 75 of 133 Dimensional Modelling Jobs in the UK

Data & Analysis standards Ensure compliance with company data governance, risk and security policies Support the BI Manager and BI Analysts with data engineering, architecture, modelling and best practices Help upskill the BI team and promote consistent data and BI practices across the organisation ESSENTIAL SKILLS AND EXPERIENCE Strong experience … data engineering, including ETL/ELT, data pipelines and modern cloud data platforms Strong understanding of data warehousing, dimensional modelling, Kimball principles and data architecture Advanced SQL/T-SQL skills, including query development, optimisation and troubleshooting Strong Python, PySpark or similar programming skills for data manipulation ...

across data migration, integration, governance and analytics initiatives. You will bring expertise in Microsoft Azure and Microsoft Fabric, alongside a strong understanding of data modelling, data governance and enterprise data management. You will work closely with partner stakeholders, delivery teams and PACT colleagues to turn complex needs into clear … Deep knowledge of modern cloud data platforms, with hands‐on experience of Microsoft Fabric, OneLake, Azure Data Factory and related Azure services. Strong data modelling capability across conceptual, logical and physical models, including dimensional modelling, data vault or comparable approaches. Experience designing data integration, data migration, lakehouse ...

across data migration, integration, governance and analytics initiatives. You will bring expertise in Microsoft Azure and Microsoft Fabric, alongside a strong understanding of data modelling, data governance and enterprise data management. You will work closely with partner stakeholders, delivery teams and PACT colleagues to turn complex needs into clear … Deep knowledge of modern cloud data platforms, with hands‐on experience of Microsoft Fabric, OneLake, Azure Data Factory and related Azure services. Strong data modelling capability across conceptual, logical and physical models, including dimensional modelling, data vault or comparable approaches. Experience designing data integration, data migration, lakehouse ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

implementing solutions on AWS data and analytics platforms.* Proven expertise in data integration and analytics platforms on AWS, with strong understanding of data warehousing, dimensional modelling, and lakehouse/data lake concepts.* Experience with AWS cloud platform, including Amazon S3, AWS Lake Formation, AWS Glue, Amazon Redshift, Amazon ...

used for revenue reporting, ensuring consistent naming, definitions, documentation, and data quality standards. Own analytics delivery end to end, from understanding stakeholder requirements and modelling data through to dashboard development, testing, and documentation. Contribute to Kpler's internal AI revenue analytics tools by curating governed datasets, maintaining reference documentation … domain end to end. Strong experience with SQL and hands-on experience with BigQuery or an equivalent cloud data warehouse. Strong understanding of data modelling concepts, including data grain, dimensional modelling, deduplication, and slowly changing dimensions. Production experience with Looker and LookML, including building and maintaining data ...

architecture and delivery in a business with limited existing data capability Strong SQL and Python or PySpark skills, with practical experience of ELT pipelines, dimensional modelling, source control and CI/CD Experience putting data governance and self-service BI into practice, including ownership, quality standards, training … user adoption Microsoft Fabric experience, or transferable Azure Synapse or Databricks Lakehouse experience, including an understanding of medallion architecture Strong Power BI semantic modelling and DAX skills, sufficient to take responsibility for shared datasets and business measures Ability to work as the sole senior data specialist, gather requirements from ...

quality. Develop and maintain Gold Layer data marts in BigQuery using dbt Core, with a strong grasp of top-down/bottom-up data modelling methodologies (Kimball, OBT, or equivalent). Build and maintain Airflow-orchestrated ELT workflows across the retail media data platform, including attribution pipelines supporting campaign … with dbt Core (or dbt Cloud) and Airflow for orchestration and transformation at scale. Solid grounding in data warehouse and data lake architecture, including dimensional modelling and layered architectures (Gold/Silver/Bronze or equivalent). Production experience with GCP (BigQuery, Dataflow, GCS) and AWS (S3, Iceberg ...

insights, and operational decision‐making. Knowledge of Microsoft Fabric architecture, including OneLake, Lakehouses, Warehouses, Pipelines, and Notebooks. Understanding of business intelligence best practices, including dimensional modelling, data warehousing, and data governance. Experience supporting mission‐critical systems with a strong focus on uptime, stability, and service excellence. Working knowledge ...

with other members of the IT and development teams. What We’re Looking For Essential Hands-on experience with Power BI Desktop, including data modelling, Power Query and report development. Good working knowledge of DAX, including an understanding of measures, filter context and relationships. Good SQL development skills, including … joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy and consistency of data. Ability to investigate discrepancies between reports ...

data layers Lead schema design, model validation, scalable partitioning, and metadata-driven SQL frameworks Hands-on ownership of the most complex implementation work Data Modelling & Design Define and evolve data models powering SCV, segmentation, AI features, and analytics Work across dimensional, event-based, and ML-aligned data structures … line management experience — not just technical leadership Track record of building or improving engineering processes and team structures Expertise in SQL pipelines, Python orchestration, dimensional modelling, and star/snowflake schemas Experience with cloud data infrastructure, CI/CD automation, and metadata frameworks Comfortable working across product ...

including S3, Lambda, Glue, Athena, Kinesis, RDS, IAM and CloudWatch. Lakehouse architectures and open table formats such as Iceberg. Medallion-style data layering and dimensional modelling. Strong SQL and Python development skills. Infrastructure as code using Terraform. CI/CD, automated testing and modern engineering practices. SQL Server, SSIS ...

including S3, Lambda, Glue, Athena, Kinesis, RDS, IAM and CloudWatch. Lakehouse architectures and open table formats such as Iceberg. Medallion-style data layering and dimensional modelling. Strong SQL and Python development skills. Infrastructure as code using Terraform. CI/CD, automated testing and modern engineering practices. SQL Server, SSIS ...

business insights. Develop DAX measures, KPIs and calculations. Support self-service reporting capabilities across business departments. Optimise report performance and user experience. Data Integration & Modelling Integrate data from multiple sources including CRM, ERP, finance, operational, marketing, web and third-party platforms. Design and maintain logical and physical data models … Analytics Engineer or similar role. Strong experience with Microsoft Fabric (Desired). Experience developing and supporting Fabric Pipelines. Advanced Power BI skills including data modelling, DAX, Power Query and semantic models. Experience integrating and analysing data from multiple business systems and data sources. Strong SQL skills and experience working ...

better time to join Smiths. Design, build and deploy interactive Power BI dashboards and reports. Develop robust data models using star schema and dimensional modelling principles. Create and optimise DAX measures for performance and scalability. Deliver ETL processes across SAP, databases and other data sources. Gather and translate … Power BI assets in line with evolving business needs. Establish data quality checks and monitoring mechanisms. Use advanced Excel (Power Query, complex formulas, data modelling) to support reporting and automation. Qualifications Required Skills & Experience Significant experience in Data Analytics or BI development. Strong expertise in Power BI (Desktop & Service ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long‐term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high‐quality data solutions Support the transition towards modern, cloud ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long‐term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high‐quality data solutions Support the transition towards modern, cloud ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience ...

ability to explain complex topics in an easy‐to‐understand manner for both technical and non‐technical audiences. Experience of querying data warehouse dimensional models is advantageous. Familiarity with Azure data technologies, version control and CI/CD tooling (e.g. Azure DevOps, Git) for managing report and pipeline assets ...

products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible. Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. Reviewing key physical … ensuring consistent understanding across technical and business stakeholders. Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards. Qualifications Proven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production. ...

learning and AI to accelerate change across our industry. This role is an opportunity to apply and develop your expertise in analytics engineering, data modelling and visualisation to build, extend and maintain the analytics and reporting capabilities that are central to decision making across Canopius. You will contribute … reliable and aligned to approved sources. Document solutions clearly, including data sources, logic, refresh schedules, access requirements and support considerations. Follow team standards for modelling conventions, naming, testing, deployment and version control, contributing suggestions for improvement where appropriate. Support the rationalisation and redevelopment of legacy reporting solutions as part ...