Exposure Analyst Apprentice

Central London

This vacancy is now closed

Description

Employer description: 

We are a specialty underwriter for exploration and production companies in the oil and gas industry. Our clients are engaged in the exploration for and production of hydrocarbons all over the world, both onshore and in offshore waters.

We work exclusively with brokers who specialize in energy risks. Our underwriting offices in New York, London and Houston write to the same capacity and provide the same specialized products to a worldwide clientele.

Overview:

An apprenticeship role is now available within our Energy Underwriting team. 

You will assist the Underwriters with aggregation and exposure calculations and reporting. You will learn about Catastrophe modelling, aggregation exposure management, gathering and manipulating data to produce reports for the Underwriting team. 

The apprentice will gain an understanding of the practices and exposures within the Offshore, Onshore and Renewable Energy Insurance industry. 

Salary: 

£25,000 per annum. 

Responsibilities:

Energy Underwriting department duties to include:

  • Assisting the Underwriter in completing Upstream and Renewable Energy Underwriting documentation, which will include manipulating and inputting data and then producing reports based on that data.
  • By the end of this apprenticeship, this role will have taken ownership of reports and the data inputted to create them.
  • Develop sufficient understanding and skills to allow data entry to BOUM Aggregation system.
  • Investigate, manipulate and correct large data sets, predominantly within Excel.
  • This role will eventually provide regular reports and analysis to different management or leadership teams.
  • Collect, compile and, if needed, cleanse data etc. solving any problems that arise, to or from a range of internal and external systems.
  • Identify data sources to meet the organisation's requirement, using evidence-based decision making to establish a rationale for inclusion and exclusion of various data sets.
  • Identify, analyse, and interpret trends or patterns in data sets.
  • Support the generation of underwriting reports to the Upstream Energy team.
  • Develop an understanding of Offshore, Onshore and Renewable Energy exploration and production activities and processes.
  • Prepare and provide statistics and information to serve the requirements of the underwriting team.
  • This role will gain experience within Excel, Power BI and several in house systems.
  • Support the Underwriters and Exposure Analyst where necessary.

Desired skills and qualities: 

  • Strong skill set with Microsoft Office suite – in particular Excel, Word.
  • Excel ability - Individual must have good skills in the use of formulas and pivot tables, VBA or Macro ability is a bonus, but not essential.
  • The desire and ability to analyse data sets taking account of different data sets and seek to combine them.
  • Must have an aptitude for math and technology-related tools.
  • Excellent written and verbal communication skills.

As well as:

  • Problem solving skills and attention to detail. 
  • Detail oriented with strong organisational skills. 
  • Ability to work in a team environment, where the success of the team is paramount. 

Entry requirements:

The entry requirements for this programme are as follows:

  • 3 GCSE’s (or equivalent) at grades 4+ (A-C) in any subject 
  • GCSE Maths and English (or equivalents) at grades 3+ (D or above) 
  • Prospective apprentices must not hold an existing qualification at the same or higher level as this apprenticeship in a similar subject 

You may also have a combination of qualifications and experience which demonstrate the minimum foundation needed for the programme. In this instance you could still be considered for the programme. 

If you hold international equivalents of the above qualifications, at the time of your application you must be able to provide an official document that states how your international qualifications compare to the UK qualifications. 

Find out more here: 

https://www.enic.org.uk/Qualifications/UKQRS/Default.aspx

Working week:

  • 9am - 5pm, 5 days a week
  • 35hrs a week

Expected duration:

17 - 20 months.

Future prospects:

Once the apprenticeship has been successfully completed, there will be an opportunity to progress within the company and gain further skills and knowledge.

Important Information: 

QA’s apprenticeships are funded by the Education & Skills Funding Agency (ESFA), an executive agency of the Department for Education.

To be eligible for a Government funded apprenticeship you must have lived in the UK or European Economic Area (EEA) for the last 3 consecutive years.