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

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...

maintain ETL/ELT processes using Power Automate, Fabric Data Factory, or similar tooling Own the end-to-end BI lifecycle — ingestion, transformation, modelling, visualisation, and business adoption Partner closely with commercial teams to deliver insight into pricing, promotions, customer behaviour, margin, and revenue Define, standardise, and monitor KPIs … just contributing to them. Essential experience 5+ years in BI/analytics/BI development, with clear technical ownership Advanced SQL (complex transformations, dimensional modelling, performance tuning) Deep, hands-on Power BI expertise — DAX, data modelling, optimisation, and deployment pipelines Experience working with Microsoft Fabric or comparable ...

such as SQL Server, SSIS, SSRS and SSAS, ensuring that legacy systems and modern cloud components work together effectively. You will define data models, dimensional structures and integration patterns that support operational reporting, dashboards and analytical workloads. You will work closely with business teams to understand data requirements, translate … well systems integrate and how effectively the organisation makes decisions. What you'll need to succeed You bring strong experience in data architecture, data modelling and BI engineering within a medium or large organisation. You have hands-on expertise with SQL Server technologies including SSIS, SSRS and SSAS ...

operational reporting. Key Responsibilities: Build, maintain and optimise scalable, secure and well-governed data pipelines. Develop and maintain data models (Data Vault and Dimensional). Ensure data quality, lineage, governance and security standards are embedded in all pipelines. Troubleshoot and resolve data pipeline issues, performing root cause analysis … distributed environments (DBT, Snowflake, SQL Server Stack; experience with Kafka, MySQL, Azure or AWS is a plus). Strong expertise in Data Vault and Dimensional modelling is essential. Experience embedding data governance, quality, monitoring and alerting into pipelines. Knowledge of Agile delivery and CI/CD principles. Excellent ...

patching, security, and performance tuning. Monitor database and warehouse workloads, diagnosing and resolving performance or integrity issues. Ensure strong standards around data quality, governance, modelling, and security across all datasets and warehouse layers. Work closely with business stakeholders to translate requirements into well structured data models and reporting solutions. … preferred). Proficiency in Python for automation, scripting, and data processing. Practical experience with SQL Server Database Administration tasks. Knowledge of data warehouse architecture, dimensional modelling, and ETL frameworks. Experience with SSIS or similar tools for ETL and data movement. Familiarity with reporting tools such as SSRS ...

roadmap, ensuring alignment with business objectives and the BI product strategy Establish architectural patterns and frameworks (such as Medallion architecture, data vault or dimensional modelling) for consistent implementation across data solutions Define and document standard business entities, metrics and KPIs to ensure consistency across reporting Work with Group … requirements include: Extensive experience in data architecture, with proven track record of designing and implementing enterprise-scale data solutions Deep expertise in data modelling techniques with strong SQL proficiency Good knowledge of cloud data platforms (AWS preferred: Redshift, Athena, S3, Glue, knowledge of Azure or GCP beneficial) and modern ...

roadmap, ensuring alignment with business objectives and the BI product strategy Establish architectural patterns and frameworks (such as Medallion architecture, data vault or dimensional modelling) for consistent implementation across data solutions Define and document standard business entities, metrics and KPIs to ensure consistency across reporting Work with Group … requirements include: Extensive experience in data architecture, with proven track record of designing and implementing enterprise-scale data solutions Deep expertise xkybehq in data modelling techniques with strong SQL proficiency Good knowledge of cloud data platforms (AWS preferred: Redshift, Athena, S3, Glue, knowledge of Azure or GCP beneficial ...

ability to translate complex requirements into clear, scalable and well-governed designs. You will be responsible for ensuring data architecture quality across projects, shaping modelling standards and supporting the development of an enterprise-wide data framework. You will collaborate closely with business stakeholders, technical teams and external partners, influencing … data models Strong hands-on experience with Azure Data Factory, Synapse, Data Lake, Azure SQL, Databricks or Fabric Expertise in conceptual and logical data modelling, ideally using UML Deep understanding of Azure-aligned data architectures, including lakehouse and dimensional modelling Ability to design secure Azure data solutions ...

experience with complex data transformations Experience with cloud platform - Azure Familiarity with ETL/ELT tools Strong understanding of data warehousing concepts and dimensional modelling Responsibilities Design, develop, and maintain data pipelines and data models in Snowflake Implement ELT/ETL processes using Snowflake and associated tools Optimise ...

Kafka within AWS . Experience with modern data stacks is important, along with a solid understanding of data warehousing concepts, ETL/ELT processing , dimensional modelling and both batch and real-time ingestion patterns. Given the scale they operate at, reliability and performance are critical . Experience building ...

Kafka within AWS. Experience with modern data stacks is important, along with a solid understanding of data warehousing concepts, ETL/ELT processing, dimensional modelling and both batch and real-time ingestion patterns. Given the scale they operate at, reliability and performance are critical. Experience building robust pipelines ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

tech stack: data pipeline orchestration tools (e.g. Airflow, Prefect, Dagster), cloud data platforms (e.g. AWS, S3, Glue, Athena, Redshift, Kinesis), data warehouse concepts and dimensional modelling, data streaming tools (e.g. Kafka, Kinesis) You're collaborative with great communication skills What's in it for you: Salary ...

develop advanced analytical models. Engagements typically begin with building high-quality semantic models and dashboards, before progressing into deeper analytical work including predictive modelling and workflow automation. This role suits someone who is technically strong, commercially aware, and comfortable working independently in a client-facing environment. Technical Skills (Essential … Strong Power BI experience (advanced DAX, dimensional modelling, performance optimisation) Professional dashboard and semantic model development Fluent SQL (complex joins, transformations, optimisation) Python for analysis (pandas, statistics, scikit-learn) Advanced Excel skills Experience & Background: proven experience in consulting or fast-moving commercial environments Strong academic background ...

Expertise in generative AI, machine learning, cognitive services and responsible AI practices Deep understanding of modern data architectures including lakehouse, data mesh, MDM and dimensional modelling Knowledge of Dynamics 365 and Power Platform advantageous Experience leading pre-sales engagements and presenting to senior stakeholders What's on Offer ...

Agile. The Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT . Modern Modeling: Expert skills in Data Vault and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality ...

Agile. The Essentials Pipeline Tech: 5+ years of experience with Kafka, Spark, Hadoop, and DBT. Modern Modeling: Expert skills in Data Vault and Dimensional modeling. Cloud & DevOps: Strong AWS experience with a focus on CI/CD and writing secure code. Data Governance: Proven ability to embed quality, lineage ...

experience with modern data warehouses (e.g. BigQuery) -3+ years of experience in Analytics Engineering or a related field -Technical experience with advanced modelling techniques in dbt -Understanding of ETL/ELT processes -Experience with BI semantic layers and data visualisation tools -Understanding of dimensional modelling, analytics ...

data quality rules, idempotency, and error handling. Manage and optimise Microsoft SQL Server environments (2016), ensuring high performance, reliability, and scalability. Build and maintain dimensional models, relational schemas, and analytical data structures (Kimball approach preferred). Support the full project management life cycle, including requirements gathering, technical design, documentation ...

data quality rules, idempotency, and error handling. Manage and optimise Microsoft SQL Server environments (2016), ensuring high performance, reliability, and scalability. Build and maintain dimensional models, relational schemas, and analytical data structures (Kimball approach preferred). Support the full project management life cycle, including requirements gathering, technical design, documentation ...

months (extension likely)Day Rate: £400 per day (Outside IR35) Role OverviewWe are seeking an experienced Power BI Specialist contractor to own enterprise semantic modelling, advanced DAX development and reporting governance.This is a hands-on technical role focused on Power BI semantic models, not dashboard production. You will design … govern certified enterprise datasets built on the Gold data layer, enabling analysts to self-serve confidently while protecting core business logic. Key ResponsibilitiesEnterprise Semantic Modelling Design, build and maintain enterprise Power BI semantic models using star schema and dimensional modelling best practice. Develop advanced DAX measures, calculation ...

extension likely)Day Rate: £400 per day (Outside IR35) Role Overview We are seeking an experienced Power BI Specialist contractor to own enterprise semantic modelling, advanced DAX development and reporting governance.This is a hands-on technical role focused on Power BI semantic models, not dashboard production. You will design … certified enterprise datasets built on the Gold data layer, enabling analysts to self-serve confidently while protecting core business logic. Key Responsibilities Enterprise Semantic Modelling Design, build and maintain enterprise Power BI semantic models using star schema and dimensional modelling best practice. Develop advanced DAX measures, calculation ...

sector experience (banking, capital markets, insurance, asset management, or payments) Demonstrable experience modeling data for regulatory, risk, finance, or operational reporting Deep expertise in dimensional modeling, data vault, or hybrid approaches Strong hands-on experience with Snowflake Experience designing semantic layers for BI and analytics platforms Track record ...

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