Senior Enterprise Technology Engineer

BP Business Solutions India Private Limited; Greater London; Hybrid; GBP 65,000 - 95,000; Full time

Job summary

bp is seeking a Senior Enterprise Technology Engineer in London to lead the development of End User Computing tools for the Front Office trading desk. You will design and optimize Excel-based workflows, VBA/CO-Pilot prompts, and real-time pricing tools, collaborating with traders and analysts.

The role requires strong OO programming (C#, Python, Java), SQL Server design skills, and experience with Power BI; hybrid working in London with travel up to 10%.

Qualifications

• Expert level Excel 365 including VBA and dynamic arrays.
• Strong SQL Server knowledge and database design.
• OO programming experience (C#, Java, Python).
• Experience with Power BI and data querying in M language.

Responsibilities

• Develop and support EUC applications for Oil Trading Front Office.
• Collaborate with Traders/Analysts to deliver new EUC tools.
• Enhance Excel workflows and trader pricing tools with controls.
• Provide Microsoft Office expertise and guidance to users.

Skills

Excel 365

VBA

SQL Server

C# OO

Python

Power BI

Front Office trading

OO concepts

Education

Degree in computer science or related subject

Tools

Visual Studio Tools for Office

Excel DNA

Azure DevOps

Jupyter Notebooks

Job description

Entity:
Technology
Job Family Group:
IT&S Group
Job Description:

Senior Enterprise Technology Engineer

- The role is for a senior Microsoft Office platform expert developer in the London EUC (End User Computing) RAD team
- The EUC team is a small team of 4 senior experienced developers serving users across the entire RPTE trading floor.
- R&PTE (Refining & Product Trading Europe) is one of the key parts of Supply Trading & Shipping. This role works very closely with R&PTE at all levels to ensure the best use of MS Office technology, seeking continuous improvement to existing processes as well as building new EUC tools direct with users.
- Significant direct interaction with Front Office traders and trade exposure analysts to develop and support critical trading tools.

Key Accountabilities

- Development/Support and continuous improvement of EUC (End User Computing) applications and processes for the Oil Trading Front Office.
- Complete work on projects often working individually directly with Traders/Analysts/Middle Office. Tasks may range in length from 1 day to 1 month+ responding to frequent priority changes, often working on multiple projects at a time with a mixture of urgent specific short development tasks against longer term tasks.
- Problem solve and improve manual front office workflows /data sharing. Innovate and share learning experiences and explore new techniques and EUC Technologies to solve problems.
- Provide general Microsoft Office expertise and advice to end users.
- Enhance user developed EUC spreadsheets.
- Build trader pricing tools with appropriate controls for real time multi user operation.
- Develop complex trade exposure analysis tools.
- Develop / Support Excel customisations (C# VSTO, Excel DNA).
- Implement and teach best practice.

Essential Education

- Degree/HND Level in computer science or related subject

Essential Experience and Job Requirements

- Extensive knowledge of Microsoft Excel 365, including expert level VBA and formulas, inc dynamic array and lambdas.
- Good knowledge of SQL Server including database design, stored procedures.
- Strong knowledge of Co-Pilot/Claude prompting and enthusiasm towards using AI as a development tool.
- Experience developing in an Object Orientated language such as C#, Java, Python (2 years+) with a good knowledge of OO concepts.
- Advanced data analysis skills in Excel. Experience with PowerBI/Powerquery (5 years+), including a knowledge of writing queries directly in the M formula language including optimisation.
- Experience of working with front-office traders in a commodity trading, or financial trading environment.
- Experience building connections to system APIs and consuming data services.
- Excellent communication skills written and verbal.
- Able to reverse engineer and optimise complex spreadsheet logic. Recover corrupted workbooks.
- Ability to organise and manage often concurrent asks on time (urgent, short term, medium term developments)

Desirable Criteria

- Experience working with excel in real time data scenarios.
- Experience with Market Data providers, Reuters, Bloomberg, TT, ICE etc
- Experience any of Visual Studio Tools for Office, Excel DNA, Javascript or other Excel Addin development technologies, MS Access, WPF, Azure Dev Ops
- Experience of Python, Jupyter Notebooks.
- Highly responsible, self-motivated, and able to thrive in an energetic, fast paced, high growth environment. Exhibits ownership of projects and tasks assigned.
- Strong team player with a customer service orientation.
- Financial knowledge – Futures, Swaps, Pricing

Why join us?

At bp, we support our people to grow in a diverse and exciting environment. We believe that our team is strengthened by diversity.

There are many aspects of our employees’ lives that are meaningful, so we offer benefits to enable your work to fit with your life. These benefits can include flexible working options, a generous paid parental leave policy, excellent retirement benefits, among others!

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Travel Requirement

Up to 10% travel should be expected with this role

Relocation Assistance

This role is not eligible for relocation

Remote Type

This position is a hybrid of office/remote working

Legal Disclaimer

We are an equal opportunity employer. We do not discriminate on the basis of protected characteristics like race, religion, color, sex, national origin, sexual orientation, veteran status or disability status.Individuals with an accessibility need may request an adjustment/accommodation related to bp’s recruiting process (e.g., accessing the job application, completing required assessments, participating in telephone screenings or interviews, etc.). If you would like to request an adjustment/accommodation related to the recruitment process,please contact us .

If you are selected for a position and depending upon your role, your employment may be contingent upon adherence to local policy. This may include pre-placement drug screening, medical review of physical fitness for the role, and background checks.