Health Data Integrity Analyst

Teacher Retirement System of Texas (TRS)•Austin, TX

1d•$73,790 - $117,188•Onsite

About The Position

The Health Data Integrity Analyst performs data integrity, governance, and analytical work for the Health Division. The role analyzes health claims and related data to ensure internal products and external reports are accurate; tests ingestion of new data sources; investigates data integrity issues and helps develop solutions; maps new data sources; and maintains documentation, including a data dictionary for analysts. The position works proactively with external vendors, TRS IT, analysts, actuaries, and agency staff. The position is posted at two levels: Health Data Integrity Analyst and Health Data Integrity Analyst Senior. The selected applicant will be offered the level that most closely matches their education and experience. Starting salaries are $73,790–$96,849 annually for the Analyst level and $89,286–$117,188 annually for the Senior level; compensation depends on qualifications. The role is based at TRS Headquarters Building 2 in Austin, Texas.

Requirements

Bachelor’s degree from an accredited college or university in accounting, finance, mathematics, statistics, business, healthcare administration, economics, or a closely related field; alternatively, a high school diploma or equivalent plus additional full-time related experience may be substituted year for year.
At least three years of full-time, directly related, progressively responsible experience analyzing healthcare claims or financial data, administering a health insurance plan, or in similarly related work.
For the Senior level, at least five years of full-time, directly related, progressively responsible experience analyzing healthcare claims or financial data, administering a health insurance plan, or in similarly related work.
A master’s or doctoral degree in a directly related field may be substituted for experience on an equivalent year-for-year basis.
Knowledge of data warehouse concepts, SQL query writing, ETL workflows, and using SQL queries to monitor and investigate data-quality issues.
Skill in completing detailed work accurately; managing projects and prioritizing assignments in a fast-paced, changing environment; communicating complex information clearly and actionably to diverse business users; and using a personal computer and business software such as Microsoft Word, Excel, and Outlook, including spreadsheets for analysis and presentation.
Ability to think critically, analyze problems, evaluate alternatives, and recommend effective solutions with attention to detail; meet frequent deadlines and manage competing priorities while adapting to changes; and maintain effective professional relationships with coworkers, agency staff, vendors, and other external contacts.

Nice To Haves

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 analysts to develop solutions and test data in a data warehouse.
Experience working with HIPAA data and following regulations and best practices for the use and sharing of ePHI and PII.
Experience communicating data to decision-makers to support business or policy decisions.

Responsibilities

Analyze enrollment, claims, utilization, and other healthcare data to identify and resolve data-quality issues and investigate anomalies.
Validate new file extracts, confirm business requirements are met, and ensure reports are delivered to appropriate external entities.
Support and facilitate data-governance meetings and working sessions.
Document data-quality requirements, verification and testing approaches, and processes, including automated ETL validation and verification steps.
Communicate with vendors to investigate and resolve data-integrity questions and manage complex data-related projects.
Maintain data dictionaries and documentation for data warehouse users, including data mappings, transformation rules, and business definitions.
Help evaluate Health Division business needs related to reporting tools and data sources and assess vendor service proposals.
Perform root-cause analysis to identify data gaps and recommend solutions.
Develop queries to extract data for decision-making.
For the Senior level, develop and automate queries used in spreadsheets, models, dashboards, and summaries.
Research, recommend, and implement methods for reporting healthcare data and statistics, including program-activity key performance indicators.
Identify, collect, and analyze data for reports, briefings, and presentations.
Communicate and present data-driven insights to cross-functional teams and leadership.
For the Senior level, review and validate reports, participate in data-quality improvement initiatives, and evaluate Health Division business needs related to health data integrity.
Develop Power BI visualizations and analyses using business models and DAX measures to identify trends and support executive insight into health plans.
Create DAX measures in tabular models that integrate complex healthcare data.
For the Senior level, develop models, scorecards, dashboards, and other quantitative analytical tools, and prepare, present, or distribute routine and ad hoc reports.
Perform related work as assigned.