Automation & BI Specialist (Power Platform + AI)

Anderson Scott Solutions Ltd; England; Hybrid; GBP 50,000 - 55,000; Full time

Job summary

Anderson Scott Solutions Ltd is seeking a hands-on Business Systems & Automation Specialist to enhance reporting, automate workflows and explore AI-enabled tools across finance, supply chain, payroll and support functions. You will translate business needs into practical technical solutions and own improvements from investigation through testing, implementation and ongoing support.

You will work with stakeholders to reduce manual tasks, improve data quality and enable better decision making

Qualifications

• Experience delivering practical improvements using business systems, reporting tools or automation platforms.
• Strong working knowledge of the Microsoft Power Platform, particularly Power BI, Power Automate and Power Pages.
• Experience analysing data, business processes and workflows to identify opportunities for improvement.
• Ability to understand requirements from non-technical users and translate them into workable solutions.
• A structured approach to testing, implementation and documentation.
• An understanding of data security, access controls and operational risks when introducing new systems or processes.
• Strong problem‑solving skills and the ability to manage tasks through to completion.
• Good communication skills, with the confidence to work with both technical and non‑technical stakeholders.

Responsibilities

• Analyse business processes across finance, supply chain, payroll and support functions to identify opportunities for improvement.
• Develop, implement and maintain workflow automations, approvals, alerts, task routing and exception‑handling processes.
• Create and enhance reporting and business insight using Microsoft Excel, Power Query, Power BI and other appropriate reporting tools.
• Support the design and development of Power Pages to improve data publication, client communications and business workflows.
• Investigate and test practical AI use cases using tools such as Microsoft Copilot, ChatGPT, Claude and other relevant platforms.
• Identify opportunities to reduce manual work, improve efficiency and enhance the quality and availability of business information.
• Work with stakeholders to understand operational challenges and translate requirements into practical technical solutions.
• Support the introduction of new systems, tools and workflows, ensuring appropriate testing and implementation.
• Promote the safe and effective adoption of automation and AI, taking account of data security, access controls and operational risks.
• Produce clear process documentation, user guides and supporting materials to ensure solutions are understood, maintained and used consistently.
• Provide guidance and support to colleagues adopting new processes and technology.
• Work collaboratively with internal teams and external technology partners to deliver improvements.

Job description

Anderson Scott Solutions Ltd is seeking a hands-on Business Systems & Automation Specialist to enhance reporting, automate workflows and explore AI-enabled tools across finance, supply chain, payroll and support functions. You will translate business needs into practical technical solutions and own improvements from investigation through testing, implementation and ongoing support.

You will work with stakeholders to reduce manual tasks, improve data quality and enable better decision making