Business Systems Specialist (Advanced Excel, VBA & SQL)

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.