VBA DevEloper/BA

VBA/Net Developer/Business Analyst required in London.

Location London- Hybrid very flexible

Rates competitive via umbrella

Our client is an international energy and services company providing energy services to consumers across the globe and driving innovative products and solutions to drive power to the customer in more ways than one.

Overview:

The Market Data Platform team plays a pivotal role in ensuring our traders have access to accurate, real-time market data for informed decision-making. In addition to the Market Data Platform, the team is responsible for Front Office Tooling around price publishing. The team also supports 400+ users and 40+ interfacing applications for all forward and settlement price requirements.

Position Overview:

My client are seeking a talented and versatile individual who possesses a blend of business analysis and development skills. Experience in Excel, .NET, VBA is required.

Key Responsibilities:

• Collaborate and coordinate across stakeholders to refine requirements, test solutions and deploy them into production.
• Design, develop, and maintain Excel-based tools and add-ins.
• Maintain and develop .NET and VBA Front Office solutions.
• Integrate third-party Excel add-ins, such as Trayport and Bloomberg, into existing systems and workflows.
• Integrate key applications within the system landscape.
• Ensure data accuracy and integrity within the Market Data Platform, working closely with front office, QA, market risk, product control and curves teams.
• Provide ongoing support and troubleshooting for Excel-based tools and trading applications across the organisation.

Qualifications:

Required:

• Bachelor's degree in computer science, finance, or related field.
• Proven experience as a hybrid business analyst/developer in the financial services industry, with a focus on commodities trading preferred.
• Strong proficiency and experience in Excel, including advanced formulas, pivot tables, and VBA macros.
• Strong proficiency and experience in .NET Development
• Excellent organizational skills and ability to work in an agile/devops environment.
• Strong communication skills and ability to interact effectively with traders and stakeholders.
• Ability to multitask and prioritize tasks in a fast-paced trading environment.

Optional but highly desirable:

• Experience building Excel add-ins.
• Experience with Trayport and Bloomberg, particularly their Excel add-ins.
• Experience working with trading platforms such as OpenLink Endur, particularly around Market Manager projection indices and historical prices.
• Experience with external Rest APIs, for example from EEX, ICE, ICIS etc.
• Experience with AWS cloud services, including AWS WAF (Web Application Firewall), AWS Lambda (serverless computing), and Amazon MSK (Managed Streaming for Apache Kafka)

Pontoon is an employment consultancy. We put expertise, energy, and passion into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an all-encompassing environment that helps them thrive.

Candidates will ideally show evidence of the above in their CV in order to be considered.

Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly.

Pontoon is an employment consultancy and operates as an equal opportunity's employer.

Please email me