Data & AI Solutions Lead

We’re working with a forward-thinking organisation at the forefront of digital transformation. They are seeking a Data & AI Solutions Lead to drive innovation across Power BI, CoPilot and AI-driven reporting initiatives. This is a newly created role designed for someone passionate about turning data into actionable insight and enabling smarter, faster business decisions through intelligent automation.

The Opportunity

As the Data & AI Solutions Lead, you’ll take ownership of the organisation’s data reporting ecosystem – defining and implementing semantic data models, Power BI solutions and CoPilot integration. You’ll act as the go-to expert for business-wide data reporting needs, ensuring consistent governance, high-quality insights, and the adoption of AI-enabled tools to optimise performance.
Working collaboratively with both internal teams and third-party partners, you’ll lead projects that deliver measurable business value through innovation, automation and data-driven strategy.

Key Responsibilities
*Define, develop and maintain semantic data models to support Power BI reporting and CoPilot for Power BI insights.
*Ensure all models are well-governed and serve as a single source of truth for the organisation.
*Lead the design and delivery of Power BI dashboards, reports and data connections.
*Collaborate with internal and external stakeholders to strengthen data governance frameworks and ensure compliance.
*Partner with a third-party consultancy for Microsoft Fabric expertise, architecture and governance guidance.
*Design and deploy CoPilot agents that deliver tangible business benefits.
*Act as the technical mentor for Power BI and CoPilot users across the business, promoting best practice and adoption.
*Analyse business systems to identify opportunities for optimisation using AI and automation.
*Recommend and implement enhancements or new solutions to support business growth.

About You
You’ll be an experienced data professional with a passion for building scalable, intelligent reporting environments. You combine strong technical skills with the ability to engage stakeholders, simplify complexity and drive change.

Skills & Experience Required
*Proven background in Power BI development and semantic modelling.
*Strong understanding of data governance, DAX and Power Query.
*Experience working with SQL and relational databases.
*Familiarity with Microsoft CoPilot for Power BI and CoPilot agent development.
*Excellent communication skills, able to mentor technical and non-technical users.
*Experience in system analysis and using AI tools to enhance business processes.
*Knowledge of ERP systems and related data structures is advantageous.

Key Attributes
*Self-motivated and proactive with a continuous improvement mindset.
*Strong analytical and problem-solving skills.
*Excellent stakeholder management and influencing abilities.
*Comfortable translating complex requirements into practical, high-impact solutions.

The Details
*Location: Milton Keynes (Hybrid – typically 2 days a week on site)
*Travel: Occasional travel to other UK sites
*Salary: Competitive + benefits