VBA Developer

Job Description: VBA Developer

Location: Bury, Lancashire

Reports to: IT Manager

Salary: £45,000 to £55,000 per annum

Position Type: Fixed Term (Min 2-year commitment) Full-time (min 4 days per week)

Company Overview

Beechfield Brands operate four leading textile accessory brands, supplied to the rebranding, personalisation, and promotional industry. The brands, Beechfield®, BagBase®, Quadra® and Westford Mill® are distributed through a network of distribution partners operating throughout Europe.

Beechfield Brands products are Designed for Decoration' with the aim of easy rebranding, by trade re-processors, such as printers and embroiderers. We currently have over 3000 SKUs and approximately 500 styles across our range of headwear, bags, and accessories.

You can find out more about our purpose and impact on our website

Our Core Values

As part of this team, you will be expected to be aligned to and promote the core values of Beechfield Brands of being Passionate, Progressive, Proud and Together in all your dealings, both externally and internally. You will b e guided, consistently, by these values in your day-to-day role.

The Core Purpose of this role

The core purpose of this role is to maintain and enhance Beechfield Brands' core Line of Business application, a business-critical system built in Access VBA with a SQL Server Back End. This application underpins Sales Order Processing and Purchasing functions. The role will ensure system reliability, performance, data integrity, and continuous improvement. The post-holder will also support enhancements, new functionality requests, data preparation for BI and data migration, and contribute to documentation and data quality initiatives.

Key Responsibilities and Duties

• Diagnose and resolve issues in the Line of Business application within agreed service levels.

• Maintain and optimise the SQL Server Back End to ensure availability, integrity, and performance.

• Ensure backups are completed in accordance with DR policy standards.

• Identify opportunities to improve system reliability and implement agreed solutions.

• Respond to user requests for changes or enhancements; analyse, scope, estimate and implement solutions following management approval.

• Assist in preparing and cleansing data for future system migrations.

• Prepare data extracts for use with Business Intelligence tools (eg, Power BI).

• Produce high-quality technical and user documentation, including revisiting areas of the existing system that lack up-to-date documentation.

• Conduct data quality improvements aligned to our Data Audit findings.

• Collaborate effectively with IT, PMO, BI and operational teams to ensure system functionality aligns with evolving business needs.

Key relationships

In this role, the core relationships with be with:

• IT Manager

• PMO Team

• BI Data Analyst

• S ales Order Processing and Purchasing Service Users

• External stakeholders or partners supporting SQL Server or system integrations (as required)

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software Engineering or equivalent (desirable) Professional certifications in Microsoft technologies (SQL Server, VBA, Access, or related fields) (optional but advantageous)

Essential criteria

• Proven experience supporting Legacy systems in business-critical environments

• Strong, hands-on experience with Access VBA development and debugging

• Solid knowledge of SQL Server, including stored procedures, indexing, performance tuning, and backup processes

• Ability to interpret and evolve existing systems with minimal documentation

• Experience working closely with non-technical users to translate requirements into technical solutions

• Ability to work autonomously and manage conflicting priorities effectively

• Available for Full time hours (minimum four days per week) with flexibility for occasional emergency out-of- hours support

• Able to attend the Bury office as required.

Desirable criteria

• 5+ years of experience supporting and maintaining

• Access applications backed by SQL Server

• Exposure to ERP systems, MRP or order-processing workflows

• Experience working in medium-sized, entrepreneurial or rapidly scaling environments

• Experience supporting BI or reporting environments (eg, Power BI)

• Experience contributing to data migration or digital transformation projects.

Company Benefits

Because we really care about our team members, we offer a fantastic range of benefits; the core ones are listed here:

• 22 days holiday increasing with length of service

• Birthday off - Additional to your annual leave

• Private Healthcare Scheme

• 4% employer pension contributions

• Life Assurance x4 annual salary to the loved one(s) you have nominated

• Modern office space with free parking and free onsite electric vehicle charging points.

Equal Opportunity Statement:

We are committed to creating a diverse and inclusive workplace. We welcome applications from all qualified candidates, regardless of race, gender, disability, religion/belief, sexual orientation, or age