15 of 15 Permanent Dimensional Modelling Jobs in the UK excluding London

from SSRS into Snowflake \nAssess and rationalise existing reports (remove duplication, improve logic, simplify where possible)Redesign reporting structures to align with modern data modelling principles\n Define and Implement Best Practice \n \n Establish scalable standards for:\n \n Data modelling (e.g. dimensional modelling, layered … 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 environmentsTrack record of delivering in hands-on roles (not purely ...

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

operational systems, ERP platforms and high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. … platforms using Azure, AWS, GCP or similar. Strong Python experience. Solid understanding of ETL/ELT processes and modern data warehousing principles. Experience with dimensional modelling, data governance and data architecture. Experience with Power BI and DAX. Experience integrating ERP and other operational business systems. Excellent stakeholder management ...

dashboards Contribute to long-term AI and data innovation initiatives YOUR SKILLS AND EXPERIENCE: 6+ years' experience in data engineering Strong expertise in data modelling (dimensional modelling and semantic layer design) Hands-on experience with Microsoft Fabric and/or Azure data services Proven ...

foundations that analytics, BI, data science and ML all stand on. You'll work across the full data engineering lifecycle—from ingestion and modelling through to transformation, orchestration, quality, observability and platform operation. The role suits someone who pairs strong software engineering discipline with genuine interest in data modelling … production ELT/ETL pipelines that move data reliably at the volume and latency the business needs Model data in the warehouse or lakehouse—dimensional, Data Vault, One Big Table or domain-driven approaches, fit to the use case Build and maintain transformation layers in dbt (or equivalent), with ...

including query development and optimisation, stored procedures, and performance tuning \n 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 \n Advanced data modelling including dimensional modelling, star schema ...

incoming data. Develop ELT/ETL processes using tools such as dbt, Power Query (M), Spark, Azure Data Factory or Fabric Data Pipelines. Design dimensional models and reusable models that capture business logic once and serve it consistently to every downstream tool. Author efficient transformations ...

models and self-service tools the business actually uses to make decisions. You'll work across the full BI lifecycle—from gathering requirements and modelling data through to building, optimising and maintaining production reporting assets. The role suits someone who pairs strong SQL and modelling discipline with … curated layers that let business users answer their own questions (For Senior/Lead) Set BI standards, mentor junior developers, lead larger reporting and modelling initiatives What You'll Bring Technical Expertise: Strong SQL proficiency against modern cloud warehouses (Snowflake, BigQuery, Redshift, Synapse, Databricks) Deep hands-on experience with ...

integrations using Azure Data Factory and Databricks and related services. Develop and maintain datasets and data models that support analytics and reporting, following established modelling standards Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview Work closely with the Lead Data Engineer, Analysts and Architects … production or near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best ...

such as Airflow to schedule, monitor and manage data pipelines Experience working with at least one major cloud data platform, preferably Azure Strong data modelling skills, including relational and dimensional modelling Knowledge of relational database technologies and best practices Proficiency in Python for data engineering, automation ...

writing. Significant experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly ...

collaborative engineering team. Key responsibilities include: Designing and developing scalable data pipelines for ingestion and transformation Writing high quality SQL for complex data modelling and analytics use cases Implementing dimensional models using Kimball methodologies Working with cloud data warehouse technologies such as Snowflake or BigQuery Supporting analytics … writing complex SQL, including CTEs and window functions Experience working with modern cloud data warehouses such as Snowflake, BigQuery or similar Solid understanding of dimensional modelling and data warehousing concepts Exposure to data transformation tools such as DBT is beneficial Basic knowledge of Python, ideally in the context ...

engineering solutions. The Fabric Ecosystem: Demonstrable, hands-on expertise with Microsoft Fabric , SQL , and Python/PySpark Notebooks . Core Competencies: Proven skill in dimensional modeling, data governance, and data extraction from online platforms via SaaS and APIs. Analytical Mindset: Excellent ability to analyze, manipulate, and interpret complex business ...

within a fast-paced environment. Desirable Skills Previous experience within the insurance, financial services or other regulated industries. Understanding of data warehousing concepts and dimensional modelling. Exposure to Python or R for data analysis. Knowledge of data governance and data quality best practices. Experience working within Agile environments. Package ...

ingest and transform data from multiple sources. Apache Airflow for workflow orchestration, scheduling and automation. Azure SQL and cloud-based data platforms. Data modelling, warehousing and optimisation activities. Data quality, governance and validation processes. Power BI reporting and business intelligence requirements. Technical and non-technical stakeholders across the business. … integration. Python scripting for automation, transformation and data engineering tasks. Experience with Apache Airflow or similar orchestration tools. Understanding of data warehousing and data modelling principles, including dimensional modelling. Experience working with cloud-based data platforms. Familiarity with Git and version control practices. Strong communication skills ...