ICT Officer (Data Integration Engineer), P2, Fixed-term, #43599, ICTD Digital Core - Valencia, Spain
Valencia
- Organization: UNICEF - United Nations Children’s Fund
- Location: Valencia
- Grade: Junior level - P-2, International Professional - Internationally recruited position
-
Occupational Groups:
- Engineering
- Statistics
- Humanitarian Aid and Coordination
- Information Technology and Computer Science
- Closing Date: Closed
We are looking for an ICT Officer (Data Integration Engineer) who will work closely with stakeholders to identify business goals, adopting best practices for data collection and analysis, implementing/upgrading data pipelines, adding value-added insights and monitoring the UNICEF Data Warehouse (UDW) and make data discovery accessible by the users to help the organization achieve their desired outcomes.
UNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence.
At UNICEF, we are committed, passionate, and proud of what we do. Promoting the rights of every child is not just a job – it is a calling.
UNICEF is a place where careers are built: we offer our staff diverse opportunities for personal and professional development that will help them develop a fulfilling career while delivering on a rewarding mission. We pride ourselves on a culture that helps staff thrive, coupled with an attractive compensation and benefits package.
Visit our website to learn more about what we do at UNICEF.
For every child, a digital future
The overarching strategic goal of UNICEF’s Information and Communication Technology Division (ICTD) is to transform and build partnerships with our stakeholders to successfully implement UNICEF programs globally through innovative technology -enabled solutions.
This position will report to the ICT Specialist, P-3, 18679 in the Business Intelligence team in the Solutions Centre and Support in ICTD's Digital Core, Valencia, Spain.
A key perspective of the Centre’s goals is to provide adequate, user-friendly, and modern business solutions to UNICEF’s different departments and stakeholders as well as providing guidance, governance, and procedures to several enterprise processes such as data management, integration, collection, program monitoring, digital tools and platforms, and business process optimization throughout the organization. These goals are aligned with the organizational strategy, enterprise architecture, and information management requirements of UNICEF’s different stakeholders.
The Business Intelligence team is responsible for providing all divisions, regional and country offices a flagship performance management system providing timely and accurate information across the organization via a single point of entry to facilitate, managing for results. Services include provision of analytical insights, dashboards, custom applications, data interoperability with other UN entities and participation in transparency initiatives.
How can you make a difference?
Under the direction of the ICT Specialist, the ICT Officer (Data Integration Engineer) will work closely with stakeholders to identify business goals, adopting best practices for data collection and analysis, implementing/upgrading data pipelines, adding value-added insights and monitoring the UNICEF Data Warehouse (UDW) and make data discovery accessible by the users to help the organization achieve their desired outcomes.
The key responsibilities include:
- contributing and exercising UDW’s data management framework that describes the processes used to plan, specify, enable, create, acquire, maintain, use, archive, retrieve, control, and purge data.
- researching and introducing innovative, data-driven solutions that enable the organization to make strategic decisions for the children of the world.
- developing a collaborative working environment and will maintain effective partnerships with stakeholders, internal and external partners.
This position is based in Valencia Spain and the incumbent is expected to work primarily in Central European Time (Valencia), but with the expectation to occasionally work outside of the core working hours, especially when handling deployments and production environment/application support.
This position may oversee consultants' work.
If you would like to know more about this position, please review the complete Job Description here: JD ICT Officer Data Integration Engineer P2.pdf
To qualify as an advocate for every child you will have…
Minimum requirements:
- Education: A master’s degree in computer science, Information Systems or Mathematics
- Or a First University Degree (bachelor’s degree or equivalent) with 2 years of additional professional experience in lieu.
- Work Experience: Two years practical professional work experience at the national/international level in a non-profit organization or corporate level.
- Experience in data warehouse concepts (e.g., ingestion, collection, processing, storage, querying, visualization) and architecture is required.
- Experience in/certified in Oracle (19c and beyond)
- Strong PL/SQL and/or T-SQL programming skills.
- Advanced knowledge of Oracle database concepts, design, performance tuning, data migration, integration
- Experience in LINUX shell scripting : Korn shell; Python; or other similar scripting languages
- Practical experience with SAP: Business Warehouse (BW) and/or SAP Datasphere Oracle and/or SQL Server.
- Experience with Continuous Integration/Delivery Version Control Systems : Team Foundation Server; Redgate; Git
- Language Requirements: fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) is an asset.
Desirables:
- Work experience at the national/international level in the UN system with exposure to UN corporate reporting, country programming, financial accounting, or related areas would be an advantage.
- Migrating on-premises data warehouse to the cloud
- Experience/certified in Oracle Cloud Infrastructure (OCI) or Microsoft Azure or Microsoft Fabric
- SAP Core Data Service (CDS) on SAP Business Technology Platform (BTP)/Datasphere
- NoSQL, columnar, vector, cloud, graph databases, data lakes, delta lakes.
- ETL tools (e.g., SQL Server Integration Services (SSIS) or Microsoft Azure Data Factory (ADF))
- Architecting for Massively Parallel Processing with Databricks/Apache Spark
- Developing APIs as a data service
- Programming languages and libraries like Python, R, pandas
For every Child, you demonstrate...
UNICEF’s Core Values of Care, Respect, Integrity, Trust and Accountability and Sustainability (CRITAS) underpin everything we do and how we do it. Get acquainted with Our Values Charter: UNICEF Values
The UNICEF competencies required for this post are…
(1) Builds and maintains partnerships
(2) Demonstrates self-awareness and ethical awareness
(3) Drive to achieve results for impact
(4) Innovates and embraces change
(5) Manages ambiguity and complexity
(6) Thinks and acts strategically
(7) Works collaboratively with others
Familiarize yourself with our competency framework and its different levels.
UNICEF is here to serve the world’s most disadvantaged children and our global workforce must reflect the diversity of those children. The UNICEF family is committed to include everyone, irrespective of their race/ethnicity, age, disability, gender identity, sexual orientation, religion, nationality, socio-economic background, or any other personal characteristic.
We offer a wide range of measures to include a more diverse workforce, such as paid parental leave, time off for breastfeeding purposes, and reasonable accommodation for persons with disabilities. UNICEF strongly encourages the use of flexible working arrangements.
Additional benefits for eligible international professional staff members include:
- Paid holidays and leave, including 2.5 days of annual leave accrual per month and 10 official holidays per year
- Paid parental leave (maternity, paternity and adoption)
- Dependency allowance
- Rental subsidy
- Relocation support
- Home leave travel
- Education grant for children in school
- United Nations-sponsored medical and dental insurance plan, pension plan, and optional life insurance plan
- Access to professional development and learning programs, online learning, and learning path
- Access to staff well-being and career development support
UNICEF does not hire candidates who are married to children (persons under 18). UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations and UNICEF, including sexual exploitation and abuse, sexual harassment, abuse of authority, and discrimination. UNICEF is committed to promoting the protection and safeguarding of all children. All selected candidates will undergo rigorous reference and background checks and will be expected to adhere to these standards and principles. Background checks will include the verification of academic credential(s) and employment history. Selected candidates may be required to provide additional information to conduct a background check.
UNICEF appointments are subject to medical clearance. Issuance of a visa by the host country of the duty station is required for IP positions and will be facilitated by UNICEF. Appointments may also be subject to inoculation (vaccination) requirements, including against SARS-CoV-2 (Covid). Should you be selected for a position with UNICEF, you either must be inoculated as required or receive a medical exemption from the relevant department of the UN. Otherwise, the selection will be canceled.
Remarks:
As per Article 101, paragraph 3, of the Charter of the United Nations, the paramount consideration in the employment of the staff is the necessity of securing the highest standards of efficiency, competence, and integrity.
UNICEF’s active commitment to diversity and inclusion is critical to deliver the best results for children. For this position, eligible and suitable female candidates are encouraged to apply.
Government employees who are considered for employment with UNICEF are normally required to resign from their government positions before taking up an assignment with UNICEF. UNICEF reserves the right to withdraw an offer of appointment, without compensation, if a visa or medical clearance is not obtained, or necessary inoculation requirements are not met, within a reasonable period for any reason.
UNICEF does not charge a processing fee at any stage of its recruitment, selection, and hiring processes (i.e., application stage, interview stage, validation stage, or appointment and training). UNICEF will not ask for applicants’ bank account information.
Mobility is a condition of international professional employment with UNICEF and an underlying premise of the international civil service.
All UNICEF positions are advertised, and only shortlisted candidates will be contacted and advance to the next stage of the selection process. An internal candidate performing at the level of the post in the relevant functional area, or an internal/external candidate in the corresponding Talent Group, may be selected, if suitable for the post, without assessment of other candidates.
Additional information about working for UNICEF can be found here.