About this role
Salary: £65,000 - 65,000 per year
Requirements
- Proven experience in a data, BI, AI or automation role, ideally with responsibility for leading or owning a data function in a growing business.
- Strong practical experience with Power BI, including dashboards, semantic models, DAX measures, data relationships, reporting and row-level security.
- Knowledge of Power Query, ETL processes, SQL and data transformation, with experience building and maintaining reliable data pipelines and data warehouse solutions.
- Demonstrable experience designing, developing and delivering workflow automation using Power Automate, Microsoft Power Platform or equivalent technologies.
- Hands-on experience with AI platforms such as Claude, Microsoft Copilot or similar, including developing prompts, workflows, projects and practical business applications.
- Working knowledge of Python, JavaScript, TypeScript or another programming language, and the ability to develop, troubleshoot, test and maintain code, including AI-generated code.
- Experience integrating business systems using APIs, connectors or other integration technologies; knowledge of AI connectors, MCP integrations or secure AI-to-system connections is advantageous.
- Strong understanding of data governance, information security, UK GDPR and responsible AI use, including access management for sensitive information and risk assessments or DPIAs where required.
- Experience with Microsoft 365, SharePoint and Entra ID, including user permissions, access controls, security settings and information sharing.
- Experience with Microsoft Fabric, data warehousing or modern data architecture is advantageous, along with an understanding of how data flows from source systems into reporting and analytics environments.
- Experience with Simpro, Xero or similar job management, operational or financial systems is beneficial.
- Experience in building maintenance, construction, compliance, facilities management or social housing is advantageous but not essential.
- Experience managing data, AI, software or technology suppliers, evaluating solutions, managing relationships and ensuring services deliver value.
- Degree in Computing, Data, Information Systems or a related discipline, or equivalent practical experience.
- Relevant certifications such as PL-300, PL-900, PL-400, SC-900, or data protection or information security qualifications are advantageous.
- Excellent communication, analytical and problem-solving skills, including the ability to explain technical concepts to non-technical colleagues, build relationships across the business, manage competing priorities, work independently and champion continuous improvement and innovation.
Responsibilities
- Lead and develop our data, reporting, automation and AI strategy to support business growth and operational performance.
- Own, develop and maintain our Power BI reporting estate, including dashboards, data models, DAX measures and reporting solutions.
- Design, build and maintain data pipelines, ETL processes and integrations across Simpro, Xero, Microsoft 365 and other business systems.
- Produce accurate reports, dashboards and analysis for directors, operational teams, finance, compliance and external clients.
- Improve data quality, accuracy and consistency by identifying issues at source and working with teams on lasting solutions.
- Identify opportunities to streamline business processes and reduce manual workloads through automation and digital solutions.
- Build, test and maintain automated workflows using Power Automate, APIs, Microsoft 365 and other relevant technologies.
- Develop and implement AI-powered tools, workflows and business solutions using platforms such as Claude, Microsoft Copilot and other emerging technologies.
- Write, review, test and maintain scripts, integrations and code supporting data, automation and AI solutions.
- Develop and maintain AI knowledge resources, business documentation and structured content, including bid libraries and internal knowledge bases.
- Establish and oversee the safe, responsible and effective use of AI across our business, including policies, approved tools and appropriate data access.
- Protect sensitive business, client and personal information through appropriate security controls, permissions, governance and data protection measures.
- Evaluate new technologies, AI platforms, integrations and suppliers to ensure solutions are secure, practical, cost-effective and aligned with business needs.
- Support, train and empower colleagues to use data, reporting, automation and AI confidently; provide ongoing technical guidance and measure improvements delivered.
Technologies
- AI
- Copilot
- Data Warehouse
- DAX
- ETL
- Fabric
- Support
- JavaScript
- MCP
- Microsoft 365
- Microsoft Power Platform
- Power BI
- Power Query
- Python
- SQL
- Security
- SharePoint
- TypeScript
- Office 365
More
We are offering a rare opportunity to shape the future of data, automation and AI within one of the UKs leading businesses, based in Dorset. Our organisation is innovative and forward-thinking, values talent, supports career progression and empowers its people to make a real impact. The role offers a competitive salary depending on experience, Monday-to-Friday hybrid working, access to a leading UK wealth management pension scheme, career development prospects, and national training to help you upskill.
last updated 47 week of 2026