CDC Foundation
Overview
The
Data Scientist
will lead the development of datasets for data-driven visualizations and performance metrics to support public health decision-making within the Hawaii Department of Health (HDOH) as part of the Hawaii Data & Analytics Modernization Project. This role is embedded in the Workforce Acceleration Initiative (WAI), a federally funded CDC Foundation program aimed at enhancing public health agencies’ technology and data systems. The Data Scientist will focus on making datasets accessible and designing and implementing PowerBI dashboards for over 40 HDOH programs. This comprises importing datasets to the DOH Enterprise Data Warehouse (EDW) in Azure, developing robust Extract, Transform, Load (ETL) processes, and delivering a Train-the-Trainer program to build staff capacity for data pipelines and dashboards maintenance. The role requires close collaboration with HDOH program staff, Subject Matter Experts (SMEs), and the Health Data & Informatics Office (HDIO) staff PowerBI and IT teams. The role ensures data is made accessible and dashboards are developed to align with Public Health Accreditation Board (PHAB) standards, Continuous Quality Improvement (CQI) initiatives, and HDOH program goals. The Data Scientist will integrate stakeholder engagement to address diverse programmatic needs and support the synthesis of a core data model within the data warehouse across HDOH programs. This position is eligible for a fully remote work arrangement for U.S.-based candidates, hired through the CDC Foundation, and assigned to HDOH’s Health Data & Informatics Office. Responsibilities
Data Management and ETL Process Development: Assess, plan, and develop data pipelines from multiple operational systems for ingest into a common HDOH data warehouse, with appropriate governance controls, for use in analysis and reporting projects. ETL management to support data visualization for over 40 HDOH programs, ensuring reliable data integration and quality from source systems to the HDOH data warehouse for PowerBI dashboards. Collaborate with HDIO’s PowerBI and IT teams to design and implement ETL workflows, integrating disparate data sources into a unified core data model. Develop and maintain standardized data collection, quality, and processing protocols to ensure data accuracy, consistency, and timeliness. Produce updated weekly progress reports on ETL and data management activities for relevant stakeholders. PowerBI Dashboard Development: Lead the design, development, and deployment of interactive PowerBI dashboards for over 40 HDOH programs, visualizing identified KPIs and performance metrics with HDOH technical staff. Ensure dashboards are user-friendly, with drill-down capabilities, and aligned with PHAB accreditation readiness, CQI initiatives, and HDOH program goals. Conduct iterative design reviews and usability testing with HDOH staff to refine dashboard functionality and address program-specific needs. Produce weekly progress reports on dashboard development for stakeholders. Train-the-Trainer Program Development: Develop and deliver a Train-the-Trainer program to equip HDOH staff with skills to create, maintain, and update data pipelines and PowerBI dashboards, including ETL details for troubleshooting. Design modular, flexible training sessions with recorded materials and user-friendly guides to accommodate varying schedules and skill levels. Provide ongoing support through a helpdesk or peer mentoring system to reinforce learning and ensure long-term sustainability. Produce weekly progress reports on training efforts to monitor adoption and impact. Project Coordination and Stakeholder Collaboration: Oversee coordination and execution of dashboard development, metrics refinement, and training, ensuring integration with interrelated projects (data governance, EDSS modernization, core data model synthesis). Lead regular project meetings with HDOH staff, SMEs, and HDIO’s PowerBI and IT teams to review progress, address issues, and ensure PHAB alignment. Use project management tools to track ETL, dashboard, and training milestones, allocating resources to meet timelines and stakeholder expectations. Produce weekly progress reports on project coordination to maintain clear communication and accountability. Risk Management and Communication: Identify and mitigate risks in ETL processes, dashboard usability, and training adoption, collaborating with HDIO teams to ensure data accuracy and stakeholder satisfaction. Develop stakeholder communication materials (reports, presentations) using data visualization tools to share progress, ETL performance, and dashboard insights with clarity. Qualifications
Education:
Bachelor’s degree in Information Systems, Data Science, Public Health, Computer Science, or a related field. Master’s degree in a similar field preferred but not required. Experience:
7-10 years of experience in data management, ETL development or maintenance, business intelligence, or public health informatics, ideally with a focus on healthcare or public health IT systems. Demonstrated expertise in designing and implementing ETL processes and data management frameworks for data integration and quality assurance. Significant experience developing and deploying PowerBI dashboards for performance tracking and visualization in complex organizational settings. Experience working with public health agencies or healthcare systems, particularly in data systems, performance metrics, and stakeholder engagement, is highly desirable. Technical Skills:
Proficiency in developing and maintaining ETL processes, database design, and data quality assurance, with experience integrating disparate data sources into a common data warehouse and associated common data model. Proficiency in data quality tools and data catalogs, for developing and maintaining consistent data resources or data products. Proficiency in PowerBI for dashboard design, data modeling, and DAX. Familiarity with SQL for querying and managing relational databases. Experience with project management tools for tracking milestones and resource allocation. Public Health and Evaluation Knowledge:
Understanding of public health workflows, data collection methods, data quality methods, and evaluation methodologies for performance metrics. Familiarity with PHAB standards, CQI initiatives, and national/international public health metrics frameworks is desired. Experience implementing training programs for technical tools (e.g., PowerBI, ETL processes) in public health settings. Communication and Collaboration:
Exceptional interpersonal and communication skills to facilitate collaboration with diverse stakeholders, including public health professionals, technical teams, and leadership, while demonstrating cultural sensitivity and respect for Hawaii’s unique cultural context. Ability to adapt communication styles and approaches to align with HDOH values, fostering trust and effective partnerships. Proven ability to bridge technical and business requirements, ensuring alignment between data solutions and organizational goals. Experience managing stakeholders and leading cross-functional teams in fast-paced environments, with a focus on building inclusive and culturally responsive collaborations. Project Management:
Strong project management skills, including planning, creating work breakdown structures, and tracking milestones. Ability to manage multiple priorities, meet deadlines, and solve complex problems with minimal supervision. Experience with organizational change management, preferably using models like ADKAR. Job Highlights
Location: Remote, must be based in the United States. The individual must align their work hours with Hawaii Standard Time (HST) to ensure effective collaboration and communication with HDOH teams and stakeholders. Resources based in the Western US time zones preferred. Salary Range: $92,700-$134,275 per year, plus benefits. Individual salary offers will be based on experience and qualifications. Position Type: Grant-funded, limited-term opportunity. Position End Date: June 30, 2026. Special Notes
This role is involved in a dynamic public health program. As such, roles and responsibilities are subject to change as situations evolve. Roles and responsibilities listed above may be expanded upon or updated to match priorities and needs, once written approval is received by the CDC Foundation in order to best support the public health programming. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, national origin, age, mental or physical disabilities, veteran status, and all other characteristics protected by law. We comply with all applicable laws including E.O. 11246 and the Vietnam Era Readjustment Assistance Act of 1974 governing employment practices and do not discriminate on the basis of any unlawful criteria in accordance with 41 C.F.R. 60-300.5(a)(12) and 60-741.5(a)(7). As a federal government contractor, we take affirmative action on behalf of protected veterans. The CDC Foundation is a smoke-free environment. Relocation expenses are not included. About The CDC Foundation
The CDC Foundation helps 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. The CDC Foundation manages hundreds of programs each year 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. Visit www.cdcfoundation.org for more information.
#J-18808-Ljbffr
The
Data Scientist
will lead the development of datasets for data-driven visualizations and performance metrics to support public health decision-making within the Hawaii Department of Health (HDOH) as part of the Hawaii Data & Analytics Modernization Project. This role is embedded in the Workforce Acceleration Initiative (WAI), a federally funded CDC Foundation program aimed at enhancing public health agencies’ technology and data systems. The Data Scientist will focus on making datasets accessible and designing and implementing PowerBI dashboards for over 40 HDOH programs. This comprises importing datasets to the DOH Enterprise Data Warehouse (EDW) in Azure, developing robust Extract, Transform, Load (ETL) processes, and delivering a Train-the-Trainer program to build staff capacity for data pipelines and dashboards maintenance. The role requires close collaboration with HDOH program staff, Subject Matter Experts (SMEs), and the Health Data & Informatics Office (HDIO) staff PowerBI and IT teams. The role ensures data is made accessible and dashboards are developed to align with Public Health Accreditation Board (PHAB) standards, Continuous Quality Improvement (CQI) initiatives, and HDOH program goals. The Data Scientist will integrate stakeholder engagement to address diverse programmatic needs and support the synthesis of a core data model within the data warehouse across HDOH programs. This position is eligible for a fully remote work arrangement for U.S.-based candidates, hired through the CDC Foundation, and assigned to HDOH’s Health Data & Informatics Office. Responsibilities
Data Management and ETL Process Development: Assess, plan, and develop data pipelines from multiple operational systems for ingest into a common HDOH data warehouse, with appropriate governance controls, for use in analysis and reporting projects. ETL management to support data visualization for over 40 HDOH programs, ensuring reliable data integration and quality from source systems to the HDOH data warehouse for PowerBI dashboards. Collaborate with HDIO’s PowerBI and IT teams to design and implement ETL workflows, integrating disparate data sources into a unified core data model. Develop and maintain standardized data collection, quality, and processing protocols to ensure data accuracy, consistency, and timeliness. Produce updated weekly progress reports on ETL and data management activities for relevant stakeholders. PowerBI Dashboard Development: Lead the design, development, and deployment of interactive PowerBI dashboards for over 40 HDOH programs, visualizing identified KPIs and performance metrics with HDOH technical staff. Ensure dashboards are user-friendly, with drill-down capabilities, and aligned with PHAB accreditation readiness, CQI initiatives, and HDOH program goals. Conduct iterative design reviews and usability testing with HDOH staff to refine dashboard functionality and address program-specific needs. Produce weekly progress reports on dashboard development for stakeholders. Train-the-Trainer Program Development: Develop and deliver a Train-the-Trainer program to equip HDOH staff with skills to create, maintain, and update data pipelines and PowerBI dashboards, including ETL details for troubleshooting. Design modular, flexible training sessions with recorded materials and user-friendly guides to accommodate varying schedules and skill levels. Provide ongoing support through a helpdesk or peer mentoring system to reinforce learning and ensure long-term sustainability. Produce weekly progress reports on training efforts to monitor adoption and impact. Project Coordination and Stakeholder Collaboration: Oversee coordination and execution of dashboard development, metrics refinement, and training, ensuring integration with interrelated projects (data governance, EDSS modernization, core data model synthesis). Lead regular project meetings with HDOH staff, SMEs, and HDIO’s PowerBI and IT teams to review progress, address issues, and ensure PHAB alignment. Use project management tools to track ETL, dashboard, and training milestones, allocating resources to meet timelines and stakeholder expectations. Produce weekly progress reports on project coordination to maintain clear communication and accountability. Risk Management and Communication: Identify and mitigate risks in ETL processes, dashboard usability, and training adoption, collaborating with HDIO teams to ensure data accuracy and stakeholder satisfaction. Develop stakeholder communication materials (reports, presentations) using data visualization tools to share progress, ETL performance, and dashboard insights with clarity. Qualifications
Education:
Bachelor’s degree in Information Systems, Data Science, Public Health, Computer Science, or a related field. Master’s degree in a similar field preferred but not required. Experience:
7-10 years of experience in data management, ETL development or maintenance, business intelligence, or public health informatics, ideally with a focus on healthcare or public health IT systems. Demonstrated expertise in designing and implementing ETL processes and data management frameworks for data integration and quality assurance. Significant experience developing and deploying PowerBI dashboards for performance tracking and visualization in complex organizational settings. Experience working with public health agencies or healthcare systems, particularly in data systems, performance metrics, and stakeholder engagement, is highly desirable. Technical Skills:
Proficiency in developing and maintaining ETL processes, database design, and data quality assurance, with experience integrating disparate data sources into a common data warehouse and associated common data model. Proficiency in data quality tools and data catalogs, for developing and maintaining consistent data resources or data products. Proficiency in PowerBI for dashboard design, data modeling, and DAX. Familiarity with SQL for querying and managing relational databases. Experience with project management tools for tracking milestones and resource allocation. Public Health and Evaluation Knowledge:
Understanding of public health workflows, data collection methods, data quality methods, and evaluation methodologies for performance metrics. Familiarity with PHAB standards, CQI initiatives, and national/international public health metrics frameworks is desired. Experience implementing training programs for technical tools (e.g., PowerBI, ETL processes) in public health settings. Communication and Collaboration:
Exceptional interpersonal and communication skills to facilitate collaboration with diverse stakeholders, including public health professionals, technical teams, and leadership, while demonstrating cultural sensitivity and respect for Hawaii’s unique cultural context. Ability to adapt communication styles and approaches to align with HDOH values, fostering trust and effective partnerships. Proven ability to bridge technical and business requirements, ensuring alignment between data solutions and organizational goals. Experience managing stakeholders and leading cross-functional teams in fast-paced environments, with a focus on building inclusive and culturally responsive collaborations. Project Management:
Strong project management skills, including planning, creating work breakdown structures, and tracking milestones. Ability to manage multiple priorities, meet deadlines, and solve complex problems with minimal supervision. Experience with organizational change management, preferably using models like ADKAR. Job Highlights
Location: Remote, must be based in the United States. The individual must align their work hours with Hawaii Standard Time (HST) to ensure effective collaboration and communication with HDOH teams and stakeholders. Resources based in the Western US time zones preferred. Salary Range: $92,700-$134,275 per year, plus benefits. Individual salary offers will be based on experience and qualifications. Position Type: Grant-funded, limited-term opportunity. Position End Date: June 30, 2026. Special Notes
This role is involved in a dynamic public health program. As such, roles and responsibilities are subject to change as situations evolve. Roles and responsibilities listed above may be expanded upon or updated to match priorities and needs, once written approval is received by the CDC Foundation in order to best support the public health programming. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, national origin, age, mental or physical disabilities, veteran status, and all other characteristics protected by law. We comply with all applicable laws including E.O. 11246 and the Vietnam Era Readjustment Assistance Act of 1974 governing employment practices and do not discriminate on the basis of any unlawful criteria in accordance with 41 C.F.R. 60-300.5(a)(12) and 60-741.5(a)(7). As a federal government contractor, we take affirmative action on behalf of protected veterans. The CDC Foundation is a smoke-free environment. Relocation expenses are not included. About The CDC Foundation
The CDC Foundation helps 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. The CDC Foundation manages hundreds of programs each year 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. Visit www.cdcfoundation.org for more information.
#J-18808-Ljbffr