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. #J-18808-Ljbffr