AlexStaff Agency is hiring a Data Specialist for an international leader in energy storage and grid-stability technologies. You will handle complex energy market data, ensuring its quality and readiness for analysis.
What You'll Do
- Map BM units, substations, and fuel types across Elexon, National Grid, and other sources; maintain master datasets.
- Document mappings, assumptions, and known limitations clearly for downstream users.
- Reconcile legacy and current data formats to ensure consistency between Elexon message types.
- Investigate discrepancies between data sources to determine authoritative values.
- Clean time-series data: detect outliers, fill gaps, resolve duplicates, and understand root causes of quality issues.
- Develop reusable Python-based cleaning routines and data grabbers for APIs.
- Build dbt models and design PostgreSQL schemas for clean, analysis-ready datasets.
- Orchestrate workflows using GitHub Actions.
What We're Looking For
- 3+ years of experience as a Data Engineer.
- Strong Python programming skills, especially for API data ingestion and ETL.
- Advanced SQL and data modeling experience with PostgreSQL.
- Experience working with messy, real-world data.
- English proficiency at a B2+ level.
Nice to Have
- Experience in energy, utilities, or market data.
- Familiarity with UK energy markets, Elexon data, or grid operations.
- dbt experience for transformation pipelines.
- Exposure to time-series data challenges like irregular timestamps, gaps, and restatements.
Technical Stack
- Python
- PostgreSQL
- dbt
- GitHub Actions
Team & Environment
You will be part of the company's core team.
Benefits & Compensation
- Competitive salary according to your experience and skills.
- Official employment according to the UK Labor Law.
- Paid vacation.
- Plenty of opportunities for learning and professional growth.
- Starting next year, everyone will be issued Macs with tracking software.
Work Mode
This role offers a hybrid work arrangement with team locations in London, Dubai, and India.
AlexStaff Agency is an equal opportunity employer.
