Programmer Analyst II - School of Public Health

UTHealth Houston; Houston (TX); On-site; USD 65,000 - 90,000; Full time

Job summary

UTHealth Houston in Houston, TX is seeking a Programmer Analyst II to develop and maintain SQL queries, Python scripts, and ETL pipelines that integrate large healthcare datasets into a data warehouse for research, reporting, and analytics.

You will prepare data extracts, validate data accuracy, troubleshoot the database, and collaborate with data scientists, biostatisticians, and project managers to deliver timely, well-documented data solutions.

Qualifications

• Minimum two years of programming experience in a similar role.
• Experience with SQL, Python, SAS, or ETL tools preferred.
• Familiarity with data modeling, Tableau, or healthcare privacy requirements is a plus.
• Strong analytical, problem-solving, and communication skills required.

Responsibilities

• Develop and maintain SQL queries, Python scripts, and ETL pipelines for large healthcare datasets.
• Prepare data extracts and validate data accuracy.
• Troubleshoot databases and report issues; collaborate with data scientists, biostatisticians, and project managers to deliver data solutions.

Skills

SQL

Python

SAS

R

STATA

PL/SQL

Tableau

Data modeling

Healthcare privacy

Education

Bachelor's Degree in Computer Science

Tools

SAS

R

STATA

Job description

We are hiring immediately for a Programmer Analyst II to join the UTHealth Houston School of Public Health in Houston, Tx. In this position, you will develop and maintain SQL queries, Python scripts, and ETL pipelines to integrate large healthcare datasets into a data warehouse for research, reporting, and analytics. Daily responsibilities include preparing data extracts, validating data accuracy, troubleshooting the database, reporting issues, and collaborating with teams to deliver timely, well-documented data solutions. Ideal candidate should have at least two years of experience in a similar role, preferably working with large healthcare datasets, and experience with one or more of the following: SQL, Python, SAS, or ETL tools. Familiarity with data modeling, Tableau, or healthcare privacy requirements is a plus. Strong analytical, problem-solving, and communication abilities, preferred.

What we do here changes the world.

UTHealth Houston is Texas’ resource for healthcare education, innovation, scientific discovery, and excellence in patient care. That’s where you come in.

Once you join us you won't want to leave.

It’s because we reward our team for the excellent service they provide. Our total rewards package includes the benefits you’d expect from a top healthcare organization (benefits, insurance, etc.), plus:

• 100% paid medical premiums for our full-time employees
• Generous time off (holidays, preventative leave day, both vacation and sick time – all of which equates to around 37-38 days per year)
• The longer you stay, the more vacation you’ll accrue!
• Longevity Pay (Monthly payments after two years of service)
• Build your future with our awesome retirement/pension plan!

We take care of our employees!

As a world-renowned institution, our employees’ wellbeing is important to us. We offer work/life services such as...

• Free financial and legal counseling
• Free mental health counseling services
• Gym membership discounts and access to wellness programs
• Other employee discounts including entertainment, car rentals, cell phones, etc.
• Resources for child and elder care
• Plus many more!

Position Summary:

The Center for Health Care Data (CHCD) has a series of projects related to service contracts, outcomes research and research on population health and health outcomes. The Programmer Analyst II works with senior staff to create the coding required to extract data to support researcher questions. Responsible for analyzing datasets, developing program specifications, writing and maintaining programs, and coding and testing programs. This position encourages creative thinking and depends on the ability to work productively with a wide range of team members including data scientists, experienced programmers, biostatisticians and project managers, etc.

Position Key Accountabilities:

• Consults with and analyzes the users’ needs to ensure the programming and resulting data extract fulfills required needs.
• Analyzes/designs system flows and develops/codes program specification to ensure the agreed upon requirements are met.
• Writes, tests, and implements computer programs. Codes straight-forward to moderately complex programs and ensures that the programs conform to departmental standards
• Tests programming thoroughly to ensure all expected results are verified and discrepancies are resolved.
• Adheres to departmental standards to ensure the consistency of product produced.
• Participates in structured technical and functional walk-through with project team members and reports status of programming to team members/clients on a regular basis to ensure a full understanding of the program and the status of completion.
• Resolves problems that arise with existing data systems to ensure the efficiency and proper functioning of programs and systems.
• Other duties as assigned

Certification/Skills:

• Experience with SQL, statistical analysis programs such as SAS, R or STATA, preferred.
• Experience with one or more programming languages such as PL/SQL and Python, preferred.
• Familiarity with data modeling, Tableau, or healthcare privacy requirements, preferred.
• Knowledge of administrative healthcare claims, electronic medical records, social determinants of health datasets a plus.
• Strong analytical, problem-solving, and communication skills, required.

Minimum Education:

• Bachelor's Degree in Computer Science, related field or relevant experience in lieu of education required.

Minimum Experience:

• 2 years of programming experience required.

Physical Requirements:

Exerts up to 50 pounds of force occasionally and/or up to 20 pounds frequently and/or up to 10 pounds constantly to move objects.

Security Sensitive:

This position is a security-sensitive position pursuant to Texas Education Code

• 51.215 and Texas Government Code
• 411.094. To the extent that a position requires the holder to research, work on, or have access to critical infrastructure as defined in Texas Business and Commerce Code
• 117.001(2), the ability to maintain the security or integrity of the infrastructure is a minimum qualification to be hired for and to continue to be employed in that position. Personnel in such positions, and similarly situated state contractors, will be routinely reviewed to determine whether things such as criminal history or continuous connections to the government or political apparatus of a foreign adversary might prevent the applicant, employee, or contractor from being able to maintain the security or integrity of the infrastructure. A foreign adversary is a nation listed in 15 C.F.R.
• 791.4.

Residency Requirement:

Employees must permanently reside and work in the State of Texas.