1 to 25 of 41 Dimensional Modelling Jobs in the UK

from SSRS into Snowflake Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible) Redesign reporting structures to align with modern data modelling principles Define and Implement Best Practice Establish scalable standards for: Data modelling (e.g. dimensional modelling, layered architecture) Transformation workflows (ELT patterns … experience working with Snowflake (or similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles ...

scalability. Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity. Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics. Apply expert T-SQL and SQL Server skills for query optimisation and advanced data manipulation. Support … processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python, and R, to help drive innovation. The postholder will be line managed by the Principal BI Developer and will work closely ...

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

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

Translate business requirements into structured and scalable data models in collaboration with Data Analysts and stakeholders. Provide guidance to Data Engineers on data structures, modelling patterns, and data granularity requirements. Promote consistency, reusability, and standardisation of data models across multiple business domains. Support data governance initiatives, including metadata management … data quality practices. Collaborate with architecture and engineering teams to optimise data design for cloud-based platforms. Contribute to the development and maintenance of modelling standards, frameworks, and best practices. Support the delivery of data products that enable analytical, operational, and regulatory reporting requirements. Essential Skills, Knowledge and Experience ...

advanced analytics or ML use cases where relevant. About You We are looking for a rigorous data engineer with strong experience in integration, modelling and delivering reliable, well-documented data solutions. You should be confident moving data from operational systems into governed analytical environments, with strong attention to quality … Fabric skills and proven experience building robust automated data pipelines. Experience with lake, lakehouse, warehouse or similar analytical platforms. Strong grasp of data modelling, quality, documentation, lineage and governance. Understanding of secure data access, GDPR and privacy-preserving methods. Ability to create trusted data assets for reporting, analytics ...

move and expose data safely and reliably. Agile ways of working with Jira/Confluence; clear stakeholder communication and concise technical documentation. Data warehousing & modelling (e.g., Redshift; dimensional modelling). Basic Power BI familiarity to partner with BI developers and validate end-to-end data flows. ...

hybrid role.Key Responsibilities: Design, build, and maintain data solutions using Microsoft Fabric. Develop and optimise data pipelines, Lakehouses, and Data Warehouses. Create and maintain dimensional data models and semantic models. Support Power BI reporting and analytics requirements. Ensure data quality, performance, security, and governance. Collaborate with business stakeholders … deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge of ETL/ELT processes ...

Scala for data processing and automation. Experience with BI and visualisation tools such as Power BI, Tableau, or Looker. Understanding of data warehousing concepts, dimensional modelling, and modern data architecture. Experience integrating APIs and third-party SaaS platforms. Must have excellent stakeholder management and communication skills, with ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

Terraform, CI/CD pipelines, and Infrastructure as Code. Git/GitLab and modern software development practices. API integration and data services. Data warehousing, dimensional modelling, and dbt. Power BI familiarity. Experience working within government or highly regulated environments. What's In It For You? Opportunity to work ...

assets to deliver high-performing, low-latency analytics at scale. Provide technical guidance through code reviews and mentorship, raising standards across data modelling and visualisation. Your Skills and Experience Strong commercial experience in BI engineering, analytics engineering, or data engineering within a modern data stack. Advanced SQL capability, including … complex transformations, window functions, and performance optimisation. Proven experience working with cloud data warehouses such as Databricks, Snowflake, or BigQuery. Deep understanding of dimensional modelling techniques and tools such as dbt. Hands-on expertise with enterprise BI platforms, such as Power BI, Looker or Omni. Ability to communicate ...

teams to deliver high-quality, trusted data products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400 … implementing solutions within Snowflake. Demonstrated success delivering enterprise-scale data transformation programmes and modernising legacy data environments. Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements. Advanced knowledge of dbt and Git-based ...

Agentic AI. Strong experience Must have prior experience with end-to-end implementation of Cloud data technologies (i.e.Fabric, Snowflake). Expertise in data modelling, ELT and implementing complex stored Procedures. Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc. Expertise … systems, Salesforce, GIS, PI Historian to Snowflake. Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form) Experience with data security and data access controls and design Deep understanding of SoX, GDPR and Regulatory/ ...

programming language commonly used in data engineering, preferably Python. Scala or Java is a plu s.Solid understanding of data warehousing concepts, data modeling techniques (dimensional modeling, Kimball, Inmon), and ETL/ELT processe s.Experience with version control systems (e.g., Git ).Strong analytical, problem-solving, and debugging skill s.Excellent communication ...

grade pipelines. Expert-level SQL , including optimization and data modelling. Azure Cloud experience (ADF, Functions, Storage, Key Vault). Deep understanding of data warehousing, dimensional modelling, and scalable architectures . Proficiency in Git, CI/CD, automated testing, and modern engineering best practices. Experience with API and SFTP … Experience with Medallion/Lakehouse patterns or Databricks-style ecosystems. Experience in regulated or high-assurance data environments. Collaboration with modeling teams in engineering-modelling interfaces ...

reporting layer within the data warehouse using SQL Create and maintain reporting tables and views Work closely with data engineers to ensure outputs follow dimensional modelling best practices Investigate and resolve data quality issues, ensuring outputs reconcile with source systems Improve performance across both SQL queries and Power … Service, including publishing, workspace management, and scheduled refreshes Advanced T-SQL skills, including views, stored procedures, CTEs, and window functions Solid understanding of data modelling concepts such as fact and dimension tables, and star schemas Desirable Experience Experience with Azure Synapse or similar cloud data platforms Knowledge of Power ...

requirements Deliver insights through reports and visualisations Translate business needs into technical solutions Maintain and enhance data platforms and analytics systems Build and manage dimensional data models Conduct testing, troubleshooting and performance tuning Evaluate and improve existing BI systems Collaborate with technical teams to integrate systems Create and maintain … also required. What you'll need to succeed Essential Skills & Experience Proven experience in a data-focused role Strong background in data warehousing and dimensional modelling Understanding of database management systems, OLAP and ETL frameworks Experience with cloud data platforms (ideally Microsoft Fabric) Familiarity with Power ...

stakeholders across finance, operations and commercial teams. Roles & Responsibilities Define the technology stack and architecture for the organisation's enterprise data warehouse Establish data modelling standards, semantic layers and reusable datasets Oversee ETL pipelines across ERP, CRM and operational systems Implement data quality, governance and DataOps best practices Lead … technical authority across the data estate Requirements Experience with modern data warehouse tooling; Snowflake, Synapse, Fabric or similar Strong SQL and dimensional modelling expertise Experience designing scalable ETL/ELT pipelines Experience working with ERP and financial data environments Experience leading distributed, offshore or third-party delivery teams ...

Define and implement robust application architectures aligned to business, security and operational requirements. Design modern data platforms including relational databases, NoSQL/document stores, dimensional models, data lakes and streaming architectures. Translate business requirements into end-to-end technical solutions spanning applications, data and infrastructure. Provide expertise across cloud … industry. Strong development expertise in: .NET .NET Core Python Deep understanding of modern data architectures and technologies, including: Relational databases NoSQL/document databases Dimensional modelling and star schemas Data lakes Event-driven and streaming data platforms Experience designing and deploying solutions across both cloud and on-premises ...

looking for Essential skills and experience Strong, hands-on experience with Power BI development Advanced capability in DAX, Power Query and data modelling Proven experience delivering BI solutions within a structured IT environment Strong SQL skills Solid understanding of data warehousing and dimensional modelling Additional strengths Excellent ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...