1 to 25 of 31 Remote/Hybrid Dimensional Modelling Jobs in the UK

Data & Analytics Lead, who will set priorities, provide technical direction and coordinate Data Engineering and Power BI delivery. Together, you will build reliable pipelines, dimensional models and transformations that make trusted data available across the business. Key Responsibilities Lead and develop the data team, including Data Engineering, with clear … priorities and responsibilities Guide technical work across reporting, data modelling, integration and engineering Design and maintain Power BI reports, dashboards, semantic models and supporting data models Set Power BI standards for architecture, development, governance, deployment and reuse Work with stakeholders to understand requirements, agree priorities and manage delivery Work ...

data platforms. This role requires strong technical business analysis expertise across enterprise reporting, business intelligence, data warehousing, and analytics. Experience working with Kimball-style dimensional modelling methodologies and semantic models will be highly valued, helping to ensure reporting solutions are scalable, governed, and capable of delivering consistent business … reporting, analytics, business intelligence, or data warehouse projects Experience working with Power BI, Tableau, Qlik, Cognos, or similar BI platforms Strong understanding of data modelling concepts , including facts, dimensions, star schemas, semantic models, and reporting architectures Experience working with Kimball-style dimensional modelling methodologies Experience designing, supporting ...

troubleshooting complex T-SQL queries and stored procedures Building and enhancing semantic and tabular data models Supporting SSAS cube development and DAX calculations Applying dimensional modelling and data warehousing best practices Collaborating with business and data analysts to translate requirements into technical solutions Investigating data issues and supporting … experience with SQL Server and T-SQL development Experience building and maintaining ETL processes and data pipelines Solid understanding of data warehousing concepts and dimensional modelling Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches Exposure to SSAS ...

following areas is important: Microsoft Fabric and Azure data services, includinglakehouse, warehouse,notebooksand pipeline capabilities. Building enterprise-scale data platforms,lakehousesand data warehouses. Data modelling and dimensional modelling techniques such as Kimball. ETL/ELT development and large-scale data integration. PySpark, Spark SQL and modern transformation ...

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

partner to clients, shaping their data strategy, advising senior stakeholders and articulating architecture decisions with clarity and confidence. • Create and enforce architectural guidelines, including modelling standards, reference architectures, blueprints and reusable components to ensure consistent delivery quality. • Stay current with emerging data platform technologies, architectural patterns and cloud-native … large-scale, enterprise or transformation programmes. • Proven expertise designing cloud-native data platforms, including MS Fabric, Databricks and AWS • Strong background in data modelling methodologies (Kimball, 3NF, Data Vault, dimensional modelling). • Experience with modern data transformation approaches — familiarity with analytics engineering principles is beneficial. • Deep understanding ...

pipelines. Experience with cloud platforms such as Azure, AWS or GCP. Knowledge of relational and non-relational databases. Understanding of data warehousing and dimensional modelling, including star and snowflake schemas. Experience with Microsoft Fabric, dbt Cloud, Azure Data Factory or similar tools would be beneficial. Strong analytical ...

services (Azure Data Factory, ADLS Gen2, Azure SQL, Synapse or Databricks)Solid understanding of data warehousing and lakehouse concepts, Delta/Parquet formats and dimensional modeling (Kimball)Experience with Real-Time Intelligence (Eventstreams, Eventhouse/KQL, Activator)Ability to turn architecture documents and requirements into working, well-documented solutionsAnalytical ...

e.g., Azure SQL, Snowflake). Experience with ETL/ELT tooling (e.g., SSIS, dbt, Azure Data Factory) and data pipeline design. Understanding of data modelling principles (normalisation, dimensional modelling/star schema for data warehousing). Experience of diagnosing and resolving database performance issues. Familiarity with database ...

collaboratively with other members of the IT and development teams. What Were 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 ...

Bring ✅ Extensive hands-on experience with Databricks , and Microsoft Azure data tools (must-have: Azure Data Factory, Azure Synapse, or Azure SQL). ✅ Dimensional modelling/DWH Design ✅ Medallion Architecture ✅ Strong ETL/ELT development skills. ✅ Python scripting experience for data automation. ✅ Experience with CI/CD methodologies ...

Bring ✅ Extensive hands-on experience with Databricks , and Microsoft Azure data tools (must-have: Azure Data Factory, Azure Synapse, or Azure SQL). ✅ Dimensional modelling/DWH Design ✅ Medallion Architecture ✅ Strong ETL/ELT development skills. ✅ Python scripting experience for data automation. ✅ Experience with CI/CD methodologies ...

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

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

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

Delivery: Experience working in a consultancy, systems integrator, or client-facing setting with direct accountability to project delivery outcomes. Data Modeling: Solid depth in dimensional modeling, NoSQL schemas, and lakehouse/medallion architecture patterns. Data Governance & Operations: Practical experience implementing data catalogues, lineage, access controls, data quality checks ...

Delivery: Experience working in a consultancy, systems integrator, or client-facing setting with direct accountability to project delivery outcomes. Data Modeling: Solid depth in dimensional modeling, NoSQL schemas, and lakehouse/medallion architecture patterns. Data Governance & Operations: Practical experience implementing data catalogues, lineage, access controls, data quality checks ...

datasets, semantic models, dashboards and reports Build ETL/ELT processes using Azure Data Factory and SQL Server Develop data warehouse solutions and dimensional models Translate business requirements into effective technical solutions Analyse data from multiple sources to deliver meaningful insight Apply data quality, governance, testing and documentation standards … dashboards and semantic models Strong SQL and Microsoft data platform experience Experience with Azure Data Factory and SQL Server Knowledge of data warehouses and dimensional modelling Experience translating business requirements into technical solutions Understanding of data quality, governance and testing Strong communication skills with technical and non-technical ...

define data lineagePrevious experience and an understanding of Policy/Claims data elements would be a preference. Knowledge of data warehouse principles i.e. Dimensional modelling, Kimbal, Start Schemas, incremental loading, master data management etcUnderstanding and ability to profile data and identify Data Quality issuesRequirements gathering and analysis skillsCompensation ...

integration. Hands-on data engineering: Design and build production-grade SQL and Python pipelines, integrating data from multiple internal and external platforms. Data modelling: Develop scalable data models covering clients, entities, transactions, alerts, screening outcomes, risk ratings, investigations and audit records. Data quality and governance: Establish automated testing, reconciliation … backed by strong SQL/Python engineering and experience leading data platform delivery. Essential experience: Extensive, hands-on Snowflake engineering experience, including architecture, data modelling, performance optimisation, warehouse management, security and cost control. Advanced dbt expertise, having designed and developed production transformation frameworks rather than simply worked with existing ...

relational database technologies. Proven ETL experience, with SSIS being essential. Experience with scripting languages such as Python or PowerShell. Strong understanding of data modelling, warehousing concepts, and dimensional modelling. Experience working with cloud platforms such as Azure and/or AWS.Knowledge of Agile delivery environments and the Software ...

solutions, including dashboard design and data visualisationStrong technical knowledge of ERP-derived financial data, data extraction and transformation, reconciliation, data quality and Star Schema dimensional modelling.Experience with Microsoft Fabric, Direct Lake, SQL, DAX and M Coding. Proven ability to develop team capability, strengthen technical reporting skills and support individual ...

business stakeholders to design scalable analytics solutions and AI-ready data architectures. This will include working across data structures, semantic models, metric layers and dimensional modelling. You'll also help establish reusable standards and best practices across analytics, supporting teams to deliver solutions that are scalable, secure, governed … delivering enterprise-scale analytics solutions Excellent SQL skills Strong experience with Power BI Experience working with Microsoft Fabric and Azure Databricks Strong knowledge of dimensional modelling, semantic models and analytics data architecture Experience establishing analytics standards, best practices and reusable technical patterns Ability to combine strategic thinking with ...