Senior Data Specialist

1 month, 1 week ago
Full-time
Senior
Data Science and Analytics
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

Insights Manager II

instacart.careers 1K-5K Internet Software & Services

Instacart is hiring an Insights Manager II for its Retail Insights team to turn grocery retail data and partner trends into clear analysis, business cases, and strategies that support key retail partnerships.

E-commerce SQL
6 hours, 13 minutes ago

COLLECTION ANALYST II

Inter 51-250 Banks

Inter is hiring for its Credit Recovery Policies team to develop and implement data-driven recovery strategies that improve collections results in a global financial super app environment.

Python R SQL Tableau
6 hours, 13 minutes ago

Measurement Lead

Brandtech+ 501-1000 Marketing services

Brandtech+ is hiring a remote Measurement Lead to shape reporting, data governance, and performance measurement across global client accounts and internal teams.

Power BI Tableau
6 hours, 28 minutes ago

Senior Data Analyst

Forge 251-1K Capital Markets

Forge is hiring a Senior Data Analyst to join its Analytics team and partner across the business to turn data into insights that shape marketplace strategy, product decisions, and growth.

Looker Python Segment Snowflake SQL Tableau
6 hours, 28 minutes 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