Data and Automation Business Analyst

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
Only candidates based in UK and eligible to work in UK are allowed