Health Finance Data Analytics Student Intern

WHO WE ARE:

With the Health & Insurance Benefits Division, you’ll be joining a passionate team of self-motivated change agents united by our mission: driving to design the delivery of high-quality healthcare for nearly three-quarters of a million active and retired Texas public educators.

The healthcare industry is complex and we’re a team of problem-solvers who are up for the challenge. With a focus on innovation and collaboration to catalyze the market, we spend nearly $4 billion annually on healthcare to make a difference in our members’ lives. With a career at TRS, you’ll be empowered through a culture of continuous learning, front-line decision-making, coaching and mentorship to shape the future of our work, while transforming healthcare delivery for 1 in 41 Texans.

Internship: This position is a paid, full-time, limited term assignment that offers interns the opportunity to gain substantive hands on experience. Interns enjoy the opportunity to get training and mentoring from experienced professionals in one or more areas. Interns may also be eligible to continue working part-time through the fall and spring semesters, depending on department and agency needs.
 

The Health Finance Data Analytics Student Intern will help the Health Division at TRS meet its goal of harnessing its data to optimize its health management strategies, identify actionable patterns in health care claims, and assess areas where interventions could add value and produce better health outcomes. The incumbent will performs entry level project work related to their field of study and analyzing health care/insurance related data., and support agency operations with a primary focus on gaining practical work experience and business skills for personal development or to satisfy educational requirements. This position will proactively work with the Health Finance team, Health staff, and agency employees.
 

This position will start on June 4th 2025 and will end in August 8th 2025.
Salary will be dependent upon education level:
Graduate Student - $25.00/hour
 

WHAT YOU WILL DO:
Health Insurance Analytics Projects
• Analyzes enrollment and claims data to identify trends and anomalies and to identify areas of action.
• Develop and automate SQL queries in our internal data warehouse to extract claim data for use in analyses and dashboards.
• Assists in the production of analytical reports and presentations for internal stakeholders, including creating visualizations and drafting narrative.
• Develops a summary document describing the data and document data limitations and nuances to enhance analysis and reporting.
• Review and validate reporting of health care data from external sources including from TRS' health care consultants, insurance companies, or other industry resources.
• Conduct surveys and assessments of vendor activities to evaluate performance.
General Functions
• May assist in researching, compiling, and analyzing data; entering data into spreadsheets, databases, and other automated applications; and preparing complex queries and reports.
• May review forms, correspondence, reports, and other documents for completeness and acceptability
• May assist in reviewing and analyzing agency policies, procedures, and forms and recommending changes to improve efficiency and effectiveness.
• Assists in completing special projects and performs other work as assigned.

• Performs related work as assigned.

WHAT YOU WILL BRING:
Required Education
• Currently enrolled as a graduate student (Master or Doctoral) in public health, actuarial science, mathematics, statistics, economics, data science, informatics or a related program
• Applicant will be required to submit a copy of official college transcripts.
Required Experience
• None.
Required Registration, Certification, or Licensure
• None.
Preferred Qualifications
• Experience with SQL, R, and R Markdown, and a general aptitude for programming is needed.
• Experience working on similar projects to the ones described above.
• Letter(s) of recommendation from program professor(s) are strongly encouraged.
• Experience using Microsoft Office software.
• Experience creating data visualizations to explain complex data to broad audiences using a variety of tools.

Knowledge, Skills, and Abilities
Knowledge of:
• General office practices and procedures.
• General health insurance terminology and definitions.
• Research and data analysis techniques.
Skills in:
• Organizing and prioritizing work to manage a high-volume workload in a fast-paced environment and completing work accurately while meeting deadlines.
• Conducting data searches and evaluations of large amounts of information, performing complex analysis of the data, and preparing concise and accurate reports and written/oral recommendations.
• Verbal and written communication of complex information that is accurate, timely, and based on sound judgment.
• Providing quality customer service.
• Reviewing documentation; properly applying complex laws, regulations, rules, and policies; and making decisions based on sound judgment.
• Using a personal computer in a Windows and Microsoft Office (Word, Excel) environment, and accurately performing data entry.
Ability to:
• Establish and maintain harmonious working relationships with co-workers, agency staff, and other external contacts.
• Work effectively in a professional team environment

Military Occupational Specialty (MOS) Codes:
Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty ( http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_AdministrativeSupport.pdf ) along with the minimum qualifications listed above may meet the minimum requirements and are highly encouraged to apply. Please contact Talent Acquisition at  careers@trs.texas.gov  with questions or for additional information.

To view all job vacancies, visit www.trs.texas.gov/careers  or www.trs.csod.com/careersite.

For more information, visit www.trs.texas.gov.