Skip to content

Open nowPosted 149 days ago

Data Specialist

Workable (global search)107,990 open roles

Where
England, United Kingdom
Work mode
Remote
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData SpecialistWorkable (global search) · England, United Kingdom
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Workable (global search)'s own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.9% of postings close within 7 days. Measured by our own scanner across the market. Workable (global search) postings stay open a median of 6 days.

Share of postings closed within
  1. 1.6%1 day
  2. 3.6%3 days
  3. 7.9%7 days
  4. 14.9%14 days
  5. 34.0%30 days
This job: posted 149 days ago

Workable (global search) median: 6 days open

The posting

We need someone who understands data deeply and uses Python to wrangle it — not a platform engineer, not a pure pipeline builder, but a data specialist who's comfortable with research, investigation, and the unglamorous work of making messy energy market data actually usable.

You'll spend significant time on tasks like: mapping BM units to power plants and fuel types, reconciling legacy data formats with current ones, ensuring consistency between different Elexon message types, and cleaning time-series data (outliers, gaps, overlaps). Some of this requires genuine investigation — cross-referencing sources, making judgment calls, documenting edge cases. There's no API that solves these problems for you.

Python is your primary tool (Pandas, Numpy, standard libraries) to minimise manual effort, but you should be comfortable that some detective work is unavoidable. If you find satisfaction in truly understanding a dataset's structure and quirks — rather than just piping data through and hoping for the best — this role is for you.

Data Mapping and Research

• Map BM units from Elexon to their corresponding power plants, substations, and fuel types — combining API data, public registers, and manual research

• Map substations to ETYS zones and grid supply points

• Build and maintain reference/master datasets that link identifiers across disparate sources (Elexon, National Grid ESO, TEC register, etc.)

• Document mappings, assumptions, and known limitations clearly for downstream users

Data Reconciliation and Consistency

• Reconcile legacy data formats with current formats (e.g., historical operational data stored in different schemas or granularities)

• Ensure consistency between different Elexon message types — understand the market data structure well enough to know why BOALF, BOD, and DISBSAD might not perfectly align and how to handle it

• Investigate discrepancies between data sources and determine authoritative values

Data Cleaning and Quality

• Clean time-series data: detect outliers (price spikes, meter errors), fill gaps appropriately, resolve overlapping or duplicate timestamps

• Develop reusable Python-based cleaning routines that can be applied across datasets

• Understand why data quality issues occur (settlement reruns, late submissions, format changes) not just patch them

Pipeline Development (Supporting the Above)

• Write and maintain Python data grabbers for energy market APIs

• Build dbt models to transform raw data into clean, analysis-ready datasets

• Orchestrate workflows via GitHub Actions

• Design PostgreSQL schemas that reflect your understanding of the domain

Requirements

• Strong Python skills for data work — you're fluent with pandas, comfortable writing clean, testable code, and can build reusable data processing logic. This is not an Excel role.

• Solid SQL skills — complex queries, window functions, CTEs in PostgreSQL

• Experience with messy, real-world data — you've done reconciliation, cleaning, or mapping work before and understand it's not always automatable

• Methodical and detail-oriented — you notice inconsistencies and want to understand root causes

• Good documentation habits — you know that undocumented mappings and assumptions are technical debt

• Self-directed — you can own ambiguous problems, do your own research, and communicate findings clearly

Nice to Have

• Experience with energy, utilities, or market data (any geography)

• Familiarity with UK energy markets, Elexon data, or grid operations

• dbt experience for transformation pipelines

• Exposure to time-series data challenges (irregular timestamps, gaps, restatements)

Highly Desirable — Agentic AI Coding Experience

We value candidates who can build software using agentic AI coding systems. This is fundamentally

different from using code completion tools or chat-based assistants.

Not What We're Looking For

• Platform/infrastructure engineers who prefer to stay above the data layer

• People who expect clean, well-documented data as input

• Those uncomfortable with research, ambiguity, or "manual" investigation work

Practicalities

• Remote-first with async collaboration (Slack, GitHub, documented decisions)

• Core overlap with UK business hours expected (at least 4 hours daily)

• Competitive compensation based on location and experience

Benefits

  • Plenty of opportunities for learning and professional growth
  • B2b contract with a paid vacation
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Workable (global search)'s own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Workable (global search)'s form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Workable (global search)'s answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.