Data Engineer - Remote (U.S. based) - Alaska Division of Public Health

Job Highlights:

• 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

Overview

The CDC Foundation is seeking a skilled Data Engineer to support the Alaska Division of Public Health, Section of Public Health Nursing. This role is vital for designing, building, and maintaining data infrastructure in the transition to a new Electronic Health Record (EHR) system. This position focuses on transforming and loading data, creating a unified, patient-centered database to replace the current location-based system. Key responsibilities include complex ETL tasks, data mapping, transformation, cleansing, and preparation for efficient import with minimal downtime. Collaboration with data experts, IT staff, and organizational personnel is essential to ensure the new system meets the Division's needs. The role is fully remote within the U.S.

Responsibilities

• Establish relationships between disparate databases to ensure accurate and effective data consolidation.
• Create and manage systems and pipelines for efficient data flow, including ingestion, processing, and storage.
• Collect, transform, and clean data to ensure accuracy and consistency, and load data into storage systems or data warehouses.
• Optimize data pipelines, infrastructure, and workflows for performance and scalability.
• Monitor data pipelines for performance issues, errors, and anomalies, and implement solutions.
• Implement security measures to protect sensitive information and ensure compliance with regulations, particularly HIPAA.
• Collaborate with data scientists, analysts, and other partners to understand their data needs and ensure the data infrastructure meets organizational goals.
• Implement and maintain ETL processes to ensure data accuracy, completeness, and consistency.
• Design and manage data storage systems, including relational databases, NoSQL databases, and data warehouses.
• Create system architecture diagrams, documentation, and guidelines to communicate design decisions and best practices.
• Stay updated on industry trends, best practices, and emerging technologies in data engineering, and incorporate them into the organization's data infrastructure.
• Provide technical guidance to other staff.
• Communicate effectively with partners to gather requirements, provide updates, and present findings.

Qualifications

• Bachelor's degree in computer science, information technology, data science, or a related field.
• Strong experience in SQL, Python, C#, Java, Data Warehouse, and building scalable ETL pipelines.
• Proficiency in engineering best practices such as source control, automated testing, continuous integration and deployment, and peer review.
• Familiarity with Data Transformation Systems (DTS) for moving data to SQL Server systems.
• Knowledge of data deduplication techniques and data quality maintenance.
• Experience with data modeling and moving from location-based to person-centric database models, preferably in healthcare.
• Preferred skills include experience with MUMPS DB/VA Fileman data extraction and hierarchical database systems.
• Knowledge of data warehousing concepts and tools, and cloud computing platforms.
• Expertise in data modeling, ETL processes, and data integration techniques.
• Understanding of data security and compliance standards, especially HIPAA.
• Strong analytical thinking and problem-solving abilities.
• Excellent verbal and written communication skills for conveying technical concepts to non-technical partners.
• Flexibility to adapt to evolving project requirements and priorities.
• Outstanding interpersonal and teamwork skills.
• Experience working in a virtual environment with remote partners and teams.
• Proficiency in Microsoft Office.

Special Notes

This role involves a dynamic public health program. Roles and responsibilities are subject to change based on evolving situations. Changes may be implemented upon written approval from the CDC Foundation to best support public health programming.

About the CDC Foundation

The