Senior Data Engineer

The Senior Data Engineer at Harris County Public Health designs, builds, and maintains data pipelines, collection systems, data models, and a data warehouse to enable efficient analytics, reporting, and data-driven decision support.

Key Responsibilities

• Maintain and further develop the data warehouse and analytics environment.
• Build data pipelines, collection systems, and data models aligned to data analysis and reporting requirements.
• Research approaches to improve data collection and processing.
• Work with data analytics teams across Harris County Public Health to provide efficient and relevant datasets.
• Share knowledge to strengthen team-wide expertise.
• Provide cross-departmental stakeholders with clear communication on project status, risks, milestones, and assigned roles and responsibilities.
• Perform other duties as assigned, including special tasks related to responding to an emergency event.

Required Qualifications

• Bachelor’s degree in computer science, information systems, or a related field.
• 8 (eight) years of experience in database administration.
• 5 (five) years of experience with Stored Procedures, advanced query functions such as Common Table Expressions and Pivots, and other advanced RDBMS tasks.
• 5 (five) years of experience with SSIS.
• 3 (three) years of experience practicing agile principles.
• 3 (three) years of experience working with HIPAA protected data.
• Strong SQL skills and database architecture expertise.
• In-depth understanding of IT security and handling health protected data.
• Ability to solve problems by analyzing issues, identifying root causes, and developing effective solutions.
• Strong time management skills, including priority setting and meeting project deadlines.
• Commitment to collaboration and inclusion, supporting teamwork and knowledge sharing.

Technology and Tools

• SQL
• Stored Procedures
• Common Table Expressions
• Pivots
• SSIS
• HIPAA protected data
• Azure
• Snowflake
• HL7
• PowerBI

Preferred Experience

• Experience in Azure and Snowflake platforms.
• Experience working with HL7 Data.
• Experience with 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 Location and Work Schedule

Location: Harris County Public Health, 1111 Fannin, Houston, 77002 (onsite).

• Position Type: Full-Time | Grant-Funded Position
• Typical Hours: Monday – Friday | 8 am – 5 pm
• Hours may vary based on department business needs or task requirements.
• Periodic overnight travel and long hours or overtime may be required during emergencies or disasters.

Work Environment and Physical Demands

• Professional office environment.
• Routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines.
• May require travel.
• Primarily a sedentary position.

Additional Information

• Qualifying education, experience, knowledge, and skills must be documented on the 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.
• Subject to a criminal history check; only relevant convictions will be considered, and may not automatically disqualify the candidate.

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 principles of equity, diversity, and inclusion to address systemic barriers and promote fair access to resources for healthier communities.
• Community Partnership Skills: Collaborate with communities to address systems and policies affecting health, fostering engagement, shared ownership, and sustainable improvements in well-being.
• Public Health Science Skills: Use public health science and evidence-based approaches to develop and improve policies and programs, supporting effective delivery of the 10 Essential Public Health Services.