The Microsoft Fabric Engineer carries out the following activities:
1. Microsoft Fabric Design & Implementation
· Design Microsoft Fabric solutions that align to customer data strategies, business outcomes and technical requirements.
· Install, configure and set up Microsoft Fabric environments, including workspaces, capacities, security models and tenant-level settings.
· Configure OneLake, Lakehouses, Warehouses, Dataflows, Pipelines, Notebooks and semantic models to support scalable data ingestion, transformation and reporting.
· Develop robust data engineering patterns using Microsoft Fabric Data Factory, Data Engineering and Data Warehouse capabilities.
· Support the migration of existing data workloads from legacy platforms, Azure Synapse, SQL Server, Power BI or other analytics environments into Microsoft Fabric.
· Apply best practice across performance, security, governance, cost control and operational resilience.
· Produce high-quality technical documentation, including solution designs, configuration guides, deployment plans and support handover materials.
· Work closely with architects, data engineers, analysts and customer stakeholders to ensure Fabric solutions are practical, secure and deliverable.
2. Data Engineering, Integration & Analytics
· Build and maintain data pipelines to ingest, transform and publish data from a range of structured and unstructured sources.
· Develop Lakehouse and Warehouse solutions that support analytics, reporting, operational insight and downstream data consumption.
· Create and optimise semantic models to support Power BI reporting and self-service analytics.
· Configure data refresh, scheduling, monitoring and alerting processes to support reliable production services.
· Support integration with Azure services, Microsoft Purview, Power Platform, APIs, databases and third-party applications.
· Optimise queries, workloads, storage structures and data models to improve performance and reduce cost.
· Ensure solutions are designed with appropriate data quality, lineage, access control and governance controls.
3. Platform Configuration, Security & Governance
· Configure Microsoft Fabric workspaces, permissions, deployment pipelines, capacity settings and environment controls.
· Implement role-based access control, sensitivity labelling, data protection and secure-by-design configuration patterns.
· Support governance and catalogue integration, including alignment with Microsoft Purview where required.
· Establish monitoring, logging and operational support processes for Fabric workloads.
· Troubleshoot platform, pipeline, data modelling, refresh, connectivity and performance issues.
· Support testing, release management and transition into live service.
· Contribute to technical assurance reviews, identifying risks, dependencies and improvement opportunities.
· Maintain awareness of Microsoft Fabric product updates, licensing changes and emerging best practice.
4. Collaboration & Capability Development
· Work collaboratively with delivery teams, architects, business analysts and customer stakeholders to translate requirements into working Fabric solutions.
· Support pre-sales and discovery activity by providing technical input, estimates and solution options where required.
· Contribute to reusable Methods assets, accelerators, templates and delivery standards for Microsoft Fabric.
· Share knowledge with colleagues and support the development of Methods’ wider data, analytics and Microsoft capability.