Industry Platforms - MDP Azure Fabric Lead Consultant

Position Overview

Industry Platforms & Systems Integration (IP&SI) is the client's trusted delivery practice - bringing together platform expertise, systems integration, modern data foundations, and security-by-design to help clients deliver change faster, with confidence. We connect trusted data, modernise core platforms, and uplift capability to reduce cost and risk while enabling resilient, artificial intelligence (AI)-ready operations.

The MDP Fabric Architect / Consultant / Developer designs, builds and operates modern analytics and data platforms using Microsoft Fabric, enabling scalable, governed, insight-driven data solutions across business intelligence (BI), analytics, data engineering and (where applicable) artificial intelligence (AI) workloads.

Depending on experience and seniority, the role may be hands-on in solution delivery (Developer/Consultant) or may lead platform architecture, standards and data strategy (Architect). The role partners with business stakeholders, data teams, cloud architects and security teams to ensure the platform is secure, scalable, cost-effective and operationally sound.

Key Responsibilities

• Design and implement data solutions using Microsoft Fabric, including OneLake, Lakehouse / Warehouse, Data Engineering, Data Factory, Data Science, Real-Time Analytics, and Power BI semantic models and reports.
• Build ingestion, transformation, and analytics pipelines using Fabric capabilities, supporting batch, streaming, and near real-time processing patterns.
• Develop and optimise data pipelines, lakehouse / warehouse models, and Power BI artefacts; apply strong Structured Query Language (SQL), data modelling, and analytical design practices.
• Implement data quality, lineage, and metadata practices; apply data governance using Microsoft Purview and Fabric capabilities.
• Support operations including monitoring, performance tuning, cost optimisation, environment management, deployment, and lifecycle management.
• Collaborate with business users, analysts, data teams, cloud architects, and security teams; advise on Fabric capabilities and design trade-offs, and contribute to documentation/runbooks and best practices.

Skills, Experience and Competencies

Technical Skills

• Strong expertise in Microsoft Fabric and modern lakehouse architecture (including OneLake, Lakehouse / Warehouse, and Fabric experiences such as Data Engineering and Data Factory).
• Experience with data ingestion, transformation, and analytics pipelines (batch, streaming, near real-time) using Fabric capabilities.
• Strong SQL, data modelling, and analytical design skills; ability to build and optimise lakehouse / warehouse models and semantic models.
• Experience with Power BI semantic models and reporting; ability to enable enterprise-grade analytics and reporting solutions.
• Understanding of data governance, security, monitoring, and cost optimisation in modern data platforms; ability to contribute to operational runbooks and best practices.

Experience (Role Level Determination)

MDP Fabric Architect

• 10–15+ years of data and analytics experience
• 7–10+ years designing enterprise data platforms
• Proven experience defining modern data strategies and platforms

MDP Fabric Consultant

• 6–9 years of data and analytics experience
• 4–6 years delivering modern data platforms (Fabric / Azure Synapse / Power BI)
• Strong delivery, design, and stakeholder engagement skills

MDP Fabric Developer

• 4–6 years of overall data / BI experience
• 2–4 years of hands-on experience with Microsoft Fabric, Power BI, or Azure data services
• Strong focus on implementation and development

Competencies

• Data product mindset, treating datasets, semantic models and reporting outputs as products with clear owners, consumers, quality measures and lifecycle management.
• Business-to-technical translation and collaboration, working with stakeholders and delivery teams to shape use cases and requirements, and translating them into practical Fabric design decisions and incremental delivery plans.
• Governance and security by design embedding access control, privacy, lineage and compliance requirements into the Fabric solution from the outset.
• Iterative, outcome-driven delivery executing value in increments (ingestion → lakehouse / warehouse → semantic model → reports), validates with users, and applies reusable patterns and automation to improve consistency.
• Quality, observability and operational readiness, applying testing, reconciliation and monitoring; produces clear documentation and runbooks to support sustainable operations.

Qualifications and Certifications

• Microsoft Certified: Fabric Analytics Engineer (preferred).
• Microsoft Certified: Azure Data Engineer and/or Azure Data Analyst (preferred).
• Architect level (desirable): Azure Solutions Architect Expert.

What Success Looks Like

• Microsoft Fabric is implemented as a robust, scalable modern data platform.
• Data pipelines and analytics solutions are reliable, governed, and performant.
• Business users have trusted access to high-quality data and insights.
• Platform costs are controlled and optimised, and solutions are easy to operate, extend, and scale; Fabric is positioned as a strategic analytics and data foundation.