Oregon Health & Science University
Environmental Public Health Data Engineer CDC Environmental Public Health Divisi
Oregon Health & Science University, Oregon, Illinois, United States, 61061
The CDC Foundation helps the Centers for Disease Control and Prevention (CDC) save and improve lives by unleashing the power of collaboration between CDC, philanthropies, corporations, organizations and individuals to protect the health, safety and security of America and the world. The CDC Foundation is the go-to nonprofit authorized by Congress to mobilize philanthropic partners and private-sector resources to support CDC’s critical health protection mission. Since 1995, the CDC Foundation has raised over $1.9 billion and launched more than 1,300 programs impacting a variety of health threats from chronic disease conditions including cardiovascular disease and cancer, to infectious diseases like rotavirus and HIV, to emergency responses, including COVID-19 and Ebola. The CDC Foundation managed hundreds of programs in the United States and in more than 90 countries last year. Visit www.cdcfoundation.org for more information.
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) Environmental Public Health Division. This role is aligned to the Workforce Acceleration Initiative (WAI). WAI is a federally funded CDC Foundation program with the goal of helping the nation’s public health agencies by providing them with the technology and data experts they need to accelerate their information system improvements. Working closely with the Environmental Public Health (EPH) Team, the Data Engineer will create the architecture needed for data storage, processing, analysis, and sharing with Tribal partners. The Data Engineer will collaborate with environmental health scientists, data content experts, IT staff, and others to develop and implement scalable solutions that align with the objectives of the NPAIHB’s EPH team.
The Environmental Public Health Division, established in 2020, is relatively new to NPAIHB. The Data Engineer will play a key role in developing a plan for a connected EPH data ecosystem, including connecting NPAIHB’s ArcGIS Online environment to tribes’ Esri Enterprise environments, connecting GIS data to environmental services data, and connecting EPH data to NPAIHB’s Data Hub, a newly created public health database. The EPH team is planning to develop or purchase a system to store environmental health services data including inspections of food establishments and education and health care facilities. The Data Engineer will advise on this system and develop a plan for extracting data from the existing system, ingesting into the planned system, and creating data documentation. The Data Engineer’s work will be pivotal in enhancing the capacity of the EPH Team to conduct data-driven activities, advancing Tribal data sovereignty, and empowering Tribes to create healthy communities. 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 the NPAIHB 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. The Data Engineer will be hired by the CDC Foundation and assigned to the Environmental Public Health Division at NPAIHB. This position is eligible for a fully remote work arrangement for U.S. based candidates.
Responsibilities
Design and implement scalable data architectures, including integrating GIS and environmental health services data.
Develop data pipelines for ingesting, processing, storing, and sharing data, ensuring efficient, reliable, and secure data flow.
Provide technical advice and support for the development or procurement of systems to store environmental health services data.
Develop and implement data extraction, transformation, and loading (ETL) processes to migrate data from legacy systems to new platforms.
Apply knowledge about industry best practices and emerging technologies to develop a plan for streamlining data migration and data integration from numerous data sources into a centralized data hub.
Establish effective data governance practices through improving data management of data deduplication to remove redundancy and ensure unique records.
Transform and structure data to ensure it is optimized for use in data visualization software, enabling accurate and effective visual representations of environmental data.
Develop and maintain comprehensive data documentation to promote sustainability and consistency.
Apply rigorous data quality checks and validation processes to ensure accurate and reliable data.
Collaborate with environmental scientists, analysts, IT staff, 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.
Communicate effectively with partners at all levels of the organization to gather requirements, provide updates, and present findings.
QualificationsRequired Qualifications
Bachelor’s degree with emphasis in computer science, information technology, data science or related field
Minimum 5 years of relevant professional experience
Experience building and maintaining data pipelines, databases, and data integration solutions.
Proficiency in SQL programming and other languages commonly used in data engineering, such as Python, Java, Scala.
Proven working experience with database standards and familiarity with database design, documentation, and coding.
Strong understanding of database systems, including relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra).
Knowledge of ETL tools and processes, data modeling, and database management systems.
Experience with cloud computing platforms and data warehousing solutions.
Strong analytical thinking and problem-solving abilities.
Excellent verbal and written communication skills, including the ability to convey technical concepts to non-technical partners effectively.
Flexibility to adapt to evolving project requirements and priorities.
Strong collaborative skills with experience working in cross-functional teams.
Experience working in a virtual environment with remote partners and teams.
Proficiency in Microsoft Office.
Ability to travel occasionally for in-person meetings (travel costs will be covered by NPAIHB).
Preferred Qualifications
Experience working with complex public health, environmental science, health care, or other non-business data requiring advanced processing and analysis techniques.
Experience working with GIS data and platforms like ArcGIS.
Experience using AWS QuickSight or similar data visualization tools (Tableau, Microsoft Power BI, etc).
#J-18808-Ljbffr
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) Environmental Public Health Division. This role is aligned to the Workforce Acceleration Initiative (WAI). WAI is a federally funded CDC Foundation program with the goal of helping the nation’s public health agencies by providing them with the technology and data experts they need to accelerate their information system improvements. Working closely with the Environmental Public Health (EPH) Team, the Data Engineer will create the architecture needed for data storage, processing, analysis, and sharing with Tribal partners. The Data Engineer will collaborate with environmental health scientists, data content experts, IT staff, and others to develop and implement scalable solutions that align with the objectives of the NPAIHB’s EPH team.
The Environmental Public Health Division, established in 2020, is relatively new to NPAIHB. The Data Engineer will play a key role in developing a plan for a connected EPH data ecosystem, including connecting NPAIHB’s ArcGIS Online environment to tribes’ Esri Enterprise environments, connecting GIS data to environmental services data, and connecting EPH data to NPAIHB’s Data Hub, a newly created public health database. The EPH team is planning to develop or purchase a system to store environmental health services data including inspections of food establishments and education and health care facilities. The Data Engineer will advise on this system and develop a plan for extracting data from the existing system, ingesting into the planned system, and creating data documentation. The Data Engineer’s work will be pivotal in enhancing the capacity of the EPH Team to conduct data-driven activities, advancing Tribal data sovereignty, and empowering Tribes to create healthy communities. 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 the NPAIHB 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. The Data Engineer will be hired by the CDC Foundation and assigned to the Environmental Public Health Division at NPAIHB. This position is eligible for a fully remote work arrangement for U.S. based candidates.
Responsibilities
Design and implement scalable data architectures, including integrating GIS and environmental health services data.
Develop data pipelines for ingesting, processing, storing, and sharing data, ensuring efficient, reliable, and secure data flow.
Provide technical advice and support for the development or procurement of systems to store environmental health services data.
Develop and implement data extraction, transformation, and loading (ETL) processes to migrate data from legacy systems to new platforms.
Apply knowledge about industry best practices and emerging technologies to develop a plan for streamlining data migration and data integration from numerous data sources into a centralized data hub.
Establish effective data governance practices through improving data management of data deduplication to remove redundancy and ensure unique records.
Transform and structure data to ensure it is optimized for use in data visualization software, enabling accurate and effective visual representations of environmental data.
Develop and maintain comprehensive data documentation to promote sustainability and consistency.
Apply rigorous data quality checks and validation processes to ensure accurate and reliable data.
Collaborate with environmental scientists, analysts, IT staff, 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.
Communicate effectively with partners at all levels of the organization to gather requirements, provide updates, and present findings.
QualificationsRequired Qualifications
Bachelor’s degree with emphasis in computer science, information technology, data science or related field
Minimum 5 years of relevant professional experience
Experience building and maintaining data pipelines, databases, and data integration solutions.
Proficiency in SQL programming and other languages commonly used in data engineering, such as Python, Java, Scala.
Proven working experience with database standards and familiarity with database design, documentation, and coding.
Strong understanding of database systems, including relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra).
Knowledge of ETL tools and processes, data modeling, and database management systems.
Experience with cloud computing platforms and data warehousing solutions.
Strong analytical thinking and problem-solving abilities.
Excellent verbal and written communication skills, including the ability to convey technical concepts to non-technical partners effectively.
Flexibility to adapt to evolving project requirements and priorities.
Strong collaborative skills with experience working in cross-functional teams.
Experience working in a virtual environment with remote partners and teams.
Proficiency in Microsoft Office.
Ability to travel occasionally for in-person meetings (travel costs will be covered by NPAIHB).
Preferred Qualifications
Experience working with complex public health, environmental science, health care, or other non-business data requiring advanced processing and analysis techniques.
Experience working with GIS data and platforms like ArcGIS.
Experience using AWS QuickSight or similar data visualization tools (Tableau, Microsoft Power BI, etc).
#J-18808-Ljbffr