2 of 2 Permanent Star Schema Jobs in Yorkshire

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

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...