Business & Systems Lead
Job description
Original text imported from Reed
Business & Systems Lead
Dudley (5 days per week on site)
£50,000 to £75,000 per annum
Permanent
I am currently looking for a Business and Systems Analyst to join a well-established organisation based in Dudley, supporting the transformation of their back-office operations. This role is perfect for someone who thrives on making processes more efficient, enjoys working with data, and is passionate about creating user-friendly solutions that add real value.
Business & Systems Lead - What will you be doing?
* Collaborating with operational teams to understand current manual processes for capturing performance data and identify opportunities for automation using Power Query and other tools.
* Integrating data from various systems, spreadsheets, and Sage 50.
* Designing intuitive user interfaces that make it easy for non-technical users to access, interpret, and use performance information effectively.
* Developing strong backend solutions that ensure reliable data extraction, transformation, and storage while maintaining low operational costs.
* Working with administrative staff to transition from spreadsheet-based tracking to automated systems that reduce errors and save time.
* Supporting the implementation of the new workforce management system by mapping out data flows, identifying gaps, and recommending best practices for ongoing maintenance.
Business & Systems Lead - What will you need?
* Demonstrated experience using Power Query or similar tools for automating data extraction from legacy systems such as Sage 50.
* Proven track record of integrating multiple data sources into centralised reporting environments within complex organisations.
* Experience designing user interfaces that prioritise ease-of-use for non-technical stakeholders across diverse teams.
* Excellent communication skills enabling you to translate technical requirements into clear instructions or training materials for end-users.
* Experience supporting digital transformation projects within highly regulated sectors such as healthcare or social care would be advantageous.
* Comfortable working collaboratively with administrative staff who may have limited exposure to technology-driven change initiatives.
Robert Walters are proud to specialise in BI & Data recruitment across the UK, offering amazing opportunities on a permanent and interim basis. We are also proud to be heading up the Data Leaders roundtables and PBI BRUM meetup group, bringing new and exciting networking opportunities to candidates and clients in the Midlands.
If you would be interested in speaking about the role or having a general chat about your job search, please send your CV to .
*Applicants must reside in the UK & have full right to work*
Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Key skills
AI-extracted from the job advert
Application advice
5 AI-generated recommendations to maximise your chances.
⭐ Highlight your Power Query expertise prominently as this is the primary technical requirement mentioned throughout the advert
📊 Quantify your data integration achievements: 'Integrated 8 legacy systems reducing manual processing by 65%'
🌐 Emphasise experience with Sage 50 or similar ERP systems as they specifically mention this platform
🎯 Showcase user interface design skills for non-technical users as this is a key differentiator they're seeking
🤝 Demonstrate experience supporting digital transformation in regulated sectors like healthcare or social care
Suggested CV bullets
3 bullets our AI drafted for this specific advert, mirroring its ATS keywords.
Add these 3 bullets under your most recent experience:
- •Automated data extraction from 5 legacy systems using Power Query, reducing manual processing time by 70% and eliminating 15 hours of weekly administrative work
- •Designed intuitive user interfaces for 25 non-technical staff members, achieving 95% user adoption rate within 6 weeks of system deployment
- •Led Sage 50 integration project connecting 3 data sources into centralised reporting environment, improving data accuracy by 85% across operations team
Free to copy — tailoring requires a 30-sec CV upload.
Your cover letter is ready
We've drafted a cover letter for Robert Walters. Preview the opening, then unlock the full personalised version.
Letter preview — tailored to Robert Walters
Dear Hiring Manager,
Your Business & Systems Lead role at the Dudley organisation represents exactly the type of digital transformation challenge I excel at. My proven experience with Power Query automation and Sage 50 integration aligns perfectly with your need to transform back-office operations from manual processes to efficient automated systems.
My background in designing user-friendly interfaces for non-technical stakeholders and supporting digital transformation projects in regulated environments positions me well to collaborate effectively with your administrative teams while ensuring seamless system transitions.
Free signup, no card needed. Export to PDF/Word requires a £1.99 trial (14 days).
Interview questions
10 questions generated from this advert.
Technical
- ›How would you approach integrating data from Sage 50 with other legacy systems using Power Query?
- ›Describe your process for designing user interfaces that non-technical staff can easily navigate
- ›What strategies do you use to ensure data quality when extracting from multiple sources?
- ›How would you map data flows for a new workforce management system implementation?
- ›What backend architecture would you recommend for reliable data storage while maintaining low costs?
Behavioural
- ›Tell me about a time you helped transition a team from manual processes to automated systems
- ›Describe a situation where you had to explain technical concepts to non-technical stakeholders
- ›Give an example of how you've collaborated with administrative staff during a system change
- ›Tell me about a digital transformation project you supported in a regulated environment
- ›Describe a time when you identified opportunities for process automation and the impact it had
STAR answer examples
Model answers using the Situation-Task-Action-Result framework. Adapt to your own experience.
Tell me about a time you helped transition a team from manual processes to automated systems
Describe a situation where you had to explain technical concepts to non-technical stakeholders