Specialist Data Analyst / Data Analyst

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. Write Python scripts to ingest data from National Grid ESO and Elexon APIs, using dbt and SQL to implement transformation logic. 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. It's not suited to those who expect perfectly clean datasets or want to focus purely on cloud infrastructure or DevOps. 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