Database Specialist/Data Engineer Consultant for the Migration Unit

Post of Duty: Belize

The IDB Group is a community of diverse, versatile, and passionate people who come together on a journey to improve lives in Latin America and the Caribbean. Our people find purpose and do what they love in an inclusive, collaborative, agile, and rewarding environment.

About this position

Belize has received the most significant foreign population in relation to its population, accounting for 15 percent of the total or 55,000 (UN 2019; IOM 2021). In general, migrants are looking to improve their social and employment opportunities. In Belize, migrants work in many sectors of the economy, and many operate small and micro businesses, contributing to economic activity and employment. However, compared to native families, migrant families are socioeconomically disadvantaged, and their education levels are lower (IDB 2020). This translates into significant integration challenges for migrant families in the country.

The Bank has been supporting the Government of Belize through investment loans, grants, and technical assistance in different sectors, one of which has been the digital transformation process of the Immigration Department of the Ministry of Foreign Affairs, Foreign Trade and Immigration (MFA). In accordance, the IDB is looking to continue supporting the digital transformation of the Immigration Department, and it is looking to contract an individual database specialist/data engineer to support this digitalization. In particular, the MFA seeks to create an analytical data warehouse to suit its analytical, reporting, and business intelligence needs. An ETL (Extract-Transform-Load) infrastructure must also be implemented to aggregate and transform data from various existing databases and then feed it in the appropriate structure and format into the data warehouse.

You will work in the Migration Unit (MIG) part of the Social Sector (SCL). The team's mission is to support migration-receiving countries, countries of destination, and migration in transit and the host communities through lending operations; regional, sub-regional, and national dialogues; regional cooperation to generate public goods; capacity building and training; and applied research.

Objectives: This consultancy aims to build a data warehouse for the MFA to be used as the main data source for dashboard, stats, and reporting in the MFA. This effort will be done with the leadership of the MFA technical team.

What you’ll do:

i. Process analysis:

Conduct a thorough examination of the services, operations, and processes within the Ministry.

Conduct a comprehensive analysis of existing data sources and data models, developing a complete mapping of sources and dataflow charts.

ii. Requirements gathering and analysis:

Collaborate with stakeholders from the MFA, particularly the IT team, to understand business objectives and gather system requirements.

Translate business needs into clear and concise functional specifications for development teams.

iii. Data Warehouse Design and Architecture:

Design a data warehouse architecture that aligns with the Ministry’s needs and supports efficient data storage and retrieval.

Define data models, dimensional schemas, and data structures for the data warehouse.

iv. ETL Pipeline Development:

Design and develop the ETL process to extract, transform, and load data from the Ministry’s transactional databases into the data warehouse.

Ensure data quality and integrity during the ETL process.

v. Data Integration and Transformation:

Participate in project planning and estimation, providing technical expertise and contributing to project timelines.

Monitor project progress, identify potential risks, and take necessary measures to ensure success.

vi. Testing and Quality Assurance:

Conduct thorough data warehouse and ETL pipeline testing to ensure accuracy and reliability.

Collaborate with stakeholders to validate data and ensure it meets business requirements.

vii. Documentation:

Maintain detailed documentation of data warehouse design, ETL processes, and system configurations.

Deliverables and Payments Timeline:

Deliverable #

Percentage

Planned Date to Submit

Data Warehouse Design and Architecture Document

25%

06-14-2024

ETL Pipeline Implementation Report

25%

12-12-2024

Data Integration and Transformation Report

25%

04-08-2025

Testing and Validation Reports

25%

05-02-2025

What you'll need:

Education: Master's or bachelor’s in computer science, information Systems, or other fields relevant to the role's responsibilities.

Experience: At least five years of progressive experience in database management, data engineering, data warehousing, or related fields.

Languages: Proficiency in English.

Key skills:

Learn continuously.

Collaborate and share knowledge.

Focus on clients.

Communicate and influence.

Innovate and try new things.

Requirements:

Citizenship: You are either a citizen of Belize or a citizen of one of our 48 member countries with residency or legal permit to work in Belize.

Consanguinity: You have no family members (up to the fourth degree of consanguinity and second degree of affinity, including spouse) working at the IDB, IDB Invest, or IDB Lab.

Type of contract and duration:

Type of contract: Products and External Services Consultant (PEC), Lump Sum.

Length of contract: 12 months.

Our culture

At the IDB Group, we work so everyone brings their best and authentic selves to work, willing to try new approaches without fear, and where they are accountable and rewarded for their actions.

Diversity, Equity, Inclusion, and Belonging (DEIB) are at the center of our organization. We celebrate all dimensions of diversity and encourage women, LGBTQ+ people, persons with disabilities, Afro-descendants, and Indigenous people to apply.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job interview process. If you are a qualified candidate with a disability, please e-mail us at to request reasonable accommodation to complete this application.

Our Human Resources Team reviews carefully every application.

About the IDB Group

The IDB Group, composed of the Inter-American Development Bank (IDB), IDB Invest, and the IDB Lab offers flexible financing solutions to its member countries to finance economic and social development through lending and grants to public and private entities in Latin America and the Caribbean.

About IDB

We work to improve lives in Latin America and the Caribbean. Through financial and technical support for countries working to reduce poverty and inequality, we help improve health and education and advance infrastructure. Our aim is to achieve development in a sustainable, climate-friendly way. With a history dating back to 1959, today we are the leading source of development financing for Latin America and the Caribbean. We provide loans, grants, and technical assistance; and we conduct extensive research. We maintain a strong commitment to achieving measurable results and the highest standards of integrity, transparency, and accountability.

Follow us:

Schedule: