Loading job details...
Mid-Level Data Integration Engineer
Job ID:TL;DR Summary FREE
Generating summary...
{{ summary.tldr }}
Key Requirements
- {{ r }}
Key Skills
{{ s }}
Deal Breakers
- {{ d }}
{{ summary.experience_level }}
{{ summary.salary_hints }}
Job Description
## Mid-Level Data Integration Engineer
- Organization:UNICEF - United Nations Children's Fund
- Office:UNICEF in Valencia, Spain
Description of assignment title:Mid-Level Data Integration Engineer
Assignment country:Spain
Duty stations:Valencia
Work location:On UN premises
Expected start date:11/30/2026
Duration:12 months(with possibility of extension)Long-term benefits and allowances
Sustainable Development Goal:10. Reduced inequalities
Volunteer category:Specialist UCoS from Apr2026
Work schedule:Full-time
Number of Assignments:1DetailsMission 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 criteriaAge:18 - 80Required experience:3 yearsNationality:Candidate must be a national, legal resident or hold refugee status in the country of assignment.Assignment requirementsRelevant experience:3 yearsLanguages:English, Level: Fluent, RequiredSpanish, Level: Working knowledge, DesirableFrench, Level: Working knowledge, DesirableRussian, Level: Working knowledge, DesirableChinese, Level: Working knowledge, DesirableRequired 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:https://www.unicef.org/careers/get-prepared#ValuesSkills 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, pandasRequired 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 capacityArea(s) of expertise:Data science, information management, Artificial IntelligenceDriving license:-Other information
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.
- 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.
- Under the direct supervision of Business Intelligence Specialist, the Mid-Level Data Integration En
Additional Information
👀 people viewed this job
🔥 Applications surging — 3x more views than average
Ready for this role?
Tailor your resume to this job before you apply. Applications with a matched resume get noticed.
Customize Your Resume for This Role Sign up free · 25 credits to start Practise the interview for this job Timed questions on this vacancy · sign up and try your first question
UN agencies often ask for a P11 form.
Generate yours from your resume
Views
Posted
Applicants
AI Tools
Prepare your application with AI. Each tool uses credits from your balance.
Prepare with AI
Sign up free to get a tailored resume, cover letter, and interview prep for this role.
Sign Up Free — 75 CreditsNo credit card required
📊 Estimated Applicant Pool