Alex Staff Agency logo
Alex Staff Agency

We help the best professionals and companies find each other despite borders.

Senior Data Specialist

Location

United Kingdom

Posted

2 days ago

Salary

0

Seniority

Senior

Bachelor DegreeEnglishPandasPostgreSQLPythonSQL

Job Description

Senior Data Specialist

Alex Staff Agency

• 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

Job 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

Related Categories

Related Job Pages

More General Jobs

Full TimeRemoteTeam 10,001+H1B Sponsor

• Lead field crews in performing battery storage system work safely, efficiently, and in accordance with CES’s code of conduct. • Perform and support installations, commissioning, troubleshooting, and repairs of battery energy storage systems. • Conduct system checks, collect data, and adjust settings on computerized equipment. • Follow standard operating procedures and supervisor direction; stop and seek clarification anytime a task appears unsafe. • Adhere to all lockout/tagout procedures. • Prepare detailed documentation—including photos—on all work performed, issues encountered, parts used, suspected root causes, and site conditions. • Foster a culture where every team member feels empowered to stop work when the sequence or conditions are unclear or unsafe. • Perform quality assurance inspections on newly onboarded BESS sites. • Support continuous improvement initiatives and help identify opportunities where CES can elevate its quality and efficiency. • Maintain excellent housekeeping standards at all times. • Perform other duties as assigned.

United States
Full TimeRemoteTeam 10,001+H1B Sponsor

• Promote a strong safety culture by participating in toolbox talks, behavioral observations, and adherence to all safety standards and best practices. • Perform routine maintenance, troubleshooting, and repair on mechanical and electrical solar plant components. • Review system data and adjust settings on computerized/monitoring equipment at solar facilities. • Follow standard operating procedures and supervisor direction; stop and seek clarification anytime a task appears unsafe. • Adhere to all lockout/tagout procedures and never interfere with another worker’s lockout/tagout device. • Prepare detailed work order documentation—including photos—covering work performed, challenges encountered, parts used, suspected root causes, and site conditions. • Documentation is completed through daily reports and other CES project management tools. • Foster a stop-work culture where all team members feel empowered to halt work if they are uncomfortable with the task or sequence of operations. • Perform quality assurance inspections on newly onboarded solar sites and prepare reports identifying deviations from design drawings, electrical codes, or industry best practices. • Maintain excellent housekeeping standards at all times. • Perform other duties as assigned.

United States
WBS Training logo

Trainer für Empfangsmitarbeiter, Hotel

WBS Training

Serving the Global Quantitative Finance Community since 2000

General2 days ago
Full TimeRemoteTeam 1-10Since 2000H1B No Sponsor

• Als Honorartrainer:in der WBS TRAINING vertrittst du dein Fachgebiet mit Leidenschaft und Weitblick • In deiner Rolle als Trainer:in steht das Ziel der Kompetenzentwicklung der Kursteilnehmenden im Vordergrund • Du verstehst dich in deiner Unterrichtsgestaltung sowohl als Inputgeber:in als auch als Unterstützung in der Rolle einer Lernbegleiter:in Lernen 4.0! • Dazu gehört: fachbezogener Unterricht aus dem Homeoffice im WBS LearnSpace 3D® • Anwendung verschiedener Lehrmethoden für die Unterrichtsgestaltung • Anleitung von Aufgaben und Tätigkeiten am Empfang und Rezeption in der Hotellerie beispielhaft näher zu bringen • Vorbereitung und Gestaltung unterrichtsbezogener Lernmaterialien nach Curriculum • Durchführung von Kompetenzzuwachsmessungen

Germany
Full TimeRemoteTeam 501-1,000Since 2012H1B No Sponsor

• Lead clinical informatics support for VA facilities transitioning from VistA/CPRS to Oracle Health/Cerner, including planning, readiness, cutover, and post-transition support activities. • Supervise, coordinate, and mentor Health Informatics Specialists, Clinical Application Coordinators, and other clinical informatics SMEs. • Support CPRS Transition Plan activities, readiness tracking, field support requests, issue resolution, and clinical applications configuration guidance. • Provide expert VistA/CPRS support for Clinical Reminders, order menus, notifications, consults, notes, alerts, templates, reports, and related clinical applications. • Perform program and data analysis using VistA FileMan, VSSC, Pyramid Analytics, BISL reports, Excel, Power BI, or similar tools to inform operational recommendations. • Engage VAMC informatics staff, VA program offices, EHRM teams, OIT stakeholders, and Government leads through meetings, office hours, presentations, and direct support. • Develop and review SOPs, operational guides, training materials, scorecards, dashboards, request logs, FAQs, SharePoint resources, and other field-facing artifacts. • Identify risks to clinical operations, data migration, readiness, and user adoption; recommend practical mitigation strategies.

Virginia