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.

Benefits Information

As LMH strives to increase transparency into our compensation principles we are highlighting below more details around our compensation policy and benefits associated with this position. In line with our compensation principles, this position will pay at the 50th to 60th percentile of the market to which you are employed. We look forward to answering any questions you may have during the hiring process. 

Compensation range: $85,000 - $118,000 dependent upon experience doing an equivalent role

You can read about our competitivebenefits offerings here.

Principles guiding our compensation policy:

• Data Driven: We benchmark salaries against large datasets containing compensation data from organizations with whom we compete for talent. We benchmark salaries for specific roles and specific candidate experience.
• Competitive: Candidates should be paid the most competitive salaries possible for their position given budgetary constraints. We aim to pay above market, typically between the 50th-60th percentile of the market.
• Transparent: Compensation policies should be transparent and easily understood. We want all candidates to understand how we set salaries and to know we aim to pay competitively.
• Equitable: Compensation should be implemented consistently across candidates of different identities, teams, and geographies, while keeping into account the different talent markets and economies we operate in.
• Responsible: LMH needs to operate in a sustainable way and practice good stewardship of our resources.

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.