KL Talent Solutions is working on behalf of our client to recruit a Business Systems Specialist to join their team in Belmont, Durham.
This role is centred around maintaining, improving and developing the business's critical Excel-based systems. These systems are relied upon daily to support commercial decisions, operational planning and reporting, making this a key position within the organisation.
We're looking for someone who enjoys understanding how complex systems work, identifying opportunities to improve them and ensuring they remain reliable, accurate and scalable.
Whether you're looking for a permanent opportunity or an interim assignment, we'd like to hear from you.
What You'll Be Doing
As the Business Systems Specialist, you'll become the subject matter expert for a range of complex Excel models and automated business tools.
Your responsibilities will include:
Excel Systems Development
Maintaining and enhancing large, complex Excel workbooks.
Developing new functionality using advanced formulas, named ranges and dynamic models.
Improving workbook performance and usability.
Designing new spreadsheets to support evolving business requirements.
Automation & VBA
Writing, maintaining and improving VBA code.
Developing macros to automate repetitive business processes.
Reducing manual intervention through automation.
Supporting future process improvements and system enhancements.
Data & Database Integration
Managing links between Excel and external systems.
Creating and maintaining SQL queries.
Working with database interfaces to ensure reliable data flow.
Maintaining data integrity across multiple business systems.
Testing & Quality Assurance
Testing changes before implementation.
Identifying bugs and investigating system issues.
Ensuring calculations remain accurate following updates.
Maintaining robust error handling throughout business models.
System Governance
Implementing version control across key spreadsheets.
Producing technical documentation.
Maintaining data validation rules.
Ensuring users are working from approved versions.
Supporting colleagues with system-related queries.
What We're Looking For
You'll be someone who enjoys solving technical problems and isn't intimidated by large, complex spreadsheets.
You'll have the ability to understand existing systems quickly while also identifying opportunities to improve efficiency and reliability.
Essential Experience
Advanced Microsoft Excel
Complex formulas
Dynamic arrays
Named ranges
Pivot Tables
Workbook optimisation
Large linked workbooks
VBA & Automation
Writing VBA from scratch
Editing and troubleshooting existing code
Macro development
Process automation
SQL & Data
SQL query writing
Database fundamentals
Excel database connections
External data sources
Data imports and exports
System Controls
Data validation
Error handling
Version control
Software testing
Regression testing
Documentation
Personal Skills
Excellent analytical ability
Logical problem-solving
High attention to detail
Strong communication skills
Ability to manage multiple priorities
Desirable
Power Query
Power BI
Microsoft Access
ERP or MRP systems
Manufacturing or engineering experience
Why Apply?
Join a business where your expertise will genuinely make a difference.
Take ownership of business-critical systems.
Influence future automation and process improvements.
Work on varied and technically challenging projects.
Temporary and permanent opportunities available.
Competitive salary based on experience.
TPBN1_UKTJ
Read Less
