Commercial Intelligence Analyst

Aurora Energy Research Limited; Oxford; Hybrid; GBP 30,000 - 45,000; Full time

Job summary

A leading energy analysis firm based in Oxford is seeking a Commercial Intelligence Analyst to produce KPIs and support commercial activities. The ideal candidate will possess strong analytical skills, proficiency in Microsoft Excel, and an interest in energy markets. This role offers comprehensive benefits, hybrid working options, and a collaborative environment for personal development.

Benefits

Private Medical Insurance

Dental Insurance

Parental Support

Salary-Exchange Pension

Employee Assistance Programme (EAP)

Local Oxford Discounts

Cycle-to-work Scheme

Flu Jabs

Qualifications

• Strong analytical mindset and ability to answer unstructured data questions.
• Ability to prioritize and manage own time effectively.
• Enthusiasm for the energy transition.

Responsibilities

• Produce reports regarding Commercial Teams’ KPIs.
• Work with stakeholders to deliver accurate analysis.
• Conduct market research to support the Commercial team.

Skills

Numerical & analytical competence

Experience in analysing and manipulating numerical data

Excellent organisation skills

Outstanding written and verbal communication

Tools

Microsoft Excel

Power BI

Salesforce

Job description

Commercial Intelligence Analyst

Department: Commercial - Commercial Systems & Intelligence

Employment Type: Permanent - Full Time

Location: Oxford, UK

Description

Based in Oxford, you will work in a dynamic multi-national team responsible and will play a key role in collecting, processing and reporting of key data supporting all aspects of our commercial and operational activities.

You would join our commercial team, which is expected to grow and offer potential for progression and personal development, including through international expansion and creating new data and software-based solutions.

This role would be ideal for a candidate at an earlier stage of their career who is looking to develop a skillset in analytics and reporting with a focus on commercial management.

Successful candidates will combine a strong analytical mindset, the ability to answer unstructured data questions, and interpersonal relationship skills with an interest in energy markets and the transition towards a more sustainable world. They will work in a young, dynamic, intellectually stimulating, demanding and collaborative environment.

Key Responsibilities

• Producing existing reporting regarding the Commercial Teams’ KPIs and sales activity, and producing new reporting to provide further analysis, clarity or to increase the efficiency of reporting production
• Work with various stakeholders to produce clear, accurate analysis relevant to their needs
• Provide bespoke analysis of commercial performance for one-off deep analysis
• Administrate and keep various databases and datasets up to date
• Working within the Commercial Systems & Intelligence team to improve administrative and operational processes, and to carry out some of those processes
• Conduct market research and business intelligence to support the Commercial team

What we are looking for

Required attributes:

• A high level of numerical & analytical competence
• Experience in analysing and manipulating numerical data
• An ability to understand unstructured data questions to carry out analysis to provide a suitable answer
• Experience with Microsoft Excel ideally including lookups; pivot tables; sumifs; countifs
• An ability to effectively prioritise and manage your own time and tasks
• Excellent organisation skills and a high degree of persistence and diligence
• A can-do attitude and willingness to help wherever needed e.g. improving internal systems and processes
• Ability to communicate and collaborate with both technically and non-technically minded parties
• Outstanding written and verbal communication as well as interpersonal skills
• Evidence of performing well in team-oriented environments
• Enthusiasm and curiosity about the energy transition

Desirable attributes:

• Experience of producing and managing sales & KPI based reporting
• Experience of using Power BI, Tableau, or other business intelligence tools
• Experience of Salesforce; Microsoft Dynamics CRM or any other CRM platform
• Experience of SQL/SOQL
• Experience of VBA/Macros

What we offer

Some of the benefits we include are:

• Private Medical Insurance
• Dental Insurance
• Parental Support
• Salary-Exchange Pension
• Employee Assistance Programme (EAP)
• Local Oxford Discounts
• Cycle-to-work Scheme
• Flu Jabs

At Aurora, we will consider all requests for flexible working. For most roles, the following types of flexibility are usually possible: a hybrid model of remote and in-office working and flexible start and finish times. Please talk to us during the interview about the flexibility we could offer, and we will be happy to explore the best available option for you.

The Company is committed to the principle that no employee or job applicant shall receive unfavourable treatment on grounds of age, disability, gender reassignment, race, religion or belief, sex, sexual orientation, marriage or civil partnership, pregnancy, and maternity.