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.