PMA2020: Agile Data Engineer

Classified Title: Sr. Programmer Analyst
Requisition ID #: 665
Range: PD
Level: 4
Salary: $57,544-$79,047
Status: Full Time
School: Bloomberg School of Public Health
Location: School of Public Health
Location City: Baltimore
Location State: MD
Resume Required for Application: Yes
Area of Interest: Technical

To apply, please visit the JHU Careers website.


General Description

Performance Monitoring and Accountability 2020 (PMA2020) uses innovative mobile technology to routinely gather and rapidly turnaround, cost-effective population data on family planning, water, sanitation and hygiene. The project is led by the Bill and Melinda Gates Institute for Population Health at the Johns Hopkins Bloomberg School of Public Health, Department of Population, Family and Reproductive Health and is implemented by local university and research organizations in Africa and Asia. Household and health facility surveys are conducted by a cadre of female resident enumerators trained in mobile-assisted data collection.

Countries include: Ghana, Ethiopia, Uganda, Kenya, DR Congo, Burkina Faso, Nigeria, India (Rajasthan), Indonesia, Niger, and Cote d’Ivoire.

An expansion project, PMA Agile is a three-year project to build a monitoring and evaluation platform for large-scale projects that will enable near-continuous tracking of performance and progress toward the projects’ intended results. PMA Agile will build the capacity for and promote the use of programmatically-relevant M&E data at national and subnational levels by local governments, research institutions and implementing partners to support evidence-based decision making. The project will do this by creating a flexible, user-friendly dashboard with relevant family planning data from surveys, integrated HMIS data, and linked project records with meaningful and interpretable measurement views at different levels: the reporting health facility, the local government, the in-country implementing partner, the sponsoring donors, and the Gates Institute and PMA Agile team. The PMA Agile approach will, at a minimum, track change at the health system level, through quarterly (moving to monthly) public and private health facility audits (called Agile surveys) and periodically through collection of data from households/females on exposure to project interventions (e.g., brand awareness, participation in special outreach activities, media exposure).

Position Description

PMA Agile is seeking a Data Engineer who will collect, store, and process multiple datasets across the public health domain, particularly related to family planning. These data will include survey data, HMIS data, and project records. The primary focus will be on choosing optimal solutions to integrate data and related systems and produce dashboards. He / She will also create, maintain, and monitor data infrastructure and related systems, as well as automate processes.

Primary duties and responsibilities

  • Extract, Transform, Load (ETL) relevant data. Data cleaning. Integrate multiple data sources. Server deployment. Problem diagnosis and resolution. Routine database administration activities such as configuration, maintenance, user management, and security. Develop and maintain systemic solutions for data collection activities across multiple streams, such as web, mobile app, and SMS based forms of data collection.
  • Assist in or take ownership of creation of and updates to data models. Assist in or take ownership of development and maintenance of data infrastructure, including connections between databases, business intelligence systems, and custom applications through use of various Application Programming Interfaces (APIs). Assist in or take ownership of automation solutions along the data pipeline, from data collection to visualization. Assist in or take ownership of documentation and automated testing.
  • Training of local counterparts in partner countries. Specific technologies used will include DHIS2 for visualization, as well as ODK and Stata for data extraction.

Qualifications

  • Bachelor's degree.
  • Three years related experience.
  • Additional experience can substitute for education. Additional education can substitute for experience.

JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

Preferred Qualifications

  • Master’s degree in Computer Science.
  • Experience working in the field of public health or with data systems in low and middle-income countries is preferable as is the ability to speak and write technical/scientific French.
  • Knowledge of or experience with, Java, NoSQL, SOA, ORM, web scraping, devops, cloud hosting, Linux server administration.
  • Data visualization proficiency in any language/library, geographic information systems (GIS), business intelligence platforms, advanced Excel skills (e.g. complex formulas, VBA macros).
  • Strong critical thinking skills and analytical reasoning skills.
  • Excellent, clear and concise verbal and written communication skills.
  • Able to converse fluently with technical and non-technical people.
  • Experience with basic programming (Python preferred).
  • Proficient in Microsoft Excel, data transformation and cleaning, relational database management systems (RDBMS) (e.g. PostgreSQL), and SQL.
  • Proficient with terminal/command line programming and version control (e.g. Git).
  • Has conceptual understanding of web application architecture, object-oriented programming (OOP), and REpresentational State Transfer (REST).