Data Specialist

4 months, 1 week 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

HubSpot 5K-10K Media

HubSpot is seeking a Lead Data Analyst to guide AMER Upmarket sales strategy and operations through rigorous measurement, complex modeling, and data-driven decisions that accelerate scalable growth.

Looker SQL Tableau
21 hours, 8 minutes ago

Healthcare Claims - Senior Data Analyst

Pharmaceutical Strategies Group, an EPIC Company, is hiring a remote Senior Data Analyst to advance the Artemetrx healthcare analytics platform by analyzing claims data and developing scalable models that improve drug cost management and client decisions.

HIPAA Machine Learning NLP Python R SQL
21 hours, 53 minutes ago

Compensation & People Analytics Analyst

Quantum Health 1K-5K Professional Services

Quantum Health is seeking a Compensation & People Analytics Analyst to support compensation administration, incentive calculations, and workforce reporting through analytics, automation, and process improvement.

Power BI SQL
21 hours, 53 minutes ago

Insights Analyst

Quantum Health 1K-5K Professional Services

Quantum Health is seeking an Insights Analyst to transform complex healthcare data into actionable insights supporting strategic decisions, product development, and improved member experiences; the role is remote across the U.S. or hybrid in Dublin, Ohio.

Generative AI HIPAA Machine Learning Power BI Python R SQL Tableau
21 hours, 53 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