2 of 2 Dimensional Modelling Jobs in the West Midlands

#39;ll design scalable, future-proof data architectures and provide technical leadership across transformation programmes: Architecture & Design: Design enterprise data architectures for Snowflake and Azure cloud ecosystems Create dimensional data models (star schema, snowflake schema, Data Vault) supporting analytics and BI Define data strategy and governance frameworks – lineage, cataloging, security, compliance Lead solution design for data warehouse, data … Conduct architecture reviews and design authority for data solutions Mentor engineers on best practices in data modeling, performance optimization, and cloud architecture ESSENTIAL SKILLS: Data Modeling expertise - Star schema, dimensional modeling, Data Vault, logical/physical design Snowflake Cloud Data Platform - Architecture design, performance tuning, cost optimization, governance Azure Data Factory - Pipeline architecture, orchestration patterns, best practices Azure Databricks More ❯

Data Delivery Team in designing and building scalable, future-proof data assets within the Microsoft Azure ecosystem. This role involves technical consulting, hands-on development, and leadership in data modelling, orchestration, and semantic layer design. Key Responsibilities: Provide technical consulting to the Data Engineering Manager during the design phase. Collaborate with a small team of Business Data Engineers to … build new data assets. Lead the design and development of dimensional data models and Power BI semantic models. Replace legacy SAP Business Objects universes with modern Azure-based solutions. Utilize Azure Data Factory (ADF), stored procedures, and Azure Synapse for data processing. Guide the team on best practices, architecture, and documentation standards. Engage with stakeholders to ensure solutions are … Experience: 10+ years of experience in data engineering, BI, or data architecture roles. Strong expertise in Azure Synapse, ADF, SQL, and Power BI. Proven experience in designing and implementing dimensional models and semantic layers. Familiarity with metadata management tools (e.g., Collibra) and model curation tools (e.g., Tabular Editor). Excellent communication and stakeholder management skills. Experience working in agile More ❯