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).
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.
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.
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 inMicrosoft 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).
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130... years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Baltimore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.