Business Analyst

Specialist Recruit
09 May 2017
08 Jun 2017
Contract Type
Full Time


To provide asset value quotations to third parties for the purchase of gas and electricity networks based upon the rate of return. The role is heavily focused on data analysis and the candidate will be required to understand complex formulas and carry out reporting within the team.

This role would suit an individual with a strong analytical ability combined with a high attention to detail and the ability to spot errors and anomalies.

Key responsibilities

  • Liaise with industry partners to obtain all the required information need to model Asset Value (AV) quotations for new gas and electricity networks
  • Use the information obtained in one of a number of financial models in order to produce an Asset Value Quotation for the industry partners, based on a pre-set IRR or Payback
  • Use Market Intelligence to maximise IRRs in conjunction with Strategic Pricing Manager, AV team and the Development Director
  • Handle queries around Asset Values and ESP’s asset adoption processes
  • Make changes and improvements to the data models, ideally using both advanced Excel functions and VBA
  • Ensure that data stored in gas and electricity databases is kept up to date, including accepting new sites and altering/cancelling won sites
  • Oversee the sending and receiving of monthly Schedule 8s (contracts) - an addendum to ESP’s UIP/ICP Asset Adoption Agreement
  • Oversee the sending and receiving of monthly developer and metering contracts
  • Liaise with AV Claims department to ensure that all Schedule 8s are returned before an AV for a site is paid
  • Produce report/analysis for management team as and when they need it
  • Providing analytical support to the rest of the team on spreadsheet/database issues
  • Support the Infill team, modeling projects based on multiple contractor quotes for existing housing schemes, as and when they come in
  • Regulatory and fund reporting where required

Skills required:

To fulfill the role described above the position requires the following key skills:

  • Excellent data manipulation & analysis skills
  • Advanced Excel skills including functions (more than just "sum", "average" etc, more "countif", "averageif", "vlookup" etc)
  • Basic Access/database skills
  • Ability to use own initiative
  • Logical / analytical thinker
  • Excellent attention to detail
  • Excellent problem solving
  • Excellent communication skills