Data Specialist

Junior Data Specialist | Renewable Energy | London (Hybrid) | Up to £50k

With hundreds of millions of pounds in funding, this company will play a critical role in the transition away from fossil fuels. This role offers the opportunity to work closely with industry leaders while helping to build the data systems required for a 100% renewable electricity grid.

Are you a methodical graduate who enjoys the "detective work" behind real-world data? This position goes beyond building pipelines - you'll work hands-on with the complex, messy data that underpins UK energy markets, trading, and grid analytics.

This is a rare opportunity to develop deep expertise in GB balancing market data using a modern data stack (Python, dbt, PostgreSQL, GitHub Actions), with no legacy Excel workflows., As a Junior Data Specialist, you will:

• Perform data detective work: Investigate, map, and clean complex energy datasets - for example, cross-referencing Elexon API data with manual research to correctly link power plants and substations.
• Wrangle real-world data: Reconcile legacy data formats, manage time-series outliers, and resolve inconsistencies across different energy market message types.
• Build and automate: Write Python scripts to ingest data from National Grid ESO and Elexon APIs, using dbt and SQL to implement transformation logic.
• Document critical insights: Maintain reference datasets and clearly document mappings, assumptions, and edge cases that support trading and operational decisions.

• Education: A recent graduate in a quantitative discipline such as Computer Science, Physics, Mathematics, Engineering, or Economics.
• Python skills: Strong foundations in Python, with the ability to write clean, readable code using pandas and numpy.
• Data fundamentals: Comfortable using SQL to query and transform data, with a sharp eye for identifying when data doesn't look right.
• The right mindset: Patient with ambiguity, methodical in approach, and genuinely interested in energy markets or sustainability.

Please note: this is an investigation-heavy role. It's not suited to those who expect perfectly clean datasets or want to focus purely on cloud infrastructure or DevOps. Why Join Us? * Meaningful impact: Work on data that directly influences how the UK power grid is balanced. * Hybrid working: A collaborative environment with regular time in our London office (4 days per week). * Develop rare expertise: Build highly valuable knowledge of the UK's complex energy infrastructure. * Modern data stack: A reproducible, scalable environment built with modern tools and best practices.