Job Description

Health Data Integrity Analyst

Requisition ID: req1477

Employment Type: Unclassified Regular Full-Time (URF)

Division: Health

Compensation: Dependent on qualifications

Job Closing: 11/18/2026, 11:59PM CT

Location: TRS Headquarters Building 2

1900 Aldrich Street

Austin, Texas, 78723

United States

WHO WE ARE:

With the Health 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 more than $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.

The Health Data Integrity Analyst is responsible for performing a mix of data integrity, governance, and analytic work. The incumbent will analyze complex data health claims data to ensure that internal products and external reports are accurate, test the ingestion of new data sources, investigate and help develop solutions to data integrity issues, map new data sources, and maintain documentation including a data dictionary for analysts. This position will proactively work with external vendors, TRS IT, analysts, actuaries and agency staff.This position is posted at two levels (Health Data Integrity Analyst and Health Data Integrity Analyst Senior). Selected applicant will be offered the position level that most closely matches their education and experience.

Starting Salary information

Health Data Integrity Analyst: $73,790 - $96,849 annually

Health Data Integrity Analyst Senior: $89,286 – $117,188 annually WHAT YOU WILL DO:Data Integrity and Governance

• Analyzes detailed enrollment, claim, utilization and other health care related data to identify and resolve data quality issues. Conducts analysis to investigate anomalies in data.
• Validates new file extracts and ensures that business requirements have been met and reports are delivered to appropriate external entities.
• Provides support to manage and facilitate data governance meetings and working sessions.
• Documents requirements for data quality, verification, and test approaches and processes, including automated validation and verification steps of ETL processing needed.
• Communicates with vendors to investigate and resolve questions related to data integrity and manage complex data related projects.
• Maintains data dictionary and documentation for data warehouse users that captures data mapping, transformation rules and business definitions.
• Assists with evaluating the Health Division's business needs related to reporting tools and data sources and assessing vendors proposals for services.
• Perform root-cause analysis to identify data gaps and recommend solutions.

Data Analysis

• Develops queries to extract data to support decision-making.
• Develops and automates queries to extract data use in spreadsheets, models, dashboards, and summaries to support decision-making. (Senior)
• Researches, recommends, and implements methodologies for reporting health care data and statistics including key performance indicators for program activities.
• Identifies, collects, and analyzes data needed to develop reports, briefings, and presentations.
• Communicate and present data-driven insights to cross functional teams and leadership.
• Reviews and validates reports. (Senior)
• Identifies data quality issues and participate in initiatives to improve data quality. (Senior)
• Evaluates the Health Division's business needs related to health data integrity. (Senior)

Complex data modelling and dashboard development

• Develop visualizations and analysis in PowerBI dashboards using business model and DAX measures to identify key trends and facilitate executive insight into health plans.
• Create measures using DAX code in tabular model that integrate highly complex health care data.
• Develops and creates models, scorecards, dashboards, and other quantitative analytical tools. (Senior)
• Prepares, presents, and/or distributes routine and ad hoc reports. (Senior)

Performs related work as assigned.

WHAT YOU WILL BRING:

Required Education

• Bachelor’s degree from an accredited college or university in accounting, finance, mathematics, statistics, business, health care administration, economics or a closely related field.
• High school diploma or equivalent and additional full-time experience in analyzing and visualizing health care claims data or financial data, administration of a health insurance plan or similarly related experience may be substituted on an equivalent year-for-year basis.

Required Experience

• Three (3) years of full-time directly related, progressively responsible experience in analyzing health care claims data or financial data, administration of a health insurance plan or similarly related experience.
• Five (5) years of full-time directly related, progressively responsible experience in analyzing health care claims data or financial data, administration of a health insurance plan or similarly related experience. (Senior)
• A master's degree or doctoral degree in a directly related field may be substituted on an equivalent year-for-year basis.

Preferred Qualifications

• Experience working with healthcare claims data using advanced SQL
• Experience developing automated data quality testing frameworks and outlier analysis.
• Experience working with data engineers and data analysts to develop solutions and test data in a data warehouse
• Working with HIPAA data, following regulations and best practices surrounding the use and sharing of ePHI and PII
• Experience communicating data to decision makers to facilitate business and/or policy decisions.

Knowledge of

• Concepts related to data warehouses and writing queries using SQL
• Concepts related to Extraction, Transformation, and Loading (ETL) workflows
• Writing SQL queries to monitor and investigate data quality issues

Skill in

• Completing detailed work with a high degree of accuracy.
• Managing projects, including planning, organizing, and prioritizing work assignments to manage work in a fast-paced and changing environment.
• Communicating detailed and complex information to a variety of business users with accurate, concise, and actionable language.
• Utilizing a personal computer and various business software programs including Microsoft Word, Excel, and Outlook; including using spreadsheets for data analysis and presentation.

Ability to

• Think critically, analyze problems, evaluate alternatives, and recommend effective solutions with a high level of attention to detail.
• Meet frequent and multiple deadlines, manage conflicting priorities and demands, and adapt to changes in assignments.
• Establish and maintain harmonious working relationships with co-workers, agency staff, vendors and other external contacts and to work effectively in a professional team environment.

Military Occupational Specialty (MOS) Codes:

Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty ( https://www.trs.texas.gov/files/trs-military-crosswalk.xlsx ) 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.