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

documentation, and managing a project structure Ability to translate business logic and organisational rules into data model design Experience building curated or semantic layers — star schemas or similar Excellent communication skills — able to work closely with non-technical stakeholders to understand and codify their data needs Outstanding attention ...

Azure Data Platform technologies and modern Lakehouse architectures Databricks, Unity Catalog and Delta Lake PySpark, Databricks, SQL Medallion Architecture implementation Data modelling approaches including Star Schema and Data Vault Data governance, security and access management Why This Opportunity Greenfield data transformation programme Full ownership of enterprise data architecture ...

experience with business intelligence tools, data modeling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety ...

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