Data and Automation Business Analyst

Power BI, Power Platform & AI Innovation | £37k-£41k + Bonus + PMI | Dorset

Salary: £37,000 - £41,000 DOE + Benefits + Bonus scheme

Location:

Dorset (primarily office-based, with some flexibility)

Hours:

37.5 hours per week, Monday to Friday

A growing organisation is seeking a Data and Automation Business Analyst to support its digital transformation and AI adoption strategy.

Reporting to the IT Director, you'll help teams across the business improve decision-making, streamline processes and unlock the value of their data through Power BI,

Power Platform and AI-driven solutions.

This is a varied, hands-on role that combines data analytics, automation development and emerging AI technologies, giving you the opportunity to make a genuine impact across the organisation.

• Design, develop and maintain Power BI dashboards and reports.
• Analyse, transform and visualise data from multiple sources.
• Build solutions using Power Apps, Power Automate and Dataverse.
• Develop automation workflows that improve efficiency and reduce manual processes.
• Collaborate with stakeholders to gather requirements and deliver practical solutions.
• Identify and implement opportunities to use AI tools such as Microsoft Copilot and Claude.
• Support data governance, security and GDPR-compliant data handling.
• Explore innovative approaches using AI, automation and potentially Python-based solutions.

• Proven experience in a Data Analyst, BI Developer, Power Platform Developer or similar role.
• Strong Power BI skills, including DAX, Power Query, data modelling and dashboard creation.
• Experience with Power Apps, Power Automate and Dataverse.
• Advanced Excel skills.
• Strong analytical, problem-solving and stakeholder management abilities.
• Passion for automation, innovation and continuous improvement.

• SQL and/or Python experience.
• API integrations and automation experience.
• Exposure to Microsoft Fabric, Azure or Copilot Studio.
• Experience implementing AI solutions within a business environment.

• £37,000 - £41,000 salary depending on experience
• Bonus scheme-
• The company bonus scheme is paid annually up to 2.5% of salary depending on the company financial performance. Everyone gets the same % and it is not based on individual performance.
• Pension
• Private Medical Insurance
• Holiday entitlement is 25 days per year.
• Opportunity to influence the organisation's AI and automation strategy
• Exposure to cutting-edge technologies and digital transformation projects
• Collaborative working environment with direct access to senior leadership

The organisation values face-to-face collaboration, so candidates should be comfortable spending most of their time in the Dorset office. Some hybrid flexibility may be available for the right person