Senior Data Specialist - Energy Market Data
New
A
Alex Staff AgencyEnergy, Utilities
England, United Kingdom. Georgia. Armenia. Cyprus. Montenegro. Hungary, Core overlap with UK business hours expected (at least 4 hours daily)ContractSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PostgreSQLPythonSQLNumpyPandasdbtGitHub Actions
Requirements
- Strong Python skills (pandas, clean/testable code, reusable data processing logic)
- Solid SQL skills (complex queries, window functions, CTEs in PostgreSQL)
- Experience with messy, real-world data (reconciliation, cleaning, mapping)
- Methodical and detail-oriented approach
- Good documentation habits
- Self-directed in owning ambiguous problems, research, and clear communication
- Experience with energy, utilities, or market data (any geography) (Nice to Have)
- Familiarity with UK energy markets, Elexon data, or grid operations (Nice to Have)
- dbt experience for transformation pipelines (Nice to Have)
- Exposure to time-series data challenges (irregular timestamps, gaps, restatements) (Nice to Have)
- Hands-on experience with agentic AI coding systems (Claude Code, Codex, Open Code, Cursor)
- Proficiency with at least 2 agentic systems
- Ability to design and build software end-to-end using agentic systems
- Demonstrated experience orchestrating multiple agents using skills, tools, and coordination
- Deep system knowledge of agentic tools (hooks, permission systems, MCP servers, custom skills/tool definitions, context management)
Responsibilities
- Understand data deeply and use Python to wrangle messy energy market data
- Map BM units to power plants 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 linking identifiers across disparate sources
- Document mappings, assumptions, and known limitations clearly
- Reconcile legacy data formats with current ones
- Ensure consistency between different Elexon message types and handle discrepancies
- Investigate discrepancies between data sources and determine authoritative values
- Clean time-series data: detect outliers, fill gaps, resolve overlapping/duplicate timestamps
- Develop reusable Python-based cleaning routines
- 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 domain understanding
View Full Description & ApplyYou'll be redirected to the employer's site
