Alex Staff Agency

Alex Staff Agency

Alex Staff Agency is a prominent player in the international IT recruitment market, providing staffing and recruiting services for large technical companies worldwide. With a team of highly experienced professional recruiters from various countries and...

Professional Services
11-50
Founded 2018

Description

  • Map BM units to power plants, substations, and fuel types using Elexon data, public registers, and manual research.
  • Map substations to ETYS zones and grid supply points.
  • Build and maintain master reference datasets that link identifiers across Elexon, National Grid ESO, TEC register, and other sources.
  • Document mappings, assumptions, and known limitations for downstream users.
  • Reconcile legacy data formats with current schemas and granularities.
  • Investigate and resolve inconsistencies between Elexon message types such as BOALF, BOD, and DISBSAD.
  • Determine authoritative values when data sources conflict or disagree.
  • Clean time-series data by identifying outliers, filling gaps, and resolving overlaps or duplicate timestamps.
  • Develop reusable Python-based data cleaning routines for repeated use across datasets.
  • Write and maintain Python data grabbers, build dbt models, orchestrate workflows with GitHub Actions, and design PostgreSQL schemas.

Requirements

  • Strong Python skills for data work, including pandas and clean, testable, reusable code.
  • Solid SQL skills, including complex queries, window functions, and CTEs in PostgreSQL.
  • Experience with messy, real-world data such as reconciliation, cleaning, or mapping work.
  • Methodical and detail-oriented approach to spotting inconsistencies and root causes.
  • Good documentation habits for mappings, assumptions, and decisions.
  • Self-directed ability to investigate ambiguous problems and communicate findings clearly.
  • Experience with energy, utilities, or market data is a plus.
  • Familiarity with UK energy markets, Elexon data, or grid operations is preferred.
  • dbt experience for transformation pipelines is preferred.
  • Exposure to time-series data issues such as irregular timestamps, gaps, and restatements is preferred.
  • Hands-on experience with at least 2 agentic AI coding systems such as Claude Code, Codex, Open Code, or Cursor.
  • Experience building software end-to-end with agentic coding tools, including multi-agent orchestration, hooks, permissions, MCP servers, custom skills, and context management.

Benefits

  • Remote-first work environment with async collaboration.
  • Core overlap with UK business hours, with at least 4 hours of daily overlap expected.
  • Competitive compensation based on location and experience.
  • B2b contract with paid vacation.
  • Opportunities for learning and professional growth.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Lead Data Analyst

WelbeHealth 251-1K Family Services

WelbeHealth is seeking a Lead Data Analyst to develop and govern operational and clinical metrics, KPIs, and analytical models that improve business performance and healthcare outcomes.

Databricks GitHub Power BI SQL
14 hours, 16 minutes ago

Support Operations Manager, Analytics & Workforce

Tekmetric 51-250 Automotive

Tekmetric is seeking a Support Operations Manager, Analytics & Workforce to lead the measurement, workforce planning, quality, and enablement systems that drive performance across its customer support organization.

SQL
14 hours, 31 minutes ago

Financial & Data Analyst

Pavago IT Services

Our client is seeking a remote Financial Analyst / Data Analyst to support financial planning, operational analysis, and executive reporting for data-driven decision-making.

Looker NetSuite Oracle Power BI Python R SAP SQL Tableau
15 hours, 1 minute ago

Senior Data Analyst, Product

SeatGeek 251-1K Media

SeatGeek is hiring a Senior Data Analyst to support its Product Analytics team in using data to shape product, engineering, design, and marketing decisions for the live events ticketing experience.

Apache Airflow dbt GitLab Looker Mixpanel Python R SQL
1 day, 14 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers