Data Engineer

Contract type: Permanent Hours: Full Time, 37.5 hours per week Salary: circa £60,000 depending on experience Location: Canary Wharf WFH policy: Employees are required to attend the office 2 days/week Flexible working: Variety of flexible work patterns subject to line manager discretion e.g. Compressed 9-day fortnight. Reports to: Lead Data Engineer Deadline Note: We reserve the right to close the advert before the advertised deadline if there are a high volume of applications. Role Summary: As the Data Engineer, you will own LCCC’s data ecosystems and will work with developers, solution architects, technical BAs, analysts, data scientists, and other SMEs to define the optimum data platform for the business. You will build the required ETL/ELT pipelines for the ingesting, processing and storing of data and ensure data integrity, accuracy, and reliability throughout the data lifecycle You will have a specific focus on developing the data inputs that are utilised by the organisation’s internal forecasting model of the GB power markets and operations; designing a framework that scales effectively along with the source data. PLEASE NOTE: There will be a short online test sent to you after you apply; this is a key part of the application process and must be completed successfully to move further in the process. Key Responsibilities: Build and maintain ETL/ELT pipelines to make data accurate and easy to use Work to ingest and transform data sets from a variety of data sources including APIs, web scraping, backup databases and third-party services Ensure efficient data synchronisation and flow between various platforms and systems Explore ways to enhance data quality and reliability Assist with the establishment of a data culture across the organisation Drive better data governance through the creation and embedding of principles and processes e.g. Flow Diagram, Data Dictionary, Data Semantic Layers Set service level indicators and monitor execution of data workflows and configure alerts Identify data quality issues through data profiling, analysis and stakeholder engagement Skills Knowledge and Expertise: Essential: At least 2 years of designing data engineering experience to build data platform also support modelling and data analytics Hands on experience within the Azure Data ecosystem, with Azure Databricks, Data Factory, Data Lake, and Synapse. Certifications are a plus. Strong competence in Python, ideally PySpark experience Experience building and maintaining data pipelines Strong experience in SQL and process optimisation, performance tuning, data modelling and SQL/database design skills. Desirable: Experience in data architecture Employee Benefits: As if contributing to and supporting work that makes life better for millions wasn’t rewarding enough, we offer a full range of benefits too. Key benefits that may be available depending on the role include: 25 days' annual leave and bank holidays Recognition schemes allowing colleagues to say thanks Company contribution to your pension scheme Family friendly policies, including enhanced company maternity/paternity and shared parental benefits Employee assistance programme for free, confidential support for your professional or personal life, including financial management and family care Special leave such as study leave, sabbatical or public duties Three days paid leave a year for volunteering to support your local community Season ticket loan scheme to support your commute Access to “Work Perks” offering deals, discounts and cash back on your purchases Family savings on days out and English Heritage or gym discounts through our partners. About Low Carbon Contracts Company The Low Carbon Contracts Company (LCCC) exists to help decarbonise the generation of electricity and make it more affordable for the future. Our work is central to the delivery of the Government’s objective to achieve Net Zero target by 2050. LCCC’s main responsibility, amongst many, is managing the Contracts for Difference (CfDs) scheme which are agreements LCCC has made with renewable generators. These agreements are private law contracts to provide investors with confidence when investing in low carbon technology. CfDs are also designed to help and manage price increases for consumers, when electricity prices are high. LCCC’s other responsibilities include management of money flows across energy suppliers to fund the CfD portfolio, settlement of the capacity market and develop new schemes. Find out more about all that we do by visiting our main page. Please take the time to answer the optional diversity questions At LCCC, we are dedicated to fostering a diverse and inclusive workplace where everyone can be their authentic selves and contribute to our mission of advancing a flexible energy future. Our aim is to be reflective of the environments where we operate and truly benefit from a rich tapestry of backgrounds and experiences where everyone thrives which of course make us stronger together. Your diversity data is valuable to us, it helps us understand whether we are effectively connecting with underrepresented groups and realising our diversity aims. Please note that your diversity data will remain anonymised to us as it only feeds into high-level reports not connected to the candidates