• Duration: Permanent

• Salary: £52,000 per annum

• Job Level: Level 3

• Hours: 35 hours per week. Other flexible arrangements will be considered.

• Disclosure Level: Basic. This role involves no direct or indirect work with children.

• Reports to: Head of Data and Analytics

• Location: Working from home and at 1 Westfield Avenue, London E20 1HZ

At the UK Committee for UNICEF (UNICEF UK), we pull together to achieve the best possible results for children in danger around the world.  We believe in an inclusive workplace and in the power of fulfilled colleagues who share the same values and goals, enjoy their work and are motivated to do their utmost for children. 

Our work is guided by the UN Convention of the Rights of the Child (UNCRC) and the Sustainable Development Goals (SDGs), which recognise the universality of children’s rights.

ABOUT THE TEAM

The Information and Technology directorate aims to connect, protect and empower our organisation, people and stakeholders to deliver for children. The Data and Analytics Team ensures the availability and usability of quality business data and analytics to deepen insights into our audiences and performance through integration and automation of data processing and analytics activities and by empowering our colleagues through data self-service.

ABOUT THE ROLE

The Data Engineer is responsible for the build and maintenance of UNICEF UK’s Enterprise Data Platform, including data ingestion pipelines and data models. Working closely with colleagues in the Information Team, as well as with colleagues across the organisation, the Data Engineer will create and implement data solutions, so that data is accessible, accurate and up-to-date and processes are automated to ensure that the value of data is realised across UNICEF UK.

What we will expect you to achieve

• An Enterprise Data Platform that provides robust and clean data quickly, securely, ethically and reliably, including ingestion pipelines and relevant data models that meet business requirements for new data sources, insights and reports, with appropriate documentation.

• The successful management and maintenance of data over its full lifecycle, from the point it is extracted from the source systems, through transformation and presentation of the data to business end users in reporting, insights, and selections. This will include, but is not limited to, such activities as data management, data migration, data ingestion, data transformation, data storage, data quality, data access and security, as well as timely troubleshooting and resolution of data issues when they are reported.

• ⁠A data environment that is fit for purpose, including optimisation of the Enterprise Data Platform, so it runs quickly, efficiently, reliably, and recommending and delivering improvements that are fully tested.  All applicable architecture principles are expected to be applied.

• An Enterprise Data Platform whose performance is monitored and maintained, and has the necessary backup and recovery procedures in place.

• Data engineering best practices implemented, including automation and alerting, reducing key person dependencies, mitigating risks, and accelerating the resolution of data issues.

• Processes and tools that are continually improved and aligned to business requirements, from product evaluation and selection, through to design, testing, and implementation.

• Advice and input into relevant data governance documentation, and policies and procedures that govern UNICEF UK data estate and data architecture, and successful implementation into the Enterprise Data Platform appropriately.

• Thorough end-to-end testing of new and updated processes affecting the Enterprise Data Platform and selected source systems in both directions with relevant scenarios that are fully documented and communicated.

• Demonstrate and model a commitment to our shared values, behaviours and inclusive practices (known as Our Shared Commitment) in all aspects of your work.

BEHAVIOURS, EXPERIENCE AND SKILLS

This section contains the essential behaviours, experience, knowledge and skills needed in order to be effective and successful in this role. All criteria in this section are essential.

Effective behaviours

Supporter driven and mission aligned

• Is committed to children and their rights and motivated to work towards achieving a world that is fit for every child.

Information and Data

• Protects our reputation when working with confidential data and information and mitigates risk through considering the legal, regulatory, ethical and privacy issues.

Analytical

• Analyses available information to make logical and sound judgments, with strong attention detail.

Collaboration and communication

• Consults others and shares expertise, know-how and ideas with colleagues for best results.

• Conveys complex ideas using a variety of methods to engage a diverse audience and win understanding and support.

Efficiency and Effectiveness  

• Systematically plans projects to maximise performance and cost-effectiveness.

• Demonstrates ability to work accurately under time pressure, manage deadlines and multiple priorities.

Relevant experience

• Experience of developing data integration solutions, managing complex data migrations, and of code development to ensure that data is integrated appropriately across and within systems.

• Knowledge and experience of enterprise data warehousing and data integration.

• Understanding of relational database structures, principles and practices. 

• Experience of working with datasets in a complex operational environment.

Specific knowledge and skills

• Database Administration background and experienced SQL developer.

• Application of Enterprise Integration Platform as a Service (eiPaaS) (or similar data integration technologies) including developed understanding of Application Programming Interfaces (APIs) and native platform connectors to data integration solutions.