Data Specialist

3 hours, 39 minutes ago
Full-time
Mid Level
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 API data, public registers, and manual research.
  • Map substations to ETYS zones and grid supply points.
  • Build and maintain reference and master datasets linking identifiers across Elexon, National Grid ESO, the 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.
  • Identify authoritative values when data sources disagree and explain the reasoning behind decisions.
  • Clean time-series data by detecting outliers, filling gaps, and resolving overlapping 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 fluency with pandas and the ability to write 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 with the ability to identify inconsistencies and investigate root causes.
  • Strong documentation habits and an understanding that undocumented mappings and assumptions create technical debt.
  • Ability to work independently, own ambiguous problems, conduct research, and communicate findings clearly.
  • Experience with energy, utilities, or market data, preferably in any geography.
  • Familiarity with UK energy markets, Elexon data, or grid operations.
  • dbt experience for transformation pipelines.
  • Exposure to time-series data challenges such as irregular timestamps, gaps, and restatements.
  • Experience building software using agentic AI coding systems is highly desirable.

Benefits

  • Remote-first working 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 arrangement.
  • Paid vacation.
  • Opportunities for learning and professional growth.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Director, Marketing Automation & Attribution

ShipBob 251-1K Air Freight & Logistics

ShipBob is hiring a Marketing Automation and Attribution leader to own lifecycle execution, reporting reliability, and lead management across its B2B GTM systems.

HubSpot Salesforce
45 minutes ago

Data Analyst, Risk

Binance 5K-10K Capital Markets

Binance is hiring a Data Analyst in its Risk team to analyze large-scale user data, build tagging and profiling systems, and support personalized services and risk control decisions across global markets.

Blockchain Feature Engineering Machine Learning Power BI Python SQL Tableau
2 hours, 15 minutes ago

Credit Risk Senior Analyst

Marqeta 251-1K Diversified Financial Services

Marqeta is hiring a Credit Risk Senior Analyst to lead underwriting strategy and portfolio risk management for consumer and SMB credit card programs across internal teams and external banking partners.

Machine Learning Python R SQL
2 hours, 39 minutes ago

Senior Billing Strategy Analyst

Natera 1K-5K Pharmaceuticals

Natera is hiring a Senior Billing Strategy Analyst to support cross-functional finance, billing, market access, product, clinical, and marketing teams by analyzing billing performance, improving processes, and guiding operational decisions.

HIPAA Power BI SQL Tableau
2 hours, 54 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