Project Foundry | Contract | Microsoft Fabric + Power BI
ABOUT THE ROLE
This role sits at the intersection of data engineering and business intelligence, building the data products and supporting the AI agent data layer that power a Microsoft Fabric and Power BI programme. Day-to-day work splits across two areas: delivering standard data products — pipelines, Lakehouses, and Power BI reports — and maintaining the data infrastructure that enables AI agents to operate accurately and at pace. A senior Data Engineer and Architect is already in place to provide technical direction and handle complex design decisions. This role is about hands‑on delivery — building, maintaining, and iterating on pipelines, data models, and reports. This is a combined Fabric developer and data engineering role for a technically grounded, delivery‑focused developer who gets things built and keeps them running.
KEY RESPONSIBILITIES
Build and maintain Power BI reports and dashboards used by business stakeholders, with strong data modelling in Power BI Desktop using relationships, calculated columns, and DAX measures
Work hands‑on with Microsoft Fabric workspaces, Lakehouse, and Dataflows Gen2 to understand how data moves through Fabric and connects to Power BI semantic models
Build and maintain reliable data pipelines in Microsoft Fabric or Azure Data Factory to ingest and move data from source systems including SQL databases, APIs, SharePoint lists, and flat files into the Lakehouse
Write solid SQL queries for transforming and preparing data, creating views and transformation queries that clean and shape data for reports and AI agents
Write and maintain PySpark or Python notebooks in Fabric for data transformation tasks, using tools like GitHub Copilot to accelerate this work effectively
Support the AI agent data layer by preparing and maintaining Gold layer tables, keeping Azure AI Search indexes in sync with source documents for RAG‑based agents, and writing agent outputs back to Fabric tables
Monitor pipeline health to ensure agents consume accurate and fresh data, and collaborate closely with the senior Data Engineer and Architect within an established technical architecture
Keep pace with Microsoft Fabric platform updates and apply new capabilities as they become available
ESSENTIAL REQUIREMENTS
Hands‑on Microsoft Fabric experience across workspaces, Lakehouse, and Dataflows Gen2
Strong Power BI report and data modelling capability with understanding of well‑structured semantic models versus flat table reports
Ability to build and maintain reliable data pipelines from varied source systems
Solid SQL for querying, transforming and preparing data
Comfort reading, editing and running Python or PySpark notebooks
Experience with data pipeline orchestration and basic scheduling with failure alerting
A growth mindset and genuine interest in AI‑adjacent data patterns
Ability to work productively within an established technical architecture
4‑8 years of experience at mid‑level
DESIRABLE REQUIREMENTS
Azure AI Search experience for indexing Fabric and SharePoint content for RAG‑based AI agents
DAX beyond basic measures including time intelligence, calculated tables, and row context
Azure Data Factory experience, which maps directly to Fabric Pipelines
Power BI Service administration experience including workspaces, row‑level security, and deployment pipelines
Delta Lake basics including understanding of Bronze / Silver / Gold layers and incremental load patterns
KQL (Kusto Query Language) knowledge for Fabric Eventhouse and real‑time use cases
DP‑600 (Fabric Analytics Engineer) certification
Portfolio of delivered Fabric and Power BI work with pipelines in production and semantic models serving real users
CERTIFICATIONS
PL‑300 (Power BI Data Analyst) – Preferred as a strong signal of report‑building and data modelling capability
DP‑600 (Fabric Analytics Engineer) – Preferred but not required; hands‑on Fabric experience carries more weight than the certificate at this stage
DP‑900 (Azure Data Fundamentals) – Acceptable minimum for appointment with a clear plan to progress toward PL‑300 or DP‑600 in the near term
A strong portfolio of delivered Fabric and Power BI work will carry more weight than qualifications alone
CONTRACT DETAILS
Contract Type: Daily Rate Contract (6 months initially)
Location: TBC
Other Requirements: Growth mindset required; hands‑on delivery focus
WHAT YOU WILL WORK ON
Data products (majority of time): delivering reliable, well‑structured data products for business stakeholders including Power BI reports and dashboards, Fabric pipelines ingesting data from operational systems and APIs, and Lakehouse tables serving as single source of truth
AI agent data layer (growing part of role): supporting infrastructure for AI agents including Gold layer table preparation and maintenance, Azure AI Search index synchronization, and agent output management
Collaboration and iteration: working within an established technical architecture led by a senior Data Engineer and Architect, collaborating closely with business stakeholders and iterating quickly based on feedback
Platform evolution: keeping pace with Microsoft Fabric platform updates and applying new capabilities as they become available in a maturing technology stack
#J-18808-Ljbffr