Data Warehouse Engineer

  • Partners in Health
  • Boston, MA
  • Dec 07, 2021
Full time Database Information Systems Systems Engineer Technology

Job Description

Position Title: Data Warehouse Engineer

Reports to: Associate Director of Strategic Information and Systems

Location: Boston (20% travel to PIH global care delivery sites)

 

Position Overview

The Data Warehouse Engineer is an experienced developer of system integrations, data pipelines and data warehousingenabling expanded and improved data access and use, data governance, and enhancing Partners In Health (PIH) teams’ ability to make data-driven decisions. 

 

The Data Warehouse Engineer will partner with clinical, operational, and business teams across the organization to design and develop solutions to support data warehouse and business intelligence initiatives. This work may include developing data architecture, programs and procedures using standard data architecture methods (e.g. star schema and snowflake data models), SQL and ETL development tools, modern database technologies, and supporting analytics and report dashboard development.  The position requires strong data management, problem-solving, integrations, business system, time management and documentation skills.

 

Responsibilities

 

  • Partner with business and data analysts to design, develop and maintain data pipelines, data governance compliance, procedures, and tooling to support local and global data warehousing.
  • Gather and identify system requirements through collaboration with clinical, data analysts, information systems, business systems, and other stakeholders across multiple administrative and clinical locations globally.
  • Lead the design of data warehouse schemas and data architecture to ensure system scalability, performance, data integrity and ease of use. 
  • Develop and maintain ETL programs for disparate systems both on premise and in the cloud.
  • Participate in designing system data models, data integrations and automated data management solutions.
  • Lead the design of data sharing and integrations between systems for improved cross-functional reporting and insights.
  • Collaborate with technical stakeholders to determine best practices and implementation of non-functional requirements such as exception/error handling, performance optimization and code management.
  • Use various SQL tools or scripts to monitor data quality, identify issues and implement solutions.
  • Support subject matter experts in their development of reporting and analytics 
  • Maintain parallel training and documentation activities to help build global data management capacity

 

 

 

Qualifications

  • Bachelor’s degree or equivalent experience in Computer Science, Business IntelligenceData Science, Information Technology
  • 3-5 years of experience with proven data warehousingdata management, system integrations and analytics skills
  • Experience with multiple data warehousing tools and technologies (star schema, snowflake data models), modern database technologies, and technologies for stream and batch data processing
  • Experience gathering requirements and understanding the needs of diverse stakeholders
  • Advanced proficiency with SQL 
  • Experience with analytics and programming languages such as Python, JAVA, R, and STATA
  • Experience with Power BI, Jet Reports desirable
  • Proven ability to learn new systems, processes and problem solve
  • Data Analytics experience working in low-resource settings
  • Advanced Excel skills
  • Attention to detail
  • Exemplary interpersonal skills; ability to collaborate effectively with culturally diverse staff across departments and countries
  • Cover Letter and Resume required


Please note that we are not able to sponsor work authorization for this position.

 

Organizational Profile

 Partners In Health (PIH) is a non-profit, global health organization that fights social injustice by bringing the benefits of modern medical science first and foremost to the most vulnerable communities around the world. PIH focuses on those who would not otherwise have access to quality health care. PIH partners with the world’s leading academic institutions to create rigorous evidence that shapes more sound and all-inclusive global health policies. PIH also supports local governments’ efforts to build capacity and strengthen national health systems. 

 As of today, PIH runs programs in 11 countries (Haiti, Peru, Rwanda, Mexico, Sierra Leone, Liberia, Malawi, Lesotho, Russia, Kazakhstan, Navajo Nation), where it provides direct care to millions of patients, through public facilities and community engagement.

 Partners In Health (PIH) is committed to the fundamental principle of equal opportunity and equal treatment for every prospective and current employee. It is the policy of PIH not to discriminate on the basis of race, color, national or ethnic origin, ancestry, age, religion, creed, disability, sex and gender, sexual orientation, gender identity and/or expression, military or veteran status, or any other characteristic protected under applicable federal, state or local law.  PIH works in and with a number of governments in and outside the U.S., and to the extent applicable, this statement is intended to incorporate the prohibition of any unlawful discrimination covered by applicable laws in such countries, states and municipalities. 

 

This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.