26 to 49 of 49 Dimensional Modelling Jobs in the UK

Senior Data Modeller to design and govern enterprise-grade data models across core insurance domains. This role requires deep domain knowledge, hands-on modelling expertise, and the ability to work closely with senior stakeholders. Key Responsibilities Design and maintain enterprise data models across policy, underwriting, claims and reinsurance Develop … govern Data Vault and Dimensional models Select appropriate modelling approaches based on integration, analytics and audit requirements Design data structures aligned to cloud and Medallion architectures Lead data modelling workshops and design sessions Embed data quality, governance, and traceability into models Required Experience: Extensive experience ...

thinking to solvereal businessproblems, support excellent customer service, and help deliver our vision of Improving Peoples Lives. WhatYoullDo: Power BI;Coding DAX Measures and Dimensional Models. Developing & delivering visually compelling Power BI Dashboards & Reports to specification. Delivering data engineeringsolutions with Microsoft Fabric,SQLand Python. Developing & maintaining ETL pipeline solutions ...

Data Analyst plays a critical role in delivering high-quality analytical insight that drives decisions across AJ Bell. The role blends advanced analytics, data modelling, and stakeholder engagement to deliver solutions that are accurate, scalable, and aligned to our strategic data ambitions. The jobholder will support cloud transformation, adoption … Delivery & Technical Excellence Deliver high-quality analytical outputs for senior data leadership. Proactively deep dive and explore challenges to create recommendations Conduct data design, modelling and exploration to support trusted reporting. Perform data discovery to understand new and existing data sources. Produce compelling visualisations and dashboards using Power BI. ...

Lead Data Modeller to play a critical role in this strategic transformation. They are looking for an individual with a unique blend of Data Modelling and Data Analysis expertise, supported by a strong foundational understanding of architecture. You’ll be responsible for building and shaping the core data architecture … consumption needs and translate them into high‐quality physical data models. You’ll bring strong knowledge of both AI‐driven data design and traditional modelling semantics, balancing business strategy with technical detail. Responsibilities as a Lead Data Modeller: Design and own the Cross-Group Data Model. ...

business outputs. Validate that the new warehouse accurately replicates existing reporting and MI , identifying discrepancies and data gaps. Support the design and build of dimensional models where necessary. Perform reconciliation and migration testing , producing exception reporting and supporting issue resolution. Document data lineage , transformations, and dependencies from source systems ...

deliver actionable data solutions Solid SQL skills, with the ability to write complex queries and optimise for performance Familiarity with data warehousing concepts, dimensional modelling, and ETL/ELT processes Experience with data quality assurance, testing frameworks, and troubleshooting data issues Strong communication skills and the ability ...

requirements into technical BI solutions, including KPIs, metrics, and visual narratives. Ensure reports are intuitive, performant, accessible, and aligned to UX best practices. Data Modelling and Analytics: Develop robust data models using star and snowflake schemas. Write and optimise complex SQL queries, views, and stored procedures. Implement and maintain … best practices. Provide insight and recommendations based on data trends and analysis. About You Strong experience with Power BI (Power Query, DAX, data modelling, visuals). Advanced SQL skills for data transformation and performance optimisation. Hands-on experience with Microsoft SQL Server and/or Azure data services. Experience ...

looking for an experienced Data Design Analyst/Data Modeler with 6 8 years of experience to take end-to-end ownership of data modelling for data migrated from Oracle to Azure Microsoft Fabric. Key Responsibilities Design and implement conceptual, logical, and physical data models in Azure MS Fabric. … Lead data modelling activities for Oracle-to-Azure migration initiatives. Define and optimize Medallion Architecture layers (Bronze, Silver, Gold). Translate business and analytical requirements into robust data structures. Ensure data integrity, performance, scalability, and compliance with governance standards. Collaborate with data engineers, architects, and business stakeholders. Data Analysis ...

business teams to ensure data is accurate, well-defined, and easy to use. Key Responsibilities Design, develop, and maintain enterprise-wide data models (dimensional/star schemas) Establish and enforce consistent definitions for key metrics and entities Collaborate with analysts and BI teams to improve reporting accuracy and performance … analytics engineers Work closely with data engineers and data scientists to support advanced analytics and AI initiatives Skills & Experience Proven experience in data modelling or data architecture (typically 5+ years) Strong expertise in dimensional modelling (e.g. Kimball methodology) Experience with modern data platforms and governance tools Advanced ...

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

working in a Devops Agile Environment with differing skill levels. Experience of Implementing advanced DW techniques, including but not limited to SCD, index strategies, Dimensional Modelling, Performance Optimisation Able to communicate a technical solution to a wide audience of technical and non-technical colleagues and clients. Qualifications/ ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

data models across policy lifecycle, underwriting, pricing, claims, reinsurance, and delegated authority domains. Develop and govern Canonical Data Models, Data Vault (RDV & BDV), and Dimensional models, selecting the right approach based on integration, auditability, and analytics needs. Model data for modern cloud platforms aligned with Medallion Architecture (Silver, Gold … Semantic layers). Translate complex London Market business rules into reusable, well-defined data assets. Lead data modelling workshops and collaborate with underwriting, claims, finance, actuarial, and operations teams. Engage senior stakeholders to validate assumptions, standards, and design decisions. Embed data quality, reconciliation, lineage, and audit considerations into models. ...

PySpark, Spark SQL beneficial). Experience working with structured/unstructured data, delta lake patterns, partitioning, and scalable pipeline design. Strong understanding of data modelling, including Kimball dimensional modelling. Awareness of data governance, privacy, security, and compliance. Experience with Git for version control and collaborative deployment workflows. Excellent ...

high-quality reporting, trusted insights, and data-driven decision-making at scale. What You'll Be Doing: Building curated, analytics-ready datasets using modern modelling techniques Developing robust transformation pipelines using SQL and PySpark Collaborating with Data Engineers to enhance the data platform Translating business needs into scalable, well … role Strong SQL skills and experience with complex data transformations Hands-on experience with PySpark and modern data platforms (Lakehouse preferred) Solid understanding of dimensional modelling Strong communication skills - able to work across technical and business teams A passion for clean, reliable, high-quality data ...

Office) Salary: Up to £90,000 This is an exciting opportunity to join a high-growth consultancy environment where you will shape data modelling standards, influence enterprise-level design, and work directly with senior stakeholders across complex financial services programmes. If you enjoy combining hands-on modelling with … strong footprint across financial services and energy. Their data capability exceeds 300 specialists, and their Data Architecture function is known for delivering high-quality modelling, strategy and metadata solutions across large-scale transformation programmes. They operate in a collaborative, low-ego environment where expertise is valued and career progression ...

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

model redesign, and production cutover. Expert-Level PySpark & Python Skills. Strong ability to design, optimize, and refactor distributed data processing workflows. Advanced SQL & Data Modelling Expertise. Experience in dimensional modeling, lakehouse architecture patterns, and query optimization. Cloud Platform Experience (Azure preferred). Hands-on experience deploying and managing ...

architecture Develop analytics‐ready datasets that power trusted reporting and dashboards Translate business requirements into well‐structured SQL and PySpark transformations Contribute to data modelling decisions across multiple business domains Apply data quality checks, testing and performance best practices to pipelines Work within existing CI/CD processes … senior Analytics Engineers within the team Your Skills & Experience: Commercial experience as an Analytics Engineer or in a similar data-focused role Solid data modelling skills, including experience with dimensional models Hands‐on experience writing PySpark in a Lakehouse or big data environment Strong SQL skills for building ...

successful Analytics Engineer will have the following skills and experience: Strong commercial experience as an analytics focused engineer, rather than an analyst. Advanced data modelling capability, including dimensional modelling. Strong PySpark and SQL skills in production environments. Hands on experience with Databricks, including pipelines and governed data environments. ...

successful Analytics Engineer will have the following skills and experience: Strong commercial experience as an analytics focused engineer, rather than an analyst. Advanced data modelling capability, including dimensional modelling. Strong PySpark and SQL skills in production environments. Hands on experience with Databricks, including pipelines and governed data environments. ...

successful Analytics Engineer will have the following skills and experience: Strong commercial experience as an analytics focused engineer, rather than an analyst. Advanced data modelling capability, including dimensional modelling. Strong PySpark and SQL skills in production environments. Hands on experience with Databricks, including pipelines and governed data environments. ...