Mid-Level Data Integration Engineer, Valencia

Description of assignment title

Mid-Level Data Integration Engineer

General

Assignment country

Spain

Duty stations

Valencia

Work location

On UN premises

Expected start date

11/30/2026

Duration

12 months
(with possibility of extension)

Sustainable Development Goal

10. Reduced inequalities

Host entity

UNICEF

Modality

Onsite

Type

National

Volunteer category

Specialist UCoS from Apr2026

Work schedule

Full-time

Number of Assignments

1

Details

Mission and objectives

For 70 years, UNICEF has been working on the ground in 190 countries and territories to promote children's survival, protection and development. The world's largest provider of vaccines for developing countries, UNICEF supports child health and nutrition, good water and sanitation, quality basic education for all boys and girls, and the protection of children from violence and exploitation. UNICEF believes that all children have a right to survive, thrive and fulfil their potential – to the benefit of a better world. UNICEF is funded entirely by the voluntary contributions of individuals, businesses, foundations and governments.

Context

With over 150 country offices, UNICEF relies on a consolidated KPI dashboard to monitor performance across global operations. However, this system was built over a decade ago using SQL Server Reporting Services (SSRS). While it has provided a vital baseline for field monitoring, the legacy technology and underlying business logic have become outdated, limiting the organization’s ability to leverage modern, real-time data insights. To address these gaps, UNICEF is transitioning to a more agile reporting ecosystem. This role will focus on modernizing the dashboarding tools and refining the business logic to ensure country offices have the intuitive, high-performance analytics needed for contemporary decision-making. By moving away from static SSRS reports, you will help transform how the organization tracks and scales its impact worldwide.

Task description

Under the direct supervision of Business Intelligence Specialist, the Mid-Level Data Integration Engineer will:

• Pipeline & Solution Engineering: Translate business requirements into cost-efficient, automated data pipelines to achieve high-value analytics outcomes.
• Data Migration & Modernization: Modernize the existing on-premises data platform to a cloud native platform (Databricks).
• Data Warehouse Management & Performance: Monitor and performance tune pipelines in the on-premises Oracle Data Warehouse while coordinating planned weekly releases.
• Observability & Quality Assurance: Implement monitoring and testing protocols to ensure high data quality, health, and reliability across daily warehouse refreshes.
• Data Modelling & Architecture: Design, validate, and maintain logical data models, metadata standards, and data architecture frameworks aligned with business needs.
• CI/CD & Release Management: Manage continuous integration, automated testing, and release deployments to safely introduce schema and pipeline changes into production.
• Troubleshooting & Stakeholder Communication: Promptly diagnose and resolve production data issues, documenting technical/business specs and maintaining active alignment with stakeholders.
• Technical Leadership & Collaboration: Foster cross-team data sharing, enforce engineering standards, present recommendations to diverse audiences, and guide external vendors and consultants.

Eligibility criteria

Age

18 - 80

Required experience

3 years

Nationality

Candidate must be a national, legal resident or hold refugee status in the country of assignment.

Assignment requirements

Relevant experience

3 years

Languages

English, Level: Fluent, Required
Spanish, Level: Working knowledge, Desirable
French, Level: Working knowledge, Desirable
Russian, Level: Working knowledge, Desirable
Chinese, Level: Working knowledge, Desirable

Required education level

Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field; Certifications in Oracle and/or Databricks would be an asset.

Competencies and values

UNICEF’s Core Values of Care, Respect, Integrity, Trust, Accountability and Sustainability (CRITAS) underpin everything we do and how we do it. Get acquainted with Our Values Charter

Skills and experience

Required experience:

• 3+ years of experience in data warehouse and/or lakehouse concepts (e.g., ingestion, collection, processing, storage, querying, visualization) and architecture is required.
• 3+ 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/certified in Databricks or similar cloud-native data platforms
• Experience in LINUX shell scripting (Korn shell, Python, similar scripting languages)
• Practical experience with SAP (ECC, Datasphere)
• Experience with Continuous Integration/Delivery Version Control Systems (TFS, Git)

The following are not compulsory but desirable areas of experience:

• 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
• 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))
• Programming languages and libraries like Python, R, pandas

Required skills:

• Strong analytical and problem-solving skills.
• Creative vision, a passion for learning and willingness to adopt and share new ideas.
• Excellent communication skills (written and verbal) and experience interacting directly with business/technical stakeholders
• Ability to be a self-starter and to work with minimum supervision
• Ability to collaborate with a team in a multi-cultural and gender-sensitive environment
• Ability to coach junior team members in a technical capacity

Area(s) of expertise

Data science, information management, Artificial Intelligence

Driving license

Other information

Volunteerism is understood as a wide range of activities undertaken of free will, for the general public good, for which monetary reward is not the principal motivating factor.

Living conditions and remarks

a) Geographic situation Valencia is the 3rd largest city in Spain, after Madrid and Barcelona. And is located on Spain’s eastern coast, at the mouth of the Turia River, right in the centre of the Gulf of Valencia. It is situated on the shores of the Mediterranean, a stretch of water which has gradually forged the city's character over the centuries. b) Climate, weather and clothing Valencia enjoys a mild temperate Mediterranean climate. The average annual temperature is 17ºC with warm summers and mild winters. The temperature in Valencia rarely falls below 10ºC and there is only light rainfall mainly in autumn and the beginning of spring. c) Other remarks Entry Lum Sum : USD 350 Volunteer Living Allowance : EUR 2986.83 Exit lump sum: $120 for each month served, paid on completion of contract Leave entitlements: Annual leave: 2.5 days accrued per calendar month Certified sick leave: UN Volunteers are entitled to up to 30 days of certified sick leave based on a 12-month cycle. This amount is reset every 12-month cycle. Uncertified sick leave: 7 days for 12 months and 4 days for shorter assignments Learning leave: 10 working days per consecutive 12 months (shorter assignments are prorated) For more details; https://explore.unv.org/sites/default/files/2026-04/Conditions%20of%20Service_EN.pdf

Inclusivity statement

United Nations Volunteers is an equal opportunity programme that welcomes applications from qualified professionals. We are committed to achieving diversity in terms of gender, care protected characteristics. As part of their adherence to the values of UNV, all UN Volunteers commit themselves to combat any form of discrimination, and to promoting respect for human rights and individual dignity, without distinction of a person’s race, sex, gender identity, religion, nationality, ethnic origin, sexual orientation, disability, pregnancy, age, language, social origin or other status.

Reasonable accommodation

UNICEF offers reasonable accommodation for UN Volunteers with disabilities. This may include, for example, accessible software, travel assistance for missions or personal attendants. We encourage you to disclose your disability during your application in case you need reasonable accommodation during the recruitment process and afterwards in your assignment.

Note on Covid-19 vaccination requirements

In addition to duty station-specific vaccine requirements, appointments are subject to confirmation of fully-vaccinated status against SARS-CoV-2 (Covid-19) with a World Health Organization (WHO)-endorsed vaccine, which must be met prior to taking up the appointment. It does not apply to UN Volunteers who will work remotely and are not expected to work on or visit UNICEF premises, programme delivery locations or directly interact with communities UNICEF works with, nor to travel to perform functions for UNICEF for the duration of their contracts.

Scam warning

The United Nations does not charge any application, processing, training, interviewing, testing or other fee in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee, please disregard it. Furthermore, please note that emblems, logos, names and addresses are easily copied and reproduced. Therefore, you are advised to apply particular care when submitting personal information on the web.