Senior Data Specialist

5 hours, 24 minutes 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

DATA ANALYST II - DIGITAL CREDIT

Inter 51-250 Banks

The Inter is hiring for a Crédit Operations role focused on personal credit analyses and operations within its global financial super app environment.

Power BI Python R SQL Tableau
4 hours, 14 minutes ago

Reporting and Data Analyst (Lead Generation Ads)

lago Professional Services

Lago is seeking a remote LATAM Reporting/Data Analyst to manage dashboards, track performance, and turn marketing data into clear insights for the activation team.

Looker SQL
5 hours, 9 minutes ago

Senior Data Analyst

GlobalDev Tech 51-250 Internet Software & Services

Windward’s Platform R&D Group is seeking an Experienced Data Analyst to support maritime data research and core-data algorithm development for mission-grade ocean intelligence.

Apache Spark AWS Generative AI Grafana Java Matplotlib MongoDB NumPy Pandas Plotly PostgreSQL Python Redash SQL
5 hours, 24 minutes ago

Financial & Data Analyst

Pavago IT Services

A remote Financial Analyst / Data Analyst at a client company will turn financial and operational data into models, reporting, dashboards, and insights that support strategic decision-making.

Looker NetSuite Oracle Power BI Python R SAP SQL Tableau
5 hours, 39 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