View Our Website View All Jobs

Data Architect

This role was posted on August 8, 2021. Please note that we will review applications on a rolling basis and prioritize those received within the two weeks of posting. 

The Role

At Last Mile Health (LMH), we dig data. Are you able to build and maintain complex databases that ensure the integrity and accessibility of large volumes of data in support of public health programs?  If so, you could be the Monitoring, Evaluation, Research, and Learning (MERL) team’s Data Architect.

As Last Mile Health’s (LMH) mission evolves and expands into more countries in Africa, its data storage, collection, and reporting needs have been evolving and expanding as well. To accommodate this evolution and expansion, LMH is in the process of designing and developing a next generation data warehouse and portal based on best in class solutions for data collection, storage, and reporting.  The Data Architect will be responsible for leading in the design and development of the next generation data warehouse and portal. 

This position is open to candidates located in Liberia, Malawi, Uganda, or on the Eastern seaboard of the United States (Boston or NYC preferred). Candidates must have work authorization in one of the countries listed above. 

What You'll Do

  • Develop a plan for the design and development of the next generation data portal and the migration of data and code logic from the current one.
  • Gather and review requirements from stakeholders (e.g. LMH staff, partner organizations, Ministries of Health) for the next generation of Last Mile Data, LMH’s data portal.
  • Research and recommend off-the-shelf data integration, data storage, business intelligence (BI), and content management system (CMS) software and cloud solutions.
  • Research and prototype off-the-shelf Monitoring & Evaluation vendor data management and reporting tools.
  • Mentor junior IT staff in the development of the next generation data portal and migration from current data portal.
  • MERL subject matter expert on ODK Collect/Central apps for surveys and evaluations, QGIS mapping, and DHIS2.
  • Support Data Engineer in the ongoing administration, maintenance, and development of the current data portal.
  • Develop and administer a production instance of MySQL on a Linux server running at scale, storing over 1.5 million permanent and unique records.

What You'll Bring

  • Bachelor’s degree, preferably in computer or information science, but mathematics, statistics, or other relevant scientific discipline is fine.
  • 7+ years of experience in the development of complicated software and database systems.
  • The ability to design a complicated data warehouse system and understand deeply each of its functional components and how they interact with one another.
  • The ability to project manage the technical development of a complicated software and database system through all of its phases: planning, design, development, testing, release, and ongoing support.
  • Expertise in SQL programming and developing normalized and dimensional data models. 
  • The ability to program in at least one scripting language, such as Python or PHP.
  • Experience developing dashboards and data visualizations using any BI tool, such as Tableau, PowerBI, Google Data Studio, or Periscope.
  • Experience developing data pipelines using data integration or ETL tools.
  • Strong Microsoft Office skills, especially Excel
  • Excellent written and verbal and communication skills, including the ability to communicate across cultural settings and with non-technologists

You’ll Impress Us If

  • You have worked in healthcare, public health, or social justice organizations.
  • You have experience developing and deploying technological solutions for internet-limited settings.

Compensation Information

At Last Mile Health, we strive to reward our employees equitably and transparently. This means that we pay our employees based on a clear and consistent methodology and without regard to identity or personal relationships. We have made this model fully transparent, so that everyone has access to all information related to compensation. We hope this helps you better understand Last Mile Health’s values and commitments to our employees. We look forward to answering any questions you may have during the hiring process. 

Before applying to this role, please take a moment to learn more about our approach to compensation and how compensation works in each of the countries where we operate. Please find the link to our compensation model and benefits overview below: 

OVERVIEW OF LAST MILE HEALTH’S COMPENSATION MODEL

Compensation for this position: 

The Band for this position: SLB-5

For all countries, the salary range is: $85,000 - $118,000 dependent upon experience doing an equivalent role

About Last Mile Health 

Last Mile Health partners with governments to design, scale, strengthen, and sustain high-quality community health systems, which empower teams of community and frontline health workers to bring life-saving primary healthcare to the world’s most remote communities. LMH is a registered 501(c)3 non-profit organization with offices in Liberia, Malawi, and Boston. For more information, visit www.lastmilehealth.org.

We are an equal opportunity employer and value diversity at LMH. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Read More

Apply for this position

Required*
Apply with
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity