VBA Developer

An exciting opportunity has arisen for a VBA Developer to join a leading professional services firm and help start their Audit and Data Analytics team.

This role is ideal for someone who enjoys problem-solving, automation, and data-driven innovation, with a focus on improving efficiency and insight across audit processes.

As a VBA Developer, you will play a key part in developing and enhancing analytics tools that support the audit function. You’ll work closely with technical specialists and audit professionals to design practical, efficient solutions.

Key responsibilities include:

• Develop and maintain VBA tools: Build and enhance Excel-based automation tools to improve data processing, audit testing, and reporting.
• Automate manual processes: Use VBA and related technologies to streamline repetitive tasks and increase efficiency across audit workflows.
• Integrate with Microsoft applications: Create solutions using Power BI, PowerApps, and Excel to support data analysis and visualization.
• Data handling: Extract, transform, and manipulate large datasets from multiple sources to provide accurate and actionable insights.
• Collaboration: Work with audit teams and stakeholders to understand requirements, design user-friendly tools, and ensure solutions meet business needs.
• Quality and compliance: Ensure accuracy, consistency, and reliability of all automated outputs in line with professional and regulatory standards.
• Innovation: Identify opportunities to improve processes and contribute to the continued development of data analytics capabilities within the firm.

We’re looking for a technically skilled and detail-oriented developer who’s eager to apply automation and analytics in a professional services environment.

Essential skills and experience:

• Strong VBA programming skills, particularly within Excel and the Microsoft Office suite.
• Experience automating workflows and building custom solutions.
• Solid understanding of data analysis and manipulation techniques.
• Excellent problem-solving and communication skills.
• Ability to translate technical concepts for non-technical users.

Desirable experience:

• Familiarity with Power BI, PowerApps, or SQL.
• Experience working in an audit, finance, or data analytics environment.
• Understanding of external data quality principles and process improvement.

• Competitive salary and a comprehensive benefits package including pension, healthcare, and wellbeing support.
• Hybrid working – typically three days in the office and two from home.
• Generous annual leave with the option to buy additional days.
• Ongoing training and professional development, with clear progression opportunities.
• A collaborative, inclusive workplace that values innovation, flexibility, and continuous improvement.
• Opportunities to engage in community and ESG initiatives, including volunteering and charitable giving.