AI Data & Semantic Engineer

About the role

A major professional services organisation wants a hands-on AI Data & Semantic Engineer to unlock the value of its enterprise data through AI. It has an established Microsoft Fabric platform and is accelerating its use of Claude Enterprise. The engineer builds semantic models and data integrations so AI can answer business questions accurately using trusted enterprise data. The role is based in London, two days a week, on a 12-month contract outside IR35, paid £580-£600 per day.

Key responsibilities

• Build and optimise semantic models across CRM and Practice Management System (PMS) data in Microsoft Fabric.
• Enable Claude Enterprise and AI agents to query structured enterprise data.
• Map natural-language questions to trusted metrics, relationships and calculations.
• Validate AI-generated answers against existing Power BI reports.
• Resolve data quality and integration issues, developing reusable patterns for additional datasets.
• Support the wider Data Services team through technical guidance and knowledge transfer.

Required profile

• Strong hands-on Microsoft Fabric experience, including Lakehouses, Warehouses, pipelines and semantic models.
• Advanced SQL, dimensional modelling, Power BI and governed business metrics.
• Practical experience connecting LLMs or AI agents to structured enterprise data, beyond document-based RAG.
• Strong understanding of data quality, governance and access controls.
• Proven ability to build and productionise scalable data solutions.
• Desirable: Claude Enterprise, MCP, Fabric data agents or comparable AI-to-data integration technologies.

The goal is to validate AI responses against existing Power BI reporting, then scale the capability across about 150 additional business questions and further enterprise datasets. This is a hands-on engineering role focused on a scalable, production-ready enterprise AI capability, not a standalone proof of concept. RSG Plc acts as the employment business for the vacancy.