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

Senior Customer Insights Analyst

Lone Wolf Technologies 251-1K Internet Software & Services

Senior Customer Insights Analyst at a remote U.S. company on the Customer Operations team, responsible for uncovering and reducing the systemic drivers of customer escalations, cancellations, and retention risk across the customer lifecycle.

CRM Salesforce
38 minutes ago

Data Analyst (AI & Data Platform)

Everbridge 1K-5K Internet Software & Services

Everbridge is hiring a Data Analyst in Bengaluru to turn complex business and operational data into reporting, analytics, and forecasting insights that support data-driven decisions across the organization.

Agile dbt GCP Generative AI Git Looker Power BI Python Snowflake SQL Tableau
3 hours, 11 minutes ago

Senior Customer Insights Analyst

Lone Wolf Technologies 251-1K Internet Software & Services

Senior Customer Insights Analyst at a remote Cambridge, ON operations team, focused on analyzing customer escalations and churn risk to uncover root causes and drive retention improvements.

CRM Salesforce
8 hours, 26 minutes ago

Data Analyst Sr.

Coderio 51-250 Internet Software & Services

Data Analyst Sr. at Coderio for Cencosud Argentina, working within the Data Engineering area to translate business data needs into well-documented, high-integrity solutions on AWS for decision-making across the country’s business units.

AWS Power BI SQL
11 hours, 46 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