Remote Data Engineer

Summary

Join the CDC Foundation as a Data Engineer to design and implement scalable data architectures for the Northwest Portland Area Indian Health Board's Environmental Public Health Division. This role will play a crucial part in advancing Tribal health by developing a connected EPH data ecosystem, including connecting GIS data to environmental services data and creating data documentation.

Requirements

• 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)

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

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)