Data and Automation Business Analyst

HR GO Recruitment; Dorchester; On-site; GBP 37,000 - 41,000; Full time

Benefits offered by this job

Bonus scheme

Pension

Private Medical Insurance

25 days holiday

Hybrid/flexible work

Tech / AI exposure

Job summary

HR GO Recruitment is looking for a Data and Automation Business Analyst in Dorset to support digital transformation and AI adoption. You will design, develop and maintain Power BI dashboards, analyze data, and build solutions using Power Apps, Power Automate and Dataverse.

Reporting to the IT Director, you will collaborate with stakeholders to drive automation and AI initiatives while ensuring GDPR-compliant data handling and contributing to continuous improvement across the organisation.

Qualifications

• Proven experience in a Data Analyst, BI Developer or Power Platform Developer 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.

Responsibilities

• 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.

Skills

Power BI

Power Query

DAX

Dataverse

Excel

Stakeholder mgmt

Power Platform

Python

Tools

Power Apps

Power Automate

Dataverse

Azure

Job description

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

The Opportunity

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.

Key Responsibilitiesof Data and Automation Business Analyst

• 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.

About You

Essential

• 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.

Desirable

• 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.

What's on Offer?

• £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

Working Pattern

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