Company logo

Inspired

BPI Analyst

Remote·Fully Remote·2w ago

Salary

Competitive salary

Work type

Remote

Level

mid

Category

Analytics & BI

About the role

Inspired is a market leading, technology-enabled provider of energy and sustainability solutions in the UK - supporting businesses to transition to net zero carbon and manage their response to climate change.

Established in 2000, we became the first publicly quoted advisor following a successful AIM debut in 2011. We are now the UK’s number one destination for businesses seeking expert insight and advisory services to help them manage their energy costs, reduce their carbon emissions and prove their net zero carbon and ESG strategies to their investors and customers.

We are looking for a BPI Analyst to join our successful ESG Team. This is a home based role with occasional travel to our Kirkham (Lancashire) office required.

The ESG/BPI Analyst is responsible for the technical integrity of our ESG reporting infrastructure and managing report uploads and downloads from the CRM. This role is split between taking full ownership of complex Excel based ESG reporting frameworks, utilising VBA and advanced formulas for ESG reporting, and providing comprehensive administration and support for the department's CRM system.

The responsibilities will include but not be limited to:

Technical Responsibilities:

  • Manage Excel-based energy/ESG reporting templates.
  • Utilise advanced Excel formulas and VBA to automate, maintain, and improve templates.
  • Conduct rigorous testing and debugging of templates.
  • Maintain version history for all reporting frameworks.
  • Provide support to peers on data solutions.
  • Manage data upload and report download within the CRM.

Soft Responsibilities:

  • Professional and confident manner.
  • Exceptional attention to detail and ability to meet tight deadlines.
  • Problem solving and analytical thinking.
  • Project management skills.
  • Effective face-to-face communicator with good telephone and written skills.
  • Ability to work on their own initiative with a good ‘Teamwork’ ethic.
  • Ability to meet deadlines and prioritise activities.
  • Good presentation skills.
  • Ability to analyse reports and develop recommendations.
  • Prepare clear and succinct reports and correspondence.
  • Be able to work with colleagues, customers, suppliers and the public in general.
  • Advanced technical proficiency in Excel, including VBA and complex formulas.
  • Read and comply with the company Health & Safety Policy; taking reasonable care for the Health & Safety of themselves and others; co-operate with managers and other employees in fulfilling our objectives and statutory duties.

Qualifications and Education Requirements

Essential:

  • Advanced technical proficiency in Excel, including VBA and complex formulas.
  • Proficient with Microsoft Office packages
  • Maths and English proficiency
  • Advanced Excel proficiency, including VBA and macro development
  • Proficient with SQL to write queries that fetch data from CRM
  • Proven experience in debugging and testing complex data templates
  • Power Automate
  • Microsoft Forms

Desirable:

  • Familiarity with GHG Protocol
  • Energy Industry experience
  • Experience with CRM Systems
  • Power BI

What we offer

  • Training and development opportunities
  • Company pension
  • Life insurance
  • Enhanced maternity and paternity
  • Benefits portal, with a wide range of benefits
  • 4pm finish on Friday

Tech stack

ExcelVBACRMSQLGHG ProtocolPower BIGCP