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

Image of the recruiter for this specific role

Have Questions?

Contact Michael

Email - [email protected]

LinkedIn - Michael's Profile

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.