Pan American Health Organization
PAHO Consultant - Database Engineer Consultant for Geospatial Immunization Data Integration and Management
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
OBJECTIVE OF THE OFFICE/DEPARTMENT
This is a requisition for employment at the Pan American Health Organization (PAHO)/Regional Office of the World Health Organization (WHO)
Contractual Agreement: Non-Staff - International PAHO Consultant
Job Posting: August 28, 2026
Closing Date: September 7, 2026, 11:59 PM Eastern Time
Primary Location: Off Site
Organization: EIH Evidence and Intelligence for Action in Health
Schedule: Full time
PURPOSE OF CONSULTANCY
Organization: Department of Evidence and Intelligence for Action in Health (EIH) and PAHO technical teams for immunization, health analysis, information systems, and digital transformation.
Background
The Pan American Health Organization (PAHO) supports countries of the Region of the Americas in strengthening immunization systems, epidemiological surveillance, health information systems, and evidence-informed planning of interventions aimed at populations with limited access to health services.
The project seeks to identify where children who have not received the first dose of measles vaccine are concentrated (zero-dose children for measles). This information will serve as the basis for developing a cloud-based solution for geospatial microplanning of vaccination campaigns, enabling the integration of vaccination coverage, population, administrative boundaries, health facilities, access barriers, and campaign operational data.
A reliable database layer is critical for this type of solution. The platform will depend on structured, traceable, versioned, and quality-controlled data to generate maps, indicators, prioritization lists, microplanning inputs, and monitoring outputs. The solution must be able to ingest heterogeneous datasets from multiple sources, harmonize geographic and administrative identifiers, preserve data lineage, and provide performant data products to backend services and user interfaces.
To advance this component, PAHO requires a consultant specialized in database engineering, geospatial databases, data integration, and data quality. The consultant will design and implement the database structures and data management processes needed to support the identification of zero-dose measles vaccination gaps and to operationalize geospatial microplanning for vaccination campaigns.
Purpose Design, implement, document, and validate the database and data management layer for a cloud-based geospatial microplanning solution aimed at identifying and prioritizing areas where children are missing the first dose of measles vaccine.
Ensure that the database component is secure, scalable, interoperable, geospatially enabled, and prepared to support subsequent backend services, analytical workflows, and user-facing applications for vaccination campaign planning and monitoring.
DESCRIPTION OF DUTIES:
Responsibilities
The consultant will be responsible for planning, developing, documenting, and validating the database engineering components through the following activities:
- Data requirements, source inventory, and technical planning
- Review project objectives, expected analytical outputs, and microplanning use cases with PAHO technical teams and designated counterparts.
- Identify, document, and classify expected data sources, including vaccination coverage, target populations, administrative boundaries, health facilities, campaign operations, and geospatial reference layers.
- Assess known data quality, completeness, interoperability, coding, geocoding, and update-frequency issues relevant to the database component.
- Develop a database engineering work plan aligned with the broader cloud, backend, and user experience workstreams.
- Database architecture and geospatial data model design
- Define the conceptual, logical, and implementation data model for the solution, including core entities, relationships, indicators, metadata, and spatial references.
- Design normalized and analytical structures to support ingestion, transformation, quality control, geospatial analysis, and microplanning outputs.
- Specify the use of relational and geospatial database technologies, such as PostgreSQL/PostGIS or equivalent cloud-compatible services, according to institutional requirements.
- Prepare source-to-target mappings, naming conventions, data dictionaries, coding standards, and versioning rules.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
- Database implementation and environment configuration
- Implement development database schemas, staging areas, reference tables, geospatial layers, roles, permissions, spatial indexes, and baseline configuration scripts.
- Coordinate with the cloud backend architect to ensure compatibility with the cloud deployment model, security architecture, and API layer.
- Document assumptions, dependencies, limitations, and operational risks affecting the database environment.
- Data ingestion, transformation, and quality assurance pipelines
- Develop or specify reproducible ETL/ELT routines for loading, cleaning, transforming, validating, and publishing priority datasets.
- Implement quality checks for missing values, duplicate records, geographic inconsistencies, administrative-code mismatches, temporal inconsistencies, and indicator calculation errors.
- Create exception logs, validation summaries, and data lineage records that allow PAHO teams to trace how final indicators and outputs were produced.
- Support secure handling of sensitive or restricted data through appropriate access controls, minimization principles, and documentation.
These activities are essential to establish a reliable, interoperable, and well-documented database foundation for the geospatial microplanning solution, enabling subsequent development of tools to identify vaccination gaps and plan targeted measles vaccination interventions.
Consultant profile
The consultancy requires a database engineer or data engineer with specialization in relational and geospatial databases, data modeling, ETL/ELT processes, data quality assurance, and cloud-compatible database implementation for analytical and operational applications.
The consultant should demonstrate the capacity to work with multidisciplinary teams, translate public health and geospatial requirements into database structures, and produce technical documentation suitable for software engineers, data analysts, and institutional stakeholders.
Languages: Advanced Spanish or English; working knowledge of the other language will be considered an advantage.
Education: Minimum bachelor’s degree for the lower end of the band; advanced university degree for the mid or upper range of Band B, in computer science, information systems, data engineering, software engineering, geomatics, public health informatics, or related fields.
Minimum experience: At least seven (7) years of professional experience in database engineering, data engineering, data architecture, or related technical roles, preferably supporting public health, geospatial analysis, immunization, epidemiological surveillance, or digital health projects.
Demonstrated experience designing and implementing relational and geospatial databases for analytical or operational systems, including data modeling, schema implementation, query optimization, and data lifecycle management.
Experience developing data integration workflows from heterogeneous sources and creating technical documentation such as data dictionaries, source-to-target mappings, runbooks, and database diagrams.
Experience working in multidisciplinary environments and translating analytical, public health, or geospatial requirements into production-ready data structures and documentation.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Skills:
- Relational database design and implementation, including normalization, indexing, access control, and performance tuning.
- Advanced SQL and experience with PostgreSQL/PostGIS or equivalent geospatial database technologies.
- ETL/ELT development, data ingestion, data validation, data lineage, and reproducible data processing workflows.
- Geospatial data management, administrative boundary harmonization, spatial joins, geocoding support, and map-ready data products.
- Cloud-compatible database deployment, backup/restore planning, migration scripts, and environment documentation.
- Data governance, privacy, role-based access, auditability, and secure handling of sensitive health or operational data.
- Collaboration with backend developers, UX designers, data analysts, public health specialists, and country counterparts.
Technical coordination and supervision
Under the supervision of the Advisor in Data Science from the Health Analysis team of the Department of Evidence and Intelligence for Action in Health, will supervise the consultant. The consultant will coordinate with immunization, information systems, geospatial analysis, data, information security, cloud/backend, and UX/web design focal points designated by PAHO.
Contract value
Depending on deliverables, daily rates can vary from US $258 to US $314.
Duration: September 9, 2026 - December 31, 2026
Contract type: PAHO International Consultant - Non-staff Position (Band B)
Band level: Band B: services related to projects or technical tasks of moderate complexity or specialization; require specialized qualifications.
Main location: Remote work (off-site), with regular virtual meetings and coordination with PAHO teams and national counterparts.
Scheduled weekly hours: Up to 40 hours, according to the work plan and deliverables schedule.
ADDITIONAL INFORMATION
This vacancy notice may be used to identify candidates for other similar consultancies at the same level.
Successful candidates will be placed on the roster and subsequently may be selected for consultancy assignments falling in this area of work or for similar requirements/tasks/deliverables. Inclusion in the Roster does not guarantee selection for a consultant contract. There is no commitment on either side.
Only candidates under serious consideration will be contacted.
All applicants are required to complete an on-line profile to be considered for this consultancy. For assessment of your application, please ensure that your profile in the PAHO Career page is updated; all experience records are entered with elaboration on tasks performed at the time. Kindly note that CV/PHFs inserted via LinkedIn are no accessible.
A written test may be used as a form of screening.
If your candidature is retained for interview, you will be required to provide, in advance, a scanned copy of the degree(s)/diploma(s)/certificate(s) required for this position. PAHO/WHO only considers higher educational qualifications obtained from an institution accredited/recognized in the World Higher Education Database (WHED), a list updated by the International Association of Universities (IAU)/United Nations Educational, Scientific and Cultural Organization (UNESCO). The list can be accessed through the link: http://www.whed.net/. PAHO will also use the databases of the Council for Higher Education Accreditation http://www.chea.org/search/default.asp and College Navigator, found on the website of the National Centre for Educational Statistics, https://nces.ed.gov/collegenavigator to support the validation process. Some professional certificates may not appear in the WHED and will require individual review.
Any appointment/extension
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location