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

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

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

Hands-on experience with Azure data services , including Azure Data Factory, Databricks, Azure Synapse, and Azure SQL. Good understanding of data warehouse design , including star schema and dimensional modelling. Experience working with Azure Data Lake/Blob Storage and cloud-native data architectures. Strong proficiency in SQL , with ...

Synapse/OneLake) Experience building and managing data pipelines and workflow orchestration tools (e.g. Airflow, Data Factory) A solid understanding of data modelling (e.g. star schemas, SCD) and governance principles Experience implementing data quality testing and validation Familiarity with CI/CD and version control (e.g. Git, GitHub Actions ...

database programming, and BI tools. Strong knowledge of data warehousing methodologies, ETL tools (e.g., WhereScape, SSIS), and modelling techniques (e.g., dimensional modelling, star schemas). Proficiency in Python or R. Experience with version control systems (e.g., Git). Strong understanding of UK data protection laws. Soft Skills Excellent analytical ...

Experience working in Agile/Scrum environments Hands-on experience with Microsoft Azure services , particularly Azure Data Factory Understanding of data warehousing concepts , including star schema architecture Desirable experience: Front-end technologies such as HTML, CSS and JavaScript Procurement technology or the social housing sector Azure platform ...

strong business acumen, adaptability, integrity, and organisational skills. For this role you'll need to have: Significant experience in data modelling and more specifically, star-schema design Extensive hands-on experience delivering analytics and business intelligence data models, Strong grounding in data warehousing principles Expertise in data ...

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

centre of decision-making across product, commercial, and operations. What you'll be doing Core analytics + modelling Build data models (SQL, star schemas, semantic-layer-ready tables). Work with GCP + dbt pipelines (with support from a dedicated data engineer). Turn messy spreadsheets into clean, reliable …/commercial analytics. Strong SQL (modelling, joins, transformations). Experience with 2+ BI tools (Tableau, Looker, Power BI, etc.). Understanding of data modelling (star schemas, semantic layers). Strong communication skills and ability to bridge business data. Adaptable mindset - someone who can pick things up fast and challenge ...