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 warehousing, enabling 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
Qualifications
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.
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.