Senior Data Engineer

Harris County Public Health; Houston (TX); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

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 Allow

Paid Parental Leave

Sick Leave

457 Deferred Compensation Plan

Professional learning & development.Op

Retirement pension (TCDRS definedbenef

Flexible work schedule

METRO RideSponsor Program

Job summary

Harris County Public Health seeks a Senior Data Engineer to design, build, and maintain data pipelines, data models, and a data warehouse to enable analytics and data-driven decision making.

You will collaborate with analytics teams, develop scalable data solutions, and support emergency response data needs. Strong SQL, HIPAA compliance, and experience with Azure/Snowflake are essential for success in this role.

Qualifications

• Bachelor's degree in computer science, information systems, or a related field.
• 8 years of experience in database administration.
• 5 years with Stored Procedures, advanced query functions such as Common Table Expressions and Pivots, and other advanced RDBMS tasks.
• 5 years with SSIS.
• 3 years practicing agile principles.
• 3 years 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.

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 to provide efficient datasets.
• Share knowledge to strengthen team-wide expertise.
• Provide cross-departmental stakeholders with clear communication on project status, risks, milestones and responsibilities.
• Perform other duties as assigned, including special tasks related to emergency events.

Skills

SQL expertise

Problem solving

Time management

Collaboration

HIPAA data handling

Education

Bachelor's degree in computer science/information systems/related field

Tools

Azure

Snowflake

HL7

PowerBI

SSIS

HIPAA protected data

Common Table Expressions

Pivots

SQL

Job description

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.