Senior VBA Developer
ago
Location
Doha, London
Hybrid
Salary
£600+
Experience Level
Entry
Junior
Mid
Senior
Expert
Our Client
International Energy Company
SPECIALTY
Oil, Gas, LNG, Shipping
INDUSTRY
Energy
Company Size
10000+ Employees
Aubay's Take
Our client is an international energy company who covers the full spectrum of the oil and gas value chain. Our client is dedicated to attracting and hiring the highest calibre employees, from all around the world. As they scale their operations, they are committed to operating in a socially responsible manner, supporting, nurturing, and empowering their people, investing their resources to responsibly and safely contribute to the communities of which they are a part.
Benefits from Aubay
At Aubay UK, people are at the heart of our business. We offer a competitive remunerations package which includes a range of benefits. You will receive continuous support from our dedicated team of Talent Acquisition Specialists who will support your career development and success during your assignment with our client.
25 Days Annual Leave
Work From Home Opportunities
Pension Scheme
Opportunities to Work Directly with our Client
Training Opportunities
Discount Holidays at I'Aero Chalet
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.