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 within a growing business.
- Strong practical experience with Power BI, including developing dashboards, semantic models, DAX measures, data relationships, reporting and row-level security.
- Good 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, with 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 the responsible use of AI, including managing access to sensitive information and undertaking risk assessments or DPIAs where required.
- Experience working 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, alongside an understanding of how data flows from source systems into reporting and analytics environments.
- Experience working with Simpro, Xero or similar job management, operational or financial systems is beneficial, with an understanding of how business data supports operational and commercial performance.
- Experience within building maintenance, construction, compliance, facilities management or social housing is advantageous, although not essential.
- 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, data protection or information security qualifications are advantageous.
- Excellent communication, analytical and problem-solving skills, with the ability to explain technical concepts to non-technical colleagues, build relationships across the business, manage competing priorities, work independently and champion continuous improvement, innovation and the effective use of technology.
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.
- Produce accurate reports, dashboards and analysis for directors, operational teams, finance, compliance and external clients.
- 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 by implementing 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 an opportunity to shape the future of data, automation and AI within one of the UKs leading businesses, based in Dorset. This is a role for an experienced professional who can take ownership, build solutions from the ground up and balance technical delivery with business priorities. We offer a competitive salary depending on experience, Monday-to-Friday hybrid working, access to the UKs leading wealth management pension scheme, career development prospects, and national training to help you build your skills. We are an innovative, forward-thinking organisation that values talent, supports career progression and empowers our team to make a meaningful impact.
last updated 47 week of 2026