Senior VBA Developer

3 month initial contract

Up to £700 per day inside IR35

Role Summary

Aubay is seeking a Senior VBA Developer to join our client's team in the energy sector. This role is ideal for a highly skilled VBA developer with a keen eye for performance optimisation, looking to work on complex data-driven solutions in a dynamic environment. The position involves substantial travel to Doha, Qatar. Further details about the travel requirements will be provided during the interview process.

Required Skills and Experience
• Advanced expertise in Excel VBA development, including writing efficient macros and automation scripts.
• Proven experience optimising Excel workbooks for high performance, ensuring minimal latency during calculations.
• Strong understanding of data handling and processing within Excel, including formulas, pivot tables, and external data connections.
• Ability to troubleshoot and debug complex VBA code efficiently.
• Experience in performance tuning and memory optimisation within Excel-based solutions.
• Familiarity with integrating VBA solutions with databases and external data sources.
• Excellent problem-solving skills and ability to work independently on development tasks.
• Strong communication and stakeholder management skills to understand and deliver business requirements.

Desired Skills and Experience
• Knowledge of financial or energy trading systems and their data structures.
• Experience working with Power Query, Power BI, or SQL to enhance data processing within Excel.
• Understanding of agile development methodologies and version control systems.

Key Role Responsibilities
• Develop and optimise Excel VBA solutions to handle and process large datasets efficiently.
• Ensure high-performance Excel workbooks with imperceptible lag, even during extensive calculations and updates.
• Identify performance bottlenecks in existing VBA solutions and implement enhancements to improve speed and reliability.
• Collaborate with internal stakeholders to understand business requirements and translate them into scalable VBA solutions.
• Maintain and update existing Excel-based tools, ensuring compatibility with evolving business needs.
• Develop robust error-handling and debugging mechanisms to improve system stability.
• Document VBA code and processes to ensure maintainability and knowledge transfer within the team.
• Provide training and support to end-users on optimised Excel VBA solutions.