Data Specialist

About the role

We are looking for a Data Specialist who can dive deep into messy energy market data, using Python to clean, map, and reconcile information. This role is research‑heavy and requires a strong investigative mindset to turn raw datasets into reliable, analysis‑ready resources.

Key responsibilities

• Map BM units to power plants, substations and fuel types by combining API data, public registers and manual research.
• Reconcile legacy data formats with current schemas and ensure consistency across different Elexon message types.
• Clean time‑series data by detecting outliers, filling gaps, and resolving overlapping timestamps.
• Develop reusable Python cleaning routines and maintain dbt models for transformation pipelines.
• Write and maintain Python data grabbers for energy market APIs and design PostgreSQL schemas that reflect domain knowledge.

Required profile

• Methodical and detail‑oriented with strong documentation habits.
• Self‑directed, able to own ambiguous problems and communicate findings clearly.
• Experience working with messy, real‑world data and performing reconciliation and mapping tasks.

Required skills

• Python (pandas, numpy, standard libraries)
• SQL (PostgreSQL, complex queries, window functions, CTEs)
• dbt for data transformation
• GitHub Actions for workflow orchestration
• Agentic AI coding experience (highly desirable)

What we offer

• Remote‑first work environment with async collaboration.
• Competitive compensation based on location and experience.
• Plenty of opportunities for learning and professional growth.
• B2B contract with paid vacation.