3 of 3 Dimensional Modelling Jobs in the West Midlands

e.g., Azure SQL, Snowflake). Experience with ETL/ELT tooling (e.g., SSIS, dbt, Azure Data Factory) and data pipeline design. Understanding of data modelling principles (normalisation, dimensional modelling/star schema for data warehousing). Experience of diagnosing and resolving database performance issues. Familiarity with database ...

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

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...