4 of 4 Dimensional Modelling Jobs in the 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 ...

confident, data driven decisions. Key Responsibilities Design, build, and maintain analytics models that convert raw data into trusted, business-ready datasets. Own the full modelling lifecycle (staging → core → marts). Define and maintain consistent metrics, dimensions, and business logic. Implement testing, data quality checks, and SLAs to ensure reliability. … accurate, consistent, and actionable. A degree in Computer Science, Engineering, Maths, Economics, Data Science is desirable. Advanced SQL skills and experience with analytical/dimensional modelling. Practical experience with modern ELT tools (Dataform/dbt) and Git workflows. Knowledge of cloud data warehouses, ideally BigQuery. Familiarity with orchestration tools ...

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