Data Specialist

1 month, 3 weeks 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

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, 15 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, 30 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 ago

Senior PHP Engineer with strong DB experience

Intetics 1K-5K Internet Software & Services

Intetics Inc. is seeking a Senior PHP Engineer to develop, maintain, and enhance web applications for a cybersecurity-focused client and its risk-based vulnerability management platform.

Agile AWS Cybersecurity Linux PHP Scrum SQL
15 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