Data and Automation Business Analyst

Salary: £37,000 - 41,000 per year

Requirements:

• 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 (desirable)
• API integrations and automation experience (desirable)
• Exposure to Microsoft Fabric, Azure, or Copilot Studio (desirable)
• Experience implementing AI solutions within a business environment (desirable)
• Comfortable spending most of your time in our Dorset office

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 to 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

Technologies:

• AI
• API
• Azure
• Copilot
• DAX
• Excel
• Fabric
• Support
• Power BI
• Power Query
• Python
• SQL
• Security
• Cloud

More:

We are a growing organisation pursuing digital transformation and AI adoption. Reporting to our IT Director, you will work with teams across the business to improve decision-making, streamline processes, and unlock the value of data through Power BI, Power Platform, and AI-driven solutions. This varied, hands-on role offers the opportunity to influence our AI and automation strategy and contribute to digital transformation projects, with exposure to emerging technologies and direct access to senior leadership in a collaborative environment. The role is based primarily in our Dorset office, with some hybrid flexibility potentially available. We offer a salary of £37,000–£41,000 depending on experience, an annual company bonus of up to 2.5% depending on financial performance, a pension, private medical insurance, and 25 days of annual holiday. Hours are 37.5 per week, Monday to Friday.

last updated 40 week of 2026