Senior Data Specialist

Job not on LinkedIn

🔥 13 hours ago

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Alex Staff Agency

WebsiteLinkedInAll Job Openings

11 - 50 employees

🎯 Recruiter

🤝 B2B

Recruitment • B2B

Alex Staff Agency is a recruitment agency specializing in connecting IT professionals with companies around the globe. The agency offers a variety of services including career counseling for candidates, helping them find job opportunities in countries they love, and assisting employers in hiring skilled talent. With over 20 years of experience in the field, Alex Staff Agency has built a broad network across more than 150 markets, facilitating successful relocations and onboarding for numerous candidates. The agency prides itself on supporting candidates throughout the hiring process and beyond, offering guidance and expertise every step of the way.

📋 Description

• Map BM units from Elexon to their corresponding power plants, substations, and fuel types — combining API data, public registers, and manual research • Map substations to ETYS zones and grid supply points • Build and maintain reference/master datasets that link identifiers across disparate sources (Elexon, National Grid ESO, TEC register, etc.) • Document mappings, assumptions, and known limitations clearly for downstream users • Reconcile legacy data formats with current formats (e.g., historical operational data stored in different schemas or granularities) • Ensure consistency between different Elexon message types — understand the market data structure well enough to know why BOALF, BOD, and DISBSAD might not perfectly align and how to handle it • Investigate discrepancies between data sources and determine authoritative values • Clean time-series data: detect outliers (price spikes, meter errors), fill gaps appropriately, resolve overlapping or duplicate timestamps • Develop reusable Python-based cleaning routines that can be applied across datasets • Write and maintain Python data grabbers for energy market APIs • Build dbt models to transform raw data into clean, analysis-ready datasets • Orchestrate workflows via GitHub Actions • Design PostgreSQL schemas that reflect your understanding of the domain

🎯 Requirements

• **Strong Python skills for data work** — you're fluent with pandas, comfortable writing clean, testable code, and can build reusable data processing logic. This is not an Excel role. • **Solid SQL skills** — complex queries, window functions, CTEs in PostgreSQL • **Experience with messy, real-world data** — you've done reconciliation, cleaning, or mapping work before and understand it's not always automatable • **Methodical and detail-oriented** — you notice inconsistencies and want to understand root causes • **Good documentation habits** — you know that undocumented mappings and assumptions are technical debt • **Self-directed** — you can own ambiguous problems, do your own research, and communicate findings clearly • **Experience with energy, utilities, or market data (any geography)** • **Familiarity with UK energy markets, Elexon data, or grid operations** • **dbt experience for transformation pipelines** • **Exposure to time-series data challenges (irregular timestamps, gaps, restatements)**

🏖️ Benefits

• Plenty of opportunities for learning and professional growth • B2b contract with a paid vacation