1 to 25 of 34 Remote/Hybrid Dimensional Modelling Jobs in the UK excluding London

data transformation, reconciliation, profiling and analysis across OLTP and analytical data platforms. Design data models for operational and analytical use cases, including dimensional modelling, slowly changing dimensions, lakehouse and data-lake patterns. Work with platforms such as Snowflake and relational databases including DB2 and PostgreSQL, applying sound principles … experience writing testable and maintainable code. Strong SQL proficiency and practical understanding of OLTP databases, relational design and query performance. Strong understanding of data modelling, data warehousing, dimensional modelling and slowly changing dimensions. Experience designing and implementing ETL/ELT pipelines and working with data‐lake, lakehouse ...

built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. You’ll also provide guidance on modelling best practices, data standards and business terminology, helping establish a consistent and trusted data foundation that supports both operational decision‐making and strategic insight. What … Data Engineers to validate models against ingestion pipelines and sample data Providing high‐quality model documentation to support downstream development and analytics Maintaining data modelling standards and best practices across squads Applying change management principles to ensure consistency and traceability of model changes Supporting governance and metadata management using ...

built on robust, scalable information models that align with enterprise architecture, governance standards and domain ownership principles. You’ll also provide guidance on modelling best practices, data standards and business terminology, helping establish a consistent and trusted data foundation that supports both operational decision-making and strategic insight.**What … Data Engineers to validate models against ingestion pipelines and sample data* Providing high‐quality model documentation to support downstream development and analytics* Maintaining data modelling standards and best practices across squads* Applying change management principles to ensure consistency and traceability of model changes* Supporting governance and metadata management using ...

processes. This creates an excellent opportunity for a Senior Data Architect to make a lasting impact. The Role You will lead the data modelling and architecture strategy across a modern Azure Data Lakehouse environment, ensuring scalable and governed data solutions that support both current reporting and future analytical … cases. Key responsibilities include: Designing and governing enterprise-wide data models across Medallion Architecture layers. Creating curated semantic and analytical data models using dimensional modelling and Kimball methodologies. Defining data modelling standards, governance frameworks, and data feed specifications. Collaborating with Data Engineers, Analytics Engineers, and business stakeholders ...

skills, including experience with T-SQL and DAX Experience designing and developing ETL and ELT data pipelines A solid understanding of data warehousing, data modelling, dimensional modelling and data architecture Strong analytical and problem-solving skills Experience gathering, analysing and refining requirements with business stakeholders The ability ...

scale. You will have strong experience in data architecture, ETL development, and modern data warehousing practices, including the application of Kimball methodology and dimensional modelling, alongside a proven track record of building reliable, high-performance data solutions in a business-focused environment. This is a newly created role … transformation logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric ...

senior level while remaining hands-on with architecture and modelling. The Role You will act as the technical authority for data architecture and modelling across a modern Azure environment. Key responsibilities include: Designing and governing enterprise-wide data models across a Medallion Architecture framework Creating curated data models using … dimensional modelling and Kimball methodologies Defining modelling standards, governance frameworks, and data feed specifications Supporting the design of semantic layers that enable reporting, analytics, and future AI use cases Collaborating closely with Data Engineers and Analytics Engineers in an agile delivery environment Producing architecture documentation, diagrams ...

documenting data lineage, transformations and business definitions to support transparency and trust in data. Promote best practices for data governance, accuracy and consistency. Data Modelling & Architecture Support Support the design, development and maintenance of logical and physical data models across business domains. Assist with dimensional modelling activities … layers. Help define and document data flows, business entities and relationships across enterprise systems. Contribute to the ongoing development of architecture standards, principles and modelling best practices. Support metadata management, data catalogue and data discoverability initiatives. Requirements & Business Engagement Engage with business stakeholders to understand requirements, pain points ...

transformation. You'll play a key role in shaping the future of the company's data platform, becoming the go-to expert for data modelling and architecture whilst helping drive the move towards advanced analytics and data-driven decision making. THE COMPANY Our client is a well-established professional … platform, the business is now focused on building innovative data solutions and creating greater value from its data assets. THE ROLE Own the data modelling and architecture strategy across a modern Azure Data Lakehouse environment Design and govern enterprise-wide data models across Medallion Architecture layers Create scalable curated ...

scalability and end-user experience. Apply data security controls and reporting governance best practices. Support testing, deployment and ongoing optimisation of reporting products. Data Modelling & Analytics Design robust dimensional models to enable accurate and consistent reporting. Build and maintain fact and dimension structures aligned to business needs. Work … training, adoption and knowledge sharing. Required Experience We're interested in candidates who can demonstrate strong commercial experience across business intelligence, reporting and data modelling disciplines. Technical Requirements Proven expertise delivering Power BI solutions in enterprise environments. Advanced DAX development experience. Strong SQL querying and performance optimisation skills. Experience ...

DeliveryLead a concept through our solution development lifecycle considering standard principles like optimisation and scalability.Oversee end-to-end data processes such as ingestion, transformation, modelling, and integration across multiple external, facing projects.Oversee end-to-end data processes such as ingestion, transformation, modelling, and integration across multiple external, facing … Java, or C# also beneficial).Strong SQL skills and deep understanding of relational databases, non-relational stores, and data warehouse principles.Solid experience with data modelling methodologies (dimensional modelling, star/snowflake schemas, data vault, etc.).Experience designing and operating ETL/ELT pipelines and modern workflow orchestration ...

Lakehouse Architecture, and Medallion Design Patterns. Strong hands-on knowledge of Databricks, Spark/PySpark, SQL, and data engineering best practices. Expertise in data modelling techniques including dimensional modelling, Data Vault, and canonical data models. Strong understanding of data integration, ETL/ELT frameworks, API integration ...

solid foundation in systems development: must understand the system development life cycle, project management approaches, and requirements, design, and test techniques.Demonstrable experience of data modelling and design in a large complex organisation Experience and understanding of both established and emerging data technologies, including established data management and reporting technologies.Expert … knowledge of SQL databases alongside some knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured dataStrong understanding of various data modelling methodologies (e.g., dimensional modelling, data vault).Demonstrate a good understanding of Data/Information Governance principles and familiarity with processes, policies ...

solid foundation in systems development: must understand the system development life cycle, project management approaches, and requirements, design, and test techniques.Demonstrable experience of data modelling and design in a large complex organisation Experience and understanding of both established and emerging data technologies, including established data management and reporting technologies.Expert … knowledge of SQL databases alongside some knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured dataStrong understanding of various data modelling methodologies (e.g., dimensional modelling, data vault).Demonstrate a good understanding of Data/Information Governance principles and familiarity with processes, policies ...

Working closely with the Business Intelligence Manager, you'll play a key role in delivering end-to-end BI solutions, covering data ingestion, transformation, modelling and visualisation. You'll work closely with stakeholders to understand business requirements, define KPIs and translate these into effective technical solutions. The role will … enabled analytics such as Copilot and natural-language insight. If you're an experienced BI Developer with strong Power BI, SQL and data modelling skills and want to have a genuine impact on how an organisation uses data, this could be an excellent opportunity. Key Responsibilities Design, build ...

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

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

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

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

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