We help the best professionals and companies find each other despite borders.
Data Specialist
Location
United Kingdom
Posted
2 days ago
Salary
0
Seniority
Senior
Job Description
Data Specialist
Alex Staff Agency
• We need someone who understands data deeply and uses Python to wrangle it — not a platform engineer, not a pure pipeline builder, but a data specialist who's comfortable with research, investigation, and the unglamorous work of making messy energy market data actually usable. • You'll spend significant time on tasks like: mapping BM units to power plants and fuel types, reconciling legacy data formats with current ones, ensuring consistency between different Elexon message types, and cleaning time-series data (outliers, gaps, overlaps). Some of this requires genuine investigation — cross-referencing sources, making judgment calls, documenting edge cases. There's no API that solves these problems for you. • Python is your primary tool (Pandas, Numpy, standard libraries) to minimise manual effort, but you should be comfortable that some detective work is unavoidable. If you find satisfaction in truly understanding a dataset's structure and quirks — rather than just piping data through and hoping for the best — this role is for you. **Data Mapping and Research** • 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 **Data Reconciliation and Consistency** • 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 **Data Cleaning and Quality** • 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 • Understand why data quality issues occur (settlement reruns, late submissions, format changes) not just patch them **Pipeline Development (Supporting the Above)** • 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
- Nice to Have**
- 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)
- Highly Desirable — Agentic AI Coding Experience**
- We value candidates who can build software using agentic AI coding systems. This is fundamentally different from using code completion tools or chat-based assistants.
- Not What We're Looking For**
- Platform/infrastructure engineers who prefer to stay above the data layer
- People who expect clean, well-documented data as input
- Those uncomfortable with research, ambiguity, or "manual" investigation work
Benefits
- Plenty of opportunities for learning and professional growth
- B2b contract with a paid vacation
Related Guides
Related Categories
Related Job Pages
More General Jobs
• 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.
• 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.
Trainer für Empfangsmitarbeiter, Hotel
WBS TrainingServing the Global Quantitative Finance Community since 2000
• 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
Lead HSS – Clinical Informatics, Clinical Application Coordinator
Aptive ResourcesSolutions That Connect
• 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.
