1 to 25 of 48 Dimensional Modelling Jobs in the UK excluding London

Lead Data Engineer l Azure l Databricks l Dimensional Modelling l PowerBI l £550-£570 per day | Outside IR35 | London (2 days per week) | 6 months + extensions likely We're looking for a Lead Data Engineer to join a large-scale data transformation programme, helping shape … delivery. You'll be comfortable challenging solution designs, influencing architecture decisions and then building the solution yourself. Key experience required: Deep expertise in dimensional modelling, semantic models and Power BI Strong experience designing and building Gold-layer data solutions Ability to work across engineering, analytics and reporting Experience ...

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

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

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

published on job boards from below onwards The Role As a Data/Information Architect, you will lead the data architecture and information modelling for an airline operations supply chain implementation, ensuring that data across supply, demand, inventory and operational planning domains is structured, integrated and governed to support … effective business decision-making. You will combine strong hands-on expertise in AWS, Databricks and data modelling with a solid understanding of supply chain processes and the SCOR (Supply Chain Operations Reference) model, particularly Supply and Demand Planning. Working closely with business stakeholders, solution architects, functional consultants and engineering ...

monitoring. Advanced knowledge of Databricks , including Lakehouse architecture, Delta Lake, and large-scale data engineering practices. Expertise in conceptual, logical, and physical data modelling, including dimensional modelling, relational modelling, and modern warehouse/lakehouse design. Strong understanding of the SCOR (Supply Chain Operations Reference) model, particularly ...

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

business, the role will ensure reporting is reliable, reconciled, performant and maintainable. Experience required: * Advanced hands-on Power BI experience across DAX, semantic modelling, dashboards, optimisation and deployment. * Strong SQL and data warehousing skills, including dimensional data models. * Experience with Microsoft Fabric and modern data-platform environments. * Strong … call me on 0161 877 9200, or send me a message on LinkedIn Keywords: Power BI Developer/Power BI/DAX/Semantic Modelling/Data Modelling/SQL/Microsoft Fabric/Data Warehouse/Dimensional Modelling/Dashboards/Reporting/Data Visualisation ...

role in improving the quality, structure and usability of data across the business. Initially, the focus will be on data cleansing, reconciliation and modelling, with opportunities to contribute to forecasting and predictive analytics as the data environment develops. Key responsibilities will include: Data Quality & Remediation: Cleaning, standardising and validating … data from multiple source systems, identifying inconsistencies and ensuring information is accurate and reliable. Data Modelling: Developing robust analytical data models, including dimensional modelling and star schemas, to support reporting and downstream analytics. Identity Resolution: Identifying and reconciling duplicate records across systems, using techniques such as fuzzy ...

Data Platform Engineer. Strong experience working with AWS services including S3, Glue, Athena, EMR and Lambda. Advanced SQL and Python skills. Strong data modelling expertise, including dimensional modelling and analytics-ready data design. Experience delivering end-to-end cloud data platforms from ingestion through to consumption. Ability ...

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

data platform and global business goals. Design the Data-to-AI Interface: Establish how enterprise data is structurally modelled (using star schemas, semantic layers, dimensional modelling, and knowledge ontologies) to ensure autonomous AI agents can search, retrieve, and reason over data reliably without hallucinating. Build AI services: Lead … deployment, monitoring and retraining. Responsible AI frameworks (ISO/IEC 42001, NIST AI RMF, EU AI Act).DesirableEnterprise data architecture, data warehousing or semantic modelling (star schemas, dimensional models).Microsoft Fabric, Azure data services or Databricks. Why RES A genuinely global remit: You will set the architecture ...

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

maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated testing, source control … Experience Extensive hands-on experience developing solutions in Snowflake , ideally with at least three years of dedicated experience. Strong experience with dbt , including data modelling, transformation, testing and deployment. Advanced Python development skills for data engineering and automation. Strong SQL Server experience, including database design, query optimisation, performance tuning ...

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

collaborative manner in a large, fast paced environment within a multifunctional technical team Nice to have Languages: PySQL, C#, R Reporting: PowerBI or similar Modelling: SQL Server SSAS Tabular (DAX)/Dimensional Modelling/Data Warehousing Development Management: Azure DevOps SQL MI/DB ETL: Active Batch ...

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

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

delivery. Success will mean turning complex business requirements into clear, trusted and scalable insight. You will work across the analytics lifecycle, from data modelling and pipeline development through to dashboard performance, stakeholder adoption and continuous improvement, while also assessing where automation and emerging AI capabilities can create practical value. … technical audiences. Requirements Demonstrable experience delivering business intelligence solutions in a live operational or commercial environment. Strong Power BI capability, including dashboard development, semantic modelling, visual design and performance optimisation. Advanced SQL skills with the ability to develop efficient queries, transformations and analytical logic. Practical experience building, monitoring ...

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

engineering standards Your Skills & Experience Strong commercial Data Engineering experience Advanced SQL and Python skills Experience designing modern cloud data architectures Strong understanding of dimensional modelling and data warehousing Exposure to Azure, AWS, and GCP environments Familiarity with CI/CD pipelines and DevOps practices Knowledge of DataOps ...

partners. Experience required: Strong experience in 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 ...