Data Engineer

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.  
Job HighlightsLocation: Remote, must be based in the United StatesSalary Range: $103,500-$143,500 per year, plus benefits. Individual salary offers will be based on experience and qualifications unique to each candidate. Position Type: Grant funded, limited-term opportunityPosition End Date: June 30, 2025 
OverviewThe 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. 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 within the Salt Lake County Health Department's Information Technology (IT) team, part of the Internal Services Division, the Data Engineer will play a key role in developing and delivering technical solutions that enhance the use of public health data to inform decision-making. The Data Engineer will collaborate with both technical and non-technical teams to evaluate, design, build, and manage data infrastructure. This includes automating processes, creating efficient workflows, and ensuring data quality and accessibility. In addition to supporting the Data Modernization Initiative (DMI), the Data Engineer will also contribute to other department projects in IT and informatics, ensuring cohesive and aligned efforts across initiatives. Their work involves studying existing databases, designing scalable data systems, and implementing solutions that meet the needs of the public health agency.
The Data Engineer role will be hired by the CDC Foundation and assigned to the Salt Lake County health Department of Health, Information Technology (IT) team, part of the Internal Services Division. This position is eligible for a fully remote work arrangement for U.S. based candidates

Responsibilities

• Create and manage the systems and pipelines that enable efficient and reliable flow of data, including ingestion, processing, and storage.
• 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.
• Implement security measures to protect sensitive information in compliance with HIPAA.
• Collaborate with Informaticist, analysts, and other partners to understand their data needs and requirements, 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 relational databases, NoSQL databases, and data warehouses.
• Apply industry knowledge of best practices and emerging technologies in data engineering to the IT roadmap and organization’s data infrastructure to optimize interoperability
• Provide technical guidance to other staff.
• Communicate effectively with partners at all levels of the organization to gather requirements, provide updates, and present findings.
• Document all automated standards, practices, and processes.
• Review recommendations and IT plans and provide recommendation for best tools and solutions.
• Analyze existing IT roadmap plans and provide recommendations for technology solutions and tools to achieve project goals
• Design and implement efficient workflows and automation to streamline operations and improve system performance.
• Establish effective data governance practices to improve data quality, stewardship, protection, and compliance.
• Lead database migration efforts and optimize existing databases for enhanced functionality.
• Drive roadmap planning with a clear vision, ensuring robust and scalable solutions.

Qualifications

• Required Qualifications:
• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• Minimum 5 years of relevant professional experience. Proficiency in programming languages commonly used in data engineering, such as Python, Java, Scala, or SQL. Candidate should be able to implement data automations within existing frameworks as opposed to writing one off scripts.
• 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.
• Knowledge of data warehousing concepts and tools.
• Experience with cloud computing platforms.
• Expertise in data modeling, ETL (Extract, Transform, Load) processes, and data integration techniques.
• Experience with CRM tools like QuickBase and SQL to support data architecture and integration.
• 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


• Required Preferred:
• 6 years of relevant experience
• Public Health or Health Care experience
• Experience with cloud-based platforms such as Snowflake
• Knowledge of Electronic Health Records (HER)/Electronic Medical Records (EMR) and FHIR standards.
• Familiarity with data tools (e.g., Power Bi, Qualtrics, & Talend, SSIS (SQL Server Integration Services).

Special NotesThis 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.