Senior Data Engineer

Senior Data EngineerIf you're looking to be a part of a collaborative environment where your skills can make an impact, explore our current opportunities in creating a better future for 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.This is a grant-funded position.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.Duties and 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.Other duties as assigned include special tasks involved in responding to an emergency event.Harris County is an Equal Opportunity Employer. If you need special services or accommodations, please call View phone number on click.appcast.io or email View email address on click.appcast.io. 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.Requirements:Bachelor's degree in computer science, information systems or a related field8 (eight) years of experience in database administration.5 (five) years of experience with Stored Procedures, advanced query functions like Common Table Expressions, Pivots, etc. and other advanced RDBMS tasks5 (five) years of experience with SSIS.3 (three) years of experience practicing agile principles.3 (three) years of working with HIPAA protected data.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.Be 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.NOTE: Qualifying education, experience, knowledge and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.Preferences:Experience in Azure and Snowflake platforms.Experience working with HL7 Data.Experience in business reporting.Experience with PowerBI.General Information:Position Type, and Typical Hours of Work: Full-Time | Grant-Funded PositionMonday – Friday | 8 am – 5 pmHours 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: This job operates in a professional office environment.This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.May require travel.Physical Demands: This is primarily a sedentary position.Work Location: Harris County Public Health (1111 Fannin, Houston, 77002)Benefits:Harris County offers a highly competitive benefits program, featuring a comprehensive group health plan and defined benefit retirement plan.The following benefits are offered only to Harris County employees in regular (full-time) positions:Medical CoverageDental CoverageVision CoverageWellness PlanLife InsuranceLong-Term Disability (LTD) InsuranceEmployee Assistance Program (EAP)Healthcare Flexible Spending AccountDependent Care Flexible Spending AccountPaid Time Off (PTO):Ten (10) days of vacation leave per year (accrual rate increases after 5 years of service)Eleven (11) County-observed holidaysOne (1) floating holiday per yearPaid Parental Leave*Sick LeaveRetirement Savings Benefit:457 Deferred Compensation PlanThe following benefits are available to Harris County employees in full-time and select part-time positions:Professional learning & development opportunitiesRetirement pension (TCDRS defined benefit plan)Flexible work schedule*METRO RideSponsor Program** Participation may vary by County department. The employee benefits plans of Harris County are extended to all eligible participants across various departments with the exception of the Harris County Community Supervision and Corrections Department, for which the cited Health & Wellness Benefits are administered through the State of Texas.In accordance with the Harris County Personnel Regulations, group health and related benefits are subject to amendment or discontinuance at any time. Harris County Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.For plan details, visit the Harris County Benefits & Wellness website: