Data Modeller

Pertemps Contracts; Remote; GBP 60,000 - 80,000; Full time

Job summary

A local government organization is looking for a Data Modeller to support energy transition planning. This role involves analysing complex datasets, building Excel-based scenario models, and working collaboratively with internal experts. The ideal candidate will have strong analytical skills and advanced Excel proficiency. Although prior energy sector experience is not mandatory, confidence in handling datasets is essential. The position is remote and offers a competitive rate of £360 per day for a temporary duration until March 2026.

Qualifications

• Strong analytical mindset and excellent data manipulation skills.
• Confidence in interpreting datasets and extrapolating future trends.
• Experience in modelling, forecasting, infrastructure planning, or environmental analysis is desirable.

Responsibilities

• Analyse and interpret existing energy system datasets to model future scenarios.
• Build and refine Excel-based scenario models.
• Present scenario outputs clearly through structured tables and data visualisations.

Skills

Advanced Excel skills (modelling, forecasting, scenario building)

Ability to work independently

Strong numerical reasoning

Tools

GIS tools

Job description

Job Title: Data Modeller

Duration: Temporary from January to end of March

Company: Warwickshire County Council

Hours: Monday to Friday - 37 hours per week

Location: Remote

Rate: 360 per day (Inside IR35)

Start Date: January 2026

About the Role

Are you skilled in analysing complex datasets and building clear, meaningful scenario models? Warwickshire County Council is seeking a Data Modeller to support our energy transition planning work. You will play a key role in developing future energy system scenarios that explore the shift from gas to electricity and the potential introduction of hydrogen across the region. Working as part of the Energy and Net Zero team, you will use prepared datasets and a bespoke GIS tool to build approximately four modelled scenarios, helping shape strategic decisions for a more sustainable future. You'll work collaboratively with internal experts for guidance, but you will be comfortable producing high-quality analytical outputs independently.

Key Responsibilities

• Analyse and interpret existing energy system datasets to model future scenarios.
• Build and refine Excel-based scenario models, incorporating varying assumptions and demand patterns.
• Access and review spatial datasets using a bespoke GIS tool (training provided).
• Present scenario outputs clearly through structured tables, data visualisations, and concise written commentary.
• Work alongside internal team members to ensure assumptions and outputs are evidence-based.
• Contribute to delivery of the Stage 5 programme milestone by end of March.

About You

You will have a strong analytical mindset and excellent data manipulation skills, with the ability to interpret datasets and extrapolate future trends. While prior experience in the energy sector is not required, you must be confident in working with complex datasets and building scenario models.

Essential

• Advanced Excel skills (modelling, forecasting, scenario building).
• Ability to work independently and deliver to agreed deadlines.
• Strong numerical reasoning and structured analytical approach.

Desirable

• Familiarity with GIS tools (useful but training can be provided).
• Experience in modelling, forecasting, infrastructure planning, or environmental analysis.

About us and our client

As a flexible employee of Pertemps Recruitment Partnership Ltd, you will be joining one of the UK's largest independent recruitment agencies. Our partnership-based culture is founded on trust, respect, and recognising the value in everyone's strengths. Warwickshire County Council is a forward-thinking and collaborative organisation, working to deliver positive, sustainable outcomes for local communities. You will be joining teams that are:

• High performing
• Collaborative
• Customer focused
• Accountable
• Trustworthy