21 of 21 Star Schema Jobs in the North of England

will play a key role in transforming our data warehouse and Azure data platform. This includes redeveloping Azure Data Factory (ADF) pipelines, implementing star schema models, and improving the reliability and quality of our data assets. You will: Azure Data Factory & Pipeline Development Group and redesign pipelines based … duplication and simplify change management. Migrate existing logic into a cleaner, streamlined structure. Remove old or redundant pipelines to create a more efficient environment. Star Schema & Data Warehouse Development Help transition from denormalised 2D files to a robust star schema aligned to Kimball principles. Create ...

will play a key role in transforming our data warehouse and Azure data platform. This includes redeveloping Azure Data Factory (ADF) pipelines, implementing star schema models, and improving the reliability and quality of our data assets. You will: Azure Data Factory & Pipeline Development Group and redesign pipelines based … duplication and simplify change management. Migrate existing logic into a cleaner, streamlined structure. Remove old or redundant pipelines to create a more efficient environment. Star Schema & Data Warehouse Development Help transition from denormalised 2D files to a robust star schema aligned to Kimball principles. Create ...

measures for KPIs, time intelligence, and business logic Perform data transformation using Power Query (M) and SQL-based pipelines Design robust data models (star schema, dimensional modelling) to support performance and scalability Ensure data quality, lineage, and governance standards across all BI assets Monitor and improve dataset performance … optimisation, time intelligence Power Query (M) - data transformation and shaping SQL/SQL Server - joins, CTEs, window functions, performance tuning Data Modelling - dimensional modelling, star schema, semantic models ETL/Data Pipelines - building and maintaining dataflows and pipelines Data Governance - data quality, lineage, and controlled environments PROFILE Proven ...

+ 3rd party applications covering, Retail and Wholesale Sales, Stock, Customer, Supply Chain and Finance) into the data lake environment. • Apply good practice in star-schema modelling, incremental refresh, and DAX/M query optimisation. • Work with software developers, analysts and self-serve users to shape reporting requirements … understanding of Microsoft Fabric, particularly: o Lakehouses/Warehouses o Dataflows Gen2 o Pipelines & notebooks o OneLake data architecture • Good knowledge of data modelling (star-schema, fact/dimension design, calculations, DAX, M). • Strong SQL skills and ability to work with structured/unstructured data. • Comfortable working ...

Developer. The Role Joining a newly formed team, you will take ownership of transforming ingested data from the staging layer into governed, high performance star schema models within the reporting layer using Azure Databricks and Azure SQL. Other key responsibilities include: Data Modelling - Design and maintain star schema models, ensuring fact and dimension structures are aligned to business definitions and scalable for future growth. Reporting Development and Delivery - Contribute directly to the development and enhancement of Tableau dashboards and certified data sources. Data Governance - Play a critical role in centralising KPI logic and improving consistency ...

skills, and design sensibility. Key Responsibilities Design and develop Power BI dashboards from concept through to deployment and maintenance. Build robust data models using star schema and dimensional modeling techniques. Write DAX measures and calculations to deliver business metrics and KPIs. Create Power Query transformations to extract, clean … Query proficiency including M language, data transformations, and query optimization. SQL skills for data extraction, transformation, and understanding database structures. Data modeling experience including star schema, dimensional modeling, and normalization. Understanding of UX and design principles for user-friendly dashboards. Stakeholder management skills with ability to gather requirements ...

that support marketing and commercial decision-making. Your responsibilities will include designing Power BI reports with strong UX principles, developing efficient data models using star schema design, and writing advanced DAX measures to support complex reporting needs. You will also collaborate with stakeholders to scope dashboard requirements, produce … ESSENTIAL SKILLS Strong commercial experience with Power BI development Advanced DAX skills including time intelligence and performance optimisation Solid understanding of data modelling, including star schema design Experience with Power Query (M) for data transformation Ability to translate business requirements into clear reporting solutions Experience working with KPIs ...

doing Designing and building Power BI dashboards to an exceptional standard of visual design and user experience. Developing robust data models using star schema principles, setting up relationships, hierarchies, and optimised structures. Writing efficient, clean DAX - including complex measures and time intelligence. Using Power Query (M) to build … bring Must-haves: Strong, demonstrable Power BI development experience - you'll need a portfolio or examples of your work. Deep understanding of data modelling , star schema, relationships, and model optimisation. Advanced DAX (complex measures, performance optimisation). Strong Power Query (M) capabilities. Ability to translate complex data into ...

optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail and commitment to data ...

scale. Key Responsibilities Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. 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 within reporting ...

data quality, and system performance. Requirements: Proven experience with SQL Server, stored procedures, and complex query development. Solid understanding of data warehouse concepts, including Star Schema/Kimball methodologies. Experience with ETL processes, data migration, and data integration across multiple systems. Familiarity with Tableau, Power BI, or other ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership. Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas Programmes: Snowflake ...

production. Key Experience Required Strong hands-on experience with Microsoft Fabric Experience building end-to-end Lakehouse solutions Good data modelling skills (e.g. star schema) Experience using PySpark or Spark SQL Building data pipelines from APIs, ERP or SaaS systems Working with Fabric pipelines, notebooks and Dataflows Understanding ...

challenges. The Role You will: • Design and develop Power BI dashboards with strong visual storytelling and user experience. • Build clean, scalable data models using star schema principles. • Create efficient DAX calculations to support flexible reporting. • Shape and transform data using Power Query within Power BI. • Maintain consistent design ...

challenges. The Role You will: * Design and develop Power BI dashboards with strong visual storytelling and user experience. * Build clean, scalable data models using star schema principles. * Create efficient DAX calculations to support flexible reporting. * Shape and transform data using Power Query within Power BI. * Maintain consistent design ...

Responsibilities Build and maintain high-quality Power BI dashboards and reports for both client projects and internal initiatives Develop structured data models, including star schema designs Use DAX, calculated columns/measures, and Power Query to transform, optimise, and analyse data Support the development and maintenance ...

Responsibilities Build and maintain high-quality Power BI dashboards and reports for both client projects and internal initiatives Develop structured data models, including star schema designs Use DAX, calculated columns/measures, and Power Query to transform, optimise, and analyse data Support the development and maintenance ...

ROLE Build high-quality Power BI dashboards and reports for both client projects and internal initiatives Develop and maintain structured data models including star schemas Use DAX, calculated columns and measures, and Power Query to transform and optimise data Support the maintenance and improvement of BI standards and design ...

ROLE Build high-quality Power BI dashboards and reports for both client projects and internal initiatives Develop and maintain structured data models including star schemas Use DAX, calculated columns and measures, and Power Query to transform and optimise data Support the maintenance and improvement of BI standards and design ...