VBA Developer

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. VBA/Net Developer/Business Analyst London Location London- Hybrid very flexible £850 per day inside IR35 / 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) Front office focused, Hourly communicating with traders, managing stakeholders, Interviewed by senior .net devs and excel experts Multiple projects, one aspect role will be to replace tooling/suggest propose projects, potentially put business cases together. Aws/cloud optional Team size - 40 people Core team 10/11 4 senior .net developers 10 ba's 3 things- Macros, excel formulas' .net, a key thing would be, have they built an excel add on