2 of 2 Permanent Dimensional Modelling Jobs in the West Midlands

procedures, performance tuning Strong troubleshooting skills for complex multi-system data issues. Strong understanding of data architecture concepts: Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns Batch orchestration, dependency management, SCD handling, incremental loads Azure Ecosystem (Preferred/Good to Have) Azure data services experience ...

maintain ETL/ELT processes using Power Automate, Fabric Data Factory, or similar tooling Own the end-to-end BI lifecycle — ingestion, transformation, modelling, visualisation, and business adoption Partner closely with commercial teams to deliver insight into pricing, promotions, customer behaviour, margin, and revenue Define, standardise, and monitor KPIs … just contributing to them. Essential experience 5+ years in BI/analytics/BI development, with clear technical ownership Advanced SQL (complex transformations, dimensional modelling, performance tuning) Deep, hands-on Power BI expertise — DAX, data modelling, optimisation, and deployment pipelines Experience working with Microsoft Fabric or comparable ...