Senior Cost Forecasting Analyst

Job content

Team: Commercial Finance

Office: Coventry (Flexible Working)

Working Pattern: Full time 37.5 hours per week

Our journey:

At Shell Energy, we believe that home energy matters.

Our home energy business was born out of Shell’s acquisition of First Utility in 2018. As an original challenger to the big energy suppliers, First Utility had a heritage of supplying great value energy and broadband to customers.

Shell Energy supplies 100% renewable electricity, as well as gas, smart home technology and broadband, to British homes.

Our business is growing fast and we want to accelerate this growth further as well as expanding our product range in order to become a multi-product organisation helping customers become carbon neutral.

We have set out to deliver the very best experience to our customers across all contact channels.

Who you’ll work with:

We’re ambitious with a pace to match, and as part of one of the world’s largest companies, the opportunity

and ability to push forward is greater than ever before.

We foster a culture of continuous improvement. Accountability matters, which means enabling transformation through autonomy to influence and see progress through. Every day we work to provide an environment where all employees feel valued and included, and are able to nurture their talent as individuals and as part of a collaborative team.

A diverse and inclusive workplace, embedded in our principles of honesty, integrity and respect, brings together remarkable people and enables them to be themselves. At Shell Energy, you’ll be able to apply and develop your skills and knowledge as part of a collaborative team that’s helping to innovate.

Your part in our journey:

We are looking for a Senior Cost Forecasting Analyst/Cost Forecasting Analyst to join the Pricing & Costing team within Commercial Finance who will be responsible for the energy cost stack ensuring forecasts are produced in an accurate and timely manner. This is a highly critical role as it forms the core foundations for our retail tariffs, business planning and new product/tariff development.

The ideal candidate will preferably have a good understanding of regulatory supply cost charging or a background in the energy industry but this is not essential. The role is highly analytical and will require in depth modelling and statistical analysis of gross margin cost components, financial reporting and database management. It is therefore necessary

that applicants have a strong background in all these disciplines in addition to advanced knowledge of Excel, Python, SQL, Tableau etc.

Your part in the team:

• Develop a deep understanding of energy supply cost charging, keeping up to date with changes in regulatory, network and policy charging methodologies
• Play a pivotal role in the development and maintenance of existing cost forecasting systems, ensuring suitable integration with tariff pricing
• Ensure cost component forecasts are effectively planned and kept up to date
• Continuous evaluation and statistical modelling of risk premia to ensure these remain fit for purpose
• Take the lead on the design, development and implementation of suitable data systems and processes to capture half hourly cost forecasts and tariff prices
• Manage and maintain databases ensuring all information warehoused is effectively cleansed to ensure data integrity and reporting accuracy
• Utilise your knowledge of analytical and statistical methods to develop models to continuously monitor and assess the accuracy of cost forecasts
• Working within Shell Energy’s existing reporting framework, utilise advanced technical knowledge and techniques to develop insights and bespoke financial reporting promoting automation where possible
• Ensure suitable controls and validation procedures are in place for the generation of cost forecasts to reduce financial risk or exposure
• Manage effective relationships with external industry bodies and 3 rd party service providers in additional to a wide range of internal stakeholders
• Experience in delivering high quality data analysis, translating data into true commercial impact within a business with the ability to articulate complex results clearly and concisely to senior stakeholders

What you’ll need to help you make the best of the role:

• Ideally a background in energy supply cost charging
• Advanced knowledge of database management, Excel, Python and SQL
• Strong analytical and problem solving skills
• Broad numerical background with strong experience of complex statistical techniques and modelling
• Experience in complex data visualisation
• Good business acumen and commercial awareness, understanding the importance between strategic and financial requirements
• Highly organised and effective at managing multiple tasks

What’s in it for you

Family Friendly

• Life Assurance 4 x salary
• Pension scheme
• Flexible working
• Company maternity /adoption pay – 26 weeks full pay, followed by 13 weeks’ statutory pay for eligible employees.
• Two weeks’ full paternity pay
• Development opportunities
• Training and coaching
• Development portal to access development material and share experiences
• Mentoring scheme
• Apprenticeship schemes

Lifestyle

• 25 days holiday (plus Bank Holidays)
• Exclusive retail discounts
• Arriva bus discount

Well-being

• Access to Employee Assistance Programme
• Mindfulness sessions
• Trained mental health first aiders
• Charity events to support our charity partner

Environment

• Modern, vibrant offices
• Located in the heart of Milton Keynes /Coventry
• Smart/casual dress