26 to 50 of 79 Dimensional Modelling Jobs in the UK excluding London

data transformation, automation and optimisation. Hands-on experience with Delta Lake, Spark, Databricks Workflows and Structured Streaming. Knowledge of data warehousing, lakehouse architectures and dimensional modelling. Experience delivering scalable, high-quality data solutions to support analytics, reporting and machine learning. Familiarity with real-time data processing, APIs and streaming ...

preferred). Advanced SQL development and performance tuning skills. Experience with Python, PySpark, or Scala for data processing. Knowledge of data warehousing concepts and dimensional modelling. Experience with CI/CD pipelines using Azure DevOps or GitHub. Understanding cloud architecture and distributed data processing. Data Management Experience with ...

/ELT practices. Experience working with modern cloud data platforms and orchestration technologies. Experience within the Microsoft data ecosystem would beadvantageous. Experience of data modelling for reporting and analytics, including dimensional modelling and designing datasets for downstream consumption. Experience with modern engineering practices including Git-based source ...

term strategy, making this a highly visible role with significant business impact. THE ROLE You will be responsible for shaping the data architecture and modelling strategy across a modern Azure Data Lakehouse environment.Key responsibilities include: Designing and governing enterprise data models across Medallion Architecture layers. Building scalable dimensional models using Kimball methodologies and star schemas. Defining modelling standards, governance frameworks, and best practices. Designing and maintaining curated semantic layers for reporting and analytics. Collaborating with Data Engineers, Analytics teams, and senior stakeholders across the business. Producing architecture artefacts, data models, documentation, and design standards. Acting ...

deployment, optimisation and support. Key duties: Business Intelligence & Reporting Design, develop and maintain enterprise Power BI solutions Design and maintain scalable data models using dimensional modelling and star schema best practices Create intuitive dashboards, reports and visualisations that enable data-driven decision making. Develop and maintain semantic models … including: DAX Power Query Semantic Models Row Level Security (RLS) Workspace and deployment management Extensive SQL Server development experience Experience designing and implementing dimensional models Experience gathering requirements and producing technical documentation Experience working directly with business stakeholders and clients Experience troubleshooting and performance tuning reporting and database solutions ...

Databricks Structured Streaming and Azure Stream Analytics Developing and maintaining modern data platforms, including Delta Lake/Lakehouse architectures on ADLS Gen2, curated datasets, dimensional models and Azure Synapse Dedicated SQL Pools Analysing current business practices, processes and procedures, identifying opportunities to leverage Microsoft Azure Data & Analytics Services ...

Airflow. Advanced Python and SQL skills with a strong software engineering mindset. Proven experience building complex, scalable batch and event-driven pipelines. Strong data modelling experience, including dimensional modelling, Data Vault or equivalent. Experience with Dataform or similar SQL-based transformation tooling. Understanding of CI/ ...

engineering experience across batch, streaming and CDC ingestion patterns. Advanced SQL skills and strong Python development experience. Experience using dbt for data transformation and modelling would be highly beneficial. Experience building and optimising ETL/ELT pipelines. Good understanding of data warehousing, dimensional modelling and analytical data ...

proactive mindset, eager to provide guidance to less experienced developers and support collaborative pair-programming. Desirable Skills Experience with PySpark or PySQL. Experience in Dimensional Modelling and data warehousing principles. Experience with SQL Server SSAS Tabular and DAX. Exposure to SQL Server RDBMS and Managed Instance. Knowledge ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands-on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

large-scale Azure data transformation programme. You'll play a key role in shaping a modern Data Lakehouse environment, driving best practice in data modelling, governance, and analytics while working closely with senior stakeholders across the business. The Company This organisation is a well-established UK professional services business … focused on improving data visibility, strengthening governance, and enabling more advanced analytics across the business. The Role You will lead data architecture and modelling across a modern cloud platform, ensuring data is structured, governed, and accessible for reporting and analytics.Responsibilities include: Designing enterprise-wide data models within a Medallion ...

business requirements into clear data model specifications, ER diagrams, and data dictionaries* Ensure data consistency and integrity across domains through well-governed master data modelling practices* Define and enforce data model standards, naming conventions, and documentation across the Corporate Data Intelligence domain* Collaborate with analytics and BI teams … liaison between business domain owners and the data platform team**Your Profile – Ready to Join the Pack?*** Proven hands-on experience in data modelling - conceptual, logical, and physical including dimensional modelling and ER design* Strong working knowledge of SAP ERP (FI/CO, MM, SD or equivalent ...

enabled analytics, Copilot and natural language reporting capabilities. Desirable Exposure to Microsoft Fabric including Lakehouses, Warehouses, Dataflows Gen2 and Semantic Models. Experience designing dimensional models and star schemas to support reporting and analytics solutions. Azure data services, Databricks or cloud-based analytics platforms. Agile delivery environments. Data dictionaries, report ...

team if you have the following skills, knowledge and experienceStrong SQL skills and experience building analytical data models in a production environmentData modelling approaches such as dimensional modelling, star schemas, metric layers or similarWorking with dbt or similar transformation and orchestration toolsBuilding semantic models or reusable business … agents consume structured data, metric definitions and business contextExperience working with data contracts, medallion-style architecture or silver-to-gold data modelling patternsWhat success looks likeSuccess in this role is about helping the business trust and use data with confidence.You’ll create reliable analytical models, clear metric definitions ...

leadership experience working with a modern cloud data platform (must have some direct Snowflake exposure to be able to hit the ground running) Dbt modelling experience, or the demonstrable capability and willingness to own that learning quickly, alongside a commitment to continuous professional development Advanced SQL, including complex transformation … logic, data modelling and query performance optimisation Strong dimensional modelling knowledge: facts, dimensions, conformed dimensions and slowly changing dimensions Hands-on engineering credibility, with the judgement to know when to build, when to simplify, and when to stop Proven people leadership: setting direction, giving feedback, and developing ...

cloud-based data platforms. Advanced SQL skills and experience building transformation pipelines. Strong Python capability for orchestration, automation, and data tooling. Excellent understanding of dimensional modelling and scalable data architecture. Experience working with cloud technologies such as Azure, AWS, or GCP. Knowledge of CI/CD practices ...

Understanding of data management standards, regulatory compliance including GDPR and HIPAA, and security protocols Deep knowledge of entity-relationship modeling, normalization and denormalization, and dimensional modeling Proficiency with data modeling tools such as erwin Data Modeler, SAP PowerDesigner, or ER/Studio Advanced SQL skills, including ...

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

will thrive within our recognition and empowerment culture. To be successful in this role, you'll bring strong commercial experience of data warehousing, data modelling and data engineering , ideally including experience administering and working within Snowflake . You'll have strong SQL skills and experience of dbt , building data … models and flows using dimensional modelling techniques, and developing and maintaining data pipelines across multiple data sources. You’ll also be comfortable working with BI and analytics tools such as Power BI , with the ability to take complex data and translate it into clear, actionable insights for both ...

transformation processes. Key Responsibilities Analyse existing datasets and data structures to help prioritise, design and implement the enterprise data platform. Design and implement dimensional data models within Snowflake to support enterprise reporting and analytics. Build and maintain production-grade data transformation workflows using robust development, testing, version control … client data. Contribute to data engineering standards, naming conventions, development practices and CI/CD processes. Support data analysis, data architecture and enterprise data modelling activities across existing and new data platforms. Work closely with technical and business stakeholders to understand requirements and translate them into effective data solutions. ...

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

optimised analytical datasets. Own data model delivery for the domain area, ensuring documentation and data definitions are accurate and accessible. Colleague Champion data literacy, modelling best practices, and standard transformation guidelines across the organisation. Mentor trainee data practitioners on SQL standards, data testing, version control, and business domain context. … about you What we’re looking for: Skills, Qualifications and Experience As a Data & Analytics Specialist - Analytics Engineer you will have experience of: Data Modelling: Proven experience building and maintaining data models using recognised patterns (e.g., Kimball, Inmon, dimensional modelling). Semantic Layer Architecture: Hands-on experience ...

analytics solutions Extensive experience with: Azure SQL Azure Data Factory Power BI Azure DevOps Experience delivering greenfield data platform implementations Strong understanding of dimensional modelling and modern data warehouse design Experience developing scalable, secure and maintainable cloud architectures Expertise establishing CI/CD and DevOps practices for data ...

BI.* Advanced SQL skills, including complex query writing, optimisation, and working with large datasets.* Solid understanding of data warehousing principles, ETL/ELT processes, dimensional modelling, and data transformation.* Experience working with ETL/ELT tools such as Azure Data Factory, SSIS, or similar technologies.* Experience delivering ...

. Extensive SQL development and performance tuning expertise. Experience building and supporting ETL/ELT frameworks. Strong understanding of data warehousing concepts and dimensional modelling. AWS experience, including services such as S3, Glue, EMR, or PySpark . Knowledge of data governance, quality controls, and testing practices. Experience working within ...