Senior Data Engineer

About Harris County Public Health

Harris County Public Health (HCPH) includes a network of more than 1,100 public health professionals working together to improve health outcomes for the third most populous county in the United States. HCPH provides a multitude of services such as medical and dental services, community programming, and health education for the approximately 2.3 million people in unincorporated Harris County. Through its core values of innovation, engagement, and health equity, HCPH strives to bring meaningful solutions to public health issues while keeping Harris County healthy and vibrant.

Position Overview

Under the supervision of the DevOPS Manager of the Operation and Technology Services Office, the Senior Data Engineer is responsible for building and maintaining data pipelines and collection systems at Harris County Public Health. The Senior Data Engineer will oversee data integration work, develop data models, maintain a data warehouse that support efficient data analysis and reporting. The Senior Data Engineer will provide technical guidance to others and recommend system improvements.

Responsibilities

• Maintain and build out data warehouse and analytics environment.
• Develop data pipelines, collection systems, and data models that support data analysis and reporting needs.
• Research ways to improve data collection and processing.
• Collaborate with data analytics teams across Harris County Public Health to provide efficient and relevant datasets.
• Share knowledge to compliment team-wide expertise.
• Communicate project status, risks, milestones, and assigned roles and responsibilities to cross-departmental stakeholders.
• Perform special tasks involved in responding to an emergency event.

Requirements

Education

Bachelor's degree in computer science, information systems or a related field

Experience

• 8 years of experience in database administration.
• 5 years of experience with Stored Procedures, advanced query functions like Common Table Expressions, Pivots, etc. and other advanced RDBMS tasks
• 5 years of experience with SSIS.
• 3 years of experience practicing agile principles.
• 3 years of working with HIPAA protected data.

Knowledge, Skills and Abilities

• Strong SQL skills and database architecture.
• In-depth understanding of IT security and how to handle health protected data.
• Demonstrate strong problem-solving skills to analyze issues, identify root causes, and develop effective solutions to overcome challenges that may arise during the project.
• Skilled in managing time efficiently, setting priorities, and meeting project deadlines.
• Foster a collaborative and inclusive work environment, encouraging teamwork and knowledge sharing among project team members.

Core Competencies

• Data Analytics and Assessment Skills: Ability to use data to analyze community health needs and support decisions that improve community health outcomes.
• Communication Skills: This competency focuses on using clear and effective communication to engage audiences, address misinformation, and build trust, supporting informed decisions and stronger public health outcomes.
• Health Advancement Skills: This competency focuses on applying principles of equity, diversity, and inclusion to public health, addressing systemic barriers, and promoting fair access to resources for healthier communities.
• Community Partnership Skills: This competency focuses on collaborating with communities to address the systems and policies affecting health, fostering engagement, shared ownership, and sustainable improvements in well-being.
• Public Health Science Skills: This competency focuses on using public health science and evidence-based approaches to develop and improve policies and programs, ensuring effective delivery of the 10 Essential Public Health Services.

Preferences

• Experience in Azure and Snowflake platforms.
• Experience working with HL7 Data.
• Experience in business reporting.
• Experience with PowerBI.