RemoteLeaf Logo
Log in Sign up

Data Specialist

5 months ago
United Kingdom, Moldova
Full-time
Mid Level
Data Analyst
Data Science and Analytics
dbt GitHub GitHub Actions NumPy Pandas PostgreSQL Python SQL
Apply Now
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
View All Jobs 6

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

CI&T

[Job-31961] Senior Data Engineer (Cloud DB Engineer), Brazil

CI&T 5K-10K Internet Software & Services

A CI&T busca uma pessoa para arquitetar e construir soluções de software e infraestrutura na migração de ambientes on-premises para Azure, conduzindo a aplicação da arquitetura ao código testado e pronto para deployment.

Brazil Full-time Senior Cloud Engineer Database Administrator
Angular AWS Azure CI/CD Confluence JIRA Kanban Microservices Node.js Scrum Spring Boot
3 hours, 20 minutes ago
Launch Potato

Lead Data Analyst, Marketing

Launch Potato 51-250 Professional Services

Launch Potato is seeking a Lead BI Developer to own reporting infrastructure and deliver actionable analytics for its finance and marketplace business verticals.

United States Full-time Lead Data Analyst
$120k-$150k
Affiliate Marketing Power BI SQL Tableau
1 day, 2 hours ago
Launch Potato

Lead Data Analyst, Marketing

Launch Potato 51-250 Professional Services

Launch Potato is hiring a Lead BI Developer to own reporting infrastructure and deliver business-driving insights across its finance and marketplace verticals.

United States Full-time Lead Data Analyst
$120k-$150k
Affiliate Marketing Power BI SQL Tableau
1 day, 2 hours ago
Climate First Bank

Data Analyst

Climate First Bank 51-250 Banks

Climate First Bank is hiring a remote Data Analyst to develop enterprise reporting and workflow automation that improves operational efficiency and supports data-driven decision-making.

United States Full-time Senior Data Analyst
$100k+
Power BI SQL
1 day, 2 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