3 of 3 Dimensional Modelling Jobs in the West Midlands

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

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