Responsible for managing the C40 Data Warehouse and the Python-based ETL pipelines.
Manage the expansion of the Data Warehouse to include structures for managing data related to the Key Performance Indicators (KPIs).
Responsible for maintaining, analysing and reporting on key datasets (Key KPIs and related data, such as GHG emissions and Air Quality PM2.5) - housed in the Data Warehouse - related to C40 and C40 cities performance measurement.
Develop and maintain data pipelines to extract, transform and load C40 KPI related data from different sources into the central Data Warehouse.
Work alongside climate sector experts to design methodologies to estimate or calculate KPIs and other analyses.
Contribute to the development of data visualisations for KPI and related performance data, primarily for the bespoke C40 Data Portal (internal website with intelligence dashboard) and the KPI Dashboard, and other business intelligence tools such as Qlik, or for internal or external powerpoint presentations or papers.
Work to communicate C40 cities climate and KPI data as widely as possible to ensure that the awareness, uptake and application of the information occurs across C40 staff.
Manage the ‘C40 Data Requests Service’ - respond to data queries from C40 staff, via the online request system across the organisation (e.g. data queries for communications at events such as COP).
Promote good data practices and management, alongside the ‘modelling community’ through enhancing data sharing, methodologies, resources, training and building up staff knowledge and capacity.
Identify opportunities to embed Machine Learning and data imputation in areas of C40 with the Head of Analytics, constantly review efficacy.
Develop an understanding of how statistical inference and hypothesis testing can be used for the benefit of C40’s work areas; e.g. assessing climate change denial, health analysis, equality analysis.
Seek opportunities to acquire research funding and work with external organisations towards setting up joint research opportunities.
Managing workload, conflicting priorities and the expectation of others.

Requirements

Experience of research, analysis and modelling of climate-related data, or relevant sectoral data (e.g. GHG, Air quality, transport, consumption, adaptation).
Experience working with analytic databases (data warehouses and cloud technologies) and GitHub.
Experience and knowledge of using Python and Python data science libraries such as Pandas, NumPy, SciPy, Scikit-learn and SQL Alchemy.
Experience using SQL for querying, developing and managing databases.
Advanced Excel skills including knowledge of formulae, VBS macros and pivot tables.
Knowledge and experience using statistical techniques to analyse data such as hypothesis testing, regression analysis.
Knowledge of, or willingness to learn, geospatial data management using PostgreSQL and Python.
Ability to work in a fast paced organisation and deal and juggle projects.
Ability to work with both technical and non-technical experts with data.
Experience of translating technical information into simple narratives and compelling visuals.
Excellent problem-solving and analytical capabilities.
Strong written skills (e.g. methodology documentation, memos about KPIs to funders and management team).
Strong verbal and presentation skills to communicate data methodologies and present technical results to less technical audiences.

Benefits

Paid Time Off: Full-time employees receive 35 days of paid time off annually, which includes all national holidays.
Company Shutdowns: In addition to the standard paid time off, C40 provides two non-contractual, non-statutory shutdown weeks each year (mid-year and end-of-year) for a full break.
Parental Leave: All employees are eligible for up to 52 weeks of parenting leave. The first 16 weeks are paid at 100% of the employee's current salary. Weeks 17 through 52 are unpaid by C40, unless payment is required by national law.
Flexible Working: C40 supports flexible working arrangements to enhance work-life balance, provided they align with business requirements.
Time off in Lieu (TOIL): Employees can take TOIL to recover following periods of excessive hours or travel.
Sick Leave: Entitlement to sick leave increases upon the successful completion of the employee's probation period.
Employee Training: Training and development opportunities are available to all staff (excluding temporary staff and interns) after they have completed and passed their probation period.
Employee Assistance Programme (EAP): Confidential services, such as counselling, are accessible for short-term support.
Pension scheme : C40 offers a pension scheme to employees in eligible locations. Availability is determined by the country of employment.
Private Health Insurance: This is provided in countries where publicly funded healthcare is not available.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonETLdata analysisdata visualizationSQLExcelstatistical techniquesgeospatial data managementMachine Learninghypothesis testing

Soft Skills

problem-solvinganalytical capabilitiescommunicationproject managementcollaborationpresentation skillsnarrative translationcapacity buildingadaptabilitystakeholder engagement