Senior Data Engineer
Job Description
Harris County Public Health offers a stable, full-time, grant-funded role with a flexible work schedule and a comprehensive benefits package designed to support your health and long-term security. This onsite position in Houston, TX combines hands-on data engineering with collaboration across teams serving public health needs, including opportunities for professional learning and development.
What You’ll Do
As a Senior Data Engineer, you will build and maintain the data foundation used for analysis and reporting. You will help deliver reliable data pipelines, collection systems, data models, and a data warehouse environment that supports timely, efficient datasets for internal analytics teams.
- Maintain and build out the data warehouse and analytics environment
- Develop data pipelines, collection systems, and data models to support data analysis and reporting
- Research improvements to data collection and processing
- Collaborate with data analytics teams across Harris County Public Health to provide relevant datasets
- Share knowledge to strengthen team-wide expertise
- Communicate project status, risks, milestones, and assigned roles to cross-department stakeholders
- Complete other assigned duties, including special tasks related to responding to an emergency event
Key Technologies
- SQL, Stored Procedures, Common Table Expressions, Pivots
- SSIS
- Azure, Snowflake
- HL7
- PowerBI
- HIPAA protected data
Requirements
- Bachelor’s degree in computer science, information systems, or a related field
- 8 years of experience in database administration
- 5 years of experience with Stored Procedures, advanced query functions such as Common Table Expressions and Pivots, and other advanced RDBMS tasks
- 5 years of experience with SSIS
- 3 years of experience practicing agile principles
- 3 years of experience working with HIPAA protected data
- Strong SQL skills and database architecture
- In-depth understanding of IT security and how to handle health protected data
- Strong problem-solving skills to analyze issues, identify root causes, and develop effective solutions
- Ability to manage time efficiently, set priorities, and meet project deadlines
- Ability to foster a collaborative and inclusive work environment and support teamwork and knowledge sharing
Preferences
- Experience with Azure and Snowflake platforms
- Experience working with HL7 Data
- Experience in business reporting
- Experience with PowerBI
Benefits
- Medical Coverage
- Dental Coverage
- Vision Coverage
- Wellness Plan
- Life Insurance
- Long-Term Disability (LTD) Insurance
- Employee Assistance Program (EAP)
- Healthcare Flexible Spending Account
- Dependent Care Flexible Spending Account
- Ten (10) days of vacation leave per year
- Eleven (11) County-observed holidays
- One (1) floating holiday per year
- Paid Parental Leave*
- Sick Leave
- 457 Deferred Compensation Plan
- Professional learning & development opportunities
- Retirement pension (TCDRS defined benefit plan)
- Flexible work schedule*
- METRO RideSponsor Program*
Work Schedule and Location
- Full-Time | Grant-Funded Position
- Monday – Friday | 8 am – 5 pm
- Hours may vary based on the business needs of the department or task requirements
- May require periodic overnight travel and long hours/overtime during emergencies/disasters
Work Environment and Physical Demands
- Professional office environment
- Uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines
- May require travel
- Primarily a sedentary position
Core Competencies
- Data Analytics and Assessment Skills: use data to analyze community health needs and support decisions that improve community health outcomes
- Communication Skills: use clear and effective communication to engage audiences, address misinformation, and build trust
- Health Advancement Skills: apply equity, diversity, and inclusion principles to public health and promote fair access to resources
- Community Partnership Skills: collaborate with communities to address systems and policies affecting health
- Public Health Science Skills: apply public health science and evidence-based approaches to support effective delivery of the 10 Essential Public Health Services
Work Location: Harris County Public Health, 1111 Fannin, Houston, TX 77002
Notes: Qualifying education, experience, knowledge, and skills must be documented on your job application. A resume may be attached as supporting documentation, but only information stated on the application will be used for consideration. “See Resume” will not be accepted for qualifications.
Criminal History Check: This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.