6 of 6 Star Schema Jobs in the North of England

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. Ensure robust data governance, security ...

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, database layers, and data mart development Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

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 … 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 within reporting ...

decision-making. Key Responsibilities End-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design. Platform & Integration Strategy: Architect Power BI integration with Azure/ ...

Power BI (critical – minimal ramp-up) Strong data modelling/DAX/SQL/data transformation Experience with large datasets/semantic models/star schema Exposure to Azure/data platforms (nice to have but helpful) Strong Excel Other must haves Commercial/business-facing analytics: Sales ...

level SQL and deep mastery of dbt (data build tool) or similar orchestrators, coupled with a thorough understanding of Kimball dimensional modelling principles and star schema layouts. AI Native Mindset: A progressive understanding of how automated AI agents consume data structures, and practical familiarity with utilising generative ...