Data Engineer at BBC Media Action
BBC Media Action
Published 1 month ago · Expires 4 weeks from now
Job description
Job Purpose
BBC Media Action's Nigeria office is seeking a Data Engineer to lead the design and initial implementation of a consolidated database system. This role will bring together monitoring data across two projects and build a real-time data management dashboard for the Changing the Script project.
This is a six-month full-time position with subsequent part-time work required after the initial phase. The focus is on designing and implementing a unified database system with robust structure, clear labelling, standardised schemas, and accurate metadata to enable reliable reporting, analytics, and insight generation.
Key Requirements
- Expertise in ETL pipelines and near real-time data handling
- Experience with large-scale data processing and social listening workflows
- Proficiency with PostgreSQL or Azure SQL
- Strong Python programming skills
Main Duties and Responsibilities
- Design, build, and maintain central databases and data warehouses using PostgreSQL or Azure SQL, optimised for indexing, querying, and scalability
- Develop and manage ETL pipelines using Python to ingest, clean, transform, and harmonise data from surveys, outreach, digital analytics, social listening, and partner submissions
- Process near real-time and large-scale datasets efficiently while ensuring data integrity and performance
- Build and maintain well-labelled, standardised schemas with clear metadata
- Collaborate with the Research and Data Manager, partner organisations, and cross-country technical support teams (digital and research) to ensure the database meets operational and reporting needs
Reporting Structure
This position reports to the Head of Research and Learning, Nigeria, with a dotted line to the Project Director, and is accountable for all project deliverables.
Location
Lagos, Nigeria