Data Engineer

Base Pay Range

$/yr - $/yr

The Data Engineer will play a crucial role in advancing the CDC Foundation's mission by designing, building, and maintaining modern data infrastructure for the Northwest Portland Area Indian Health Board (NPAIHB) Data Hub project. Working closely with the Data Hub Team, the Data Engineer will support the architecture needed for data storage, processing, analysis, and secure transfer to Tribal Leaders and public health professionals.

The Data Engineer will collaborate with epidemiologists, data content experts, IT staff, the Data Hub Project Director, and others to develop and implement scalable solutions that align with the objectives of the NPAIHB’s Data Hub project.

NPAIHB’s Data Hub Team is currently developing a system, "The NW Tribal Data Hub," to provide comprehensive, user-friendly public health data dashboards for its 43 member Tribes. The Data Engineer will ensure the successful design and implementation of a newly created public health database, the ingestion of additional data into the system, and create tables, views, and other database structures to support epidemiological analysis, visualization, and reporting to Tribes.

The data, sourced primarily from state and federal agencies, include vital statistics (births, deaths), cancer registries, emergency department, clinical service data, and others. The Data Engineer's work will be pivotal in enhancing the capacity of Tribal public health departments to conduct data-driven activities, advancing Tribal data sovereignty, and empowering Tribes to improve health outcomes within their communities.

The Data Engineer will be hired by the CDC Foundation and assigned to the Data Hub Team s position is eligible for a fully remote work arrangement for U.S. based candidates.

NPAIHB is a tribally owned and operated non-profit organization serving the 43 federally recognized Tribes in the states of Idaho, Oregon, and Washington. Led by a Board of Directors, NPAIHB’s mission is to "eliminate health disparities and improve the quality of life of American Indians and Alaska Natives by supporting Northwest Tribes in their delivery of culturally appropriate, high-quality health programs and services."

NPAIHB is a mission-driven organization with a staff of over 120 professionals dedicated to advancing Tribal health for the 7th generation in the Pacific Northwest.

• Create new and enhance existing systems and pipelines that enable efficient, reliable, and secure flow of data, including ingestion, processing, and storage.
• Load data into storage systems or data warehouses, transforming, cleaning, and organizing with dimensional modeling techniques to ensure accuracy, consistency, and efficient querying.
• Transform and structure data to ensure it is optimized for use in data visualization software, enabling accurate and effective visual representations of epidemiological data.
• Ensure thorough and clear documentation of database architecture and workflows to promote sustainability, consistency, and ease of maintenance.
• Apply rigorous data quality checks and validation processes to guarantee the accuracy and reliability of the data released, emphasizing the importance of delivering correct and trustworthy data to support public health initiatives.
• Optimize data pipelines, infrastructure, and workflows for performance and scalability.
• Monitor data pipelines and systems for performance issues, errors, and anomalies, and implement solutions to address them.
• Implement security measures to protect sensitive information.
• Collaborate with epidemiologists, analysts, and other partners to understand current and future data needs and requirements, and to ensure that the data infrastructure supports the organization's goals and objectives.
• Collaborate with cross‑functional teams to understand data requirements and design scalable solutions that meet business needs.
• Implement and maintain ETL processes to ensure the accuracy, completeness, and consistency of data.
• Design and manage data storage systems, including a Postgre
  
  SQL relational database.
• Apply knowledge about industry trends, best practices, and emerging technologies in data…