Description
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.
\n- Location: Remote, must be based in the United States
- Salary Range: $115,000-$165,000, plus benefits
- Position Type: Grant funded, limited-term opportunity
- Position End Date: June 30, 2025
- The Data Engineer will play a crucial role in advancing the CDC Foundation's mission by designing, building, and maintaining data infrastructure for a public health organization. Working within the Nevada Division of Public and Behavioral Health (DPBH), Office of State Epidemiology (OSE) Informatics team, the Data Engineer will deliver the architecture needed for data generation, storage, processing, and analysis in support of the AWS Data Lake. The Data Engineer will collaborate with epidemiologists, data content experts, analysts, data scientists, and DPBH Office of Information Technology staff to identify, design and implement proposed solutions and architectures that meet the needs of the public health agency.
- The Data Engineer will be hired by the CDC Foundation and assigned to the Informatics team within the Nevada DPBH, Office of State Epidemiology. This position is eligible for a fully remote work arrangement for U.S. based candidates.
- Design and implement distributed data processing pipelines supporting the Nevada, and Federal Public Health ecosystems.
- Collect data from various sources, transforming and cleaning it to ensure accuracy and consistency. Load data into storage systems or data warehouses.
- 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.
- Collaborate with Nevada’s Department of Health and Human Services and the Data Lake Governance Committee on data governance policy, data security, and data use agreements for impacted data systems required to meet the OSE mission.
- Collaborate with the Nevada DPBH Office of Information Technology to implement best practices and standards for systems interoperability, including HL7 v2.x and v3.x, FHIR, RESTful State APIs, public health industry data taxonomies, database connections APIs (OBDC, JDBC, ADO, etc.), and vendor-supported information systems standards.
- Lead and partner with internal and multiple solution vendors’ architecture/engineering leads and other integrated project team members to ensure high quality solutions through code reviews, and software engineering best practices documentation.
- Collaborate with data owners, data stewards, information technologists, public health analysts, and other public health resources to identify, move, transform and curate public health data in support of data scientists, epidemiologists, and biostatisticians big data analytics and data products creation.
- Design, develop, modernize/migrate pipelines to the Amorphic/AWS Data Lake
- Engage and collaborate with internal and multiple solution vendors’ DevOps teams by building utilities, user defined functions and frameworks to better enable data flow patterns.
- Implement and maintain ETL processes to ensure the accuracy, completeness, consistency and security of data.
- Design and manage data storage systems, including relational databases, NoSQL databases, and data warehouses.
- Collaborate on data modeling, forecasting, and visualization projects.
- Collaborate with AWS Data Lake Project Director on data governance policies.
- Ensure compliance with Nevada security regulations and standards.
- Establish data use agreements for relevant data systems.
- Develop strategies and protocols to monitor data quality.
- Implement mechanisms to identify and rectify data errors promptly.
- Establish processes for ongoing data quality assessment and improvement.
- Knowledgeable about industry trends, best practices, and emerging technologies in data engineering, and incorporating the trends into the organization's data infrastructure.
- Collaborate with partners to develop and participate in a ‘lessons learned’ and shared knowledge cohort.
- Prepare documentation and share improvements, success stories, challenges, and opportunities throughout both State and CDC meetings/events.
- Attend training and learning opportunities addressing technical skillsets and other related information systems improvement subjects.
- Communicate effectively with partners at all levels of the organization to gather requirements, provide updates, and present findings.
- Bachelor’s degree in a computer science, informatics, mathematics or related discipline. Master’s degree preferred.
- Minimum 5 years of professional experience in large-scale software development/Big Data technologies
- Minimum 5 years of experience in SQL, data transformations, statistical analysis, and troubleshooting across more than one Database Platform (Cache’, MySQL, Snowflake, PostgreSQL, Redshift, MS SQL, etc.).
- Minimum 5 years of experience in data engineering with an emphasis on data identification, data streams, data curation, data transformation, and delivery of data products
- Minimum 3 years of experience with cloud platforms such as Amazon Web Services (AWS)
- Experience with public health data solutions such as, EHR, Immunization, Vital Records, Health Surveillance, etc., preferred.
- Proficiency in programming languages commonly used in data engineering, such as Python, R, Java, Scala, or SQL.
- Hands-on experience implementing data automations within existing frameworks.
- Experience with big data technologies and frameworks like Hadoop, Spark, Kafka, and Flink.
- Strong understanding of database systems, including relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Cassandra).
- Experience regarding engineering best practices such as source control, automated testing, continuous integration and deployment, and peer review.
- Experience with one or more of the following scripting languages: Python, R, SQL, and/or other.
- Experience designing and building solutions utilizing AWS Cloud services such as Lambda, Glue, Athena, API gateway, DynmoDB, etc.
- Knowledge of data warehousing concepts and tools.
- Expertise in the design and build of data modeling, data extraction, transformation, loading (ETL) processes, data integration techniques, and writing custom data pipelines.
- Understanding of the underlying data models and structures used by EPIC or Cerner EHR systems, preferred, including the relational database schemas, table relationships, and data dictionaries.
- Knowledge of common data elements, terminology standards, and coding systems (e.g., ICD-10, SNOMED CT) used to represent clinical concepts and patient information within EHR systems, preferred.
- Experience in mapping and transforming EHR data into standardized formats for integration with other healthcare systems and analytics platforms, preferred.
- Experience developing with HL7 and FHIR HL7 interoperability standards, preferred.
- Knowledge of the ONC United States Core Data for Interoperability (USCDI), preferred.
- Deep understanding of HIPAA, FERPA, and HITECH, preferred.
- Familiarity with agile development methodologies, software design patterns, and best practices.
- 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.
- Outstanding interpersonal and teamwork skills; and the ability to develop productive working relationships with colleagues and partners.
- Experience working in a virtual environment with remote partners and teams.
- Proficiency in Microsoft Office.
- 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.
