Health Data Integrity Analyst

Teacher Retirement System of Texas•Austin, TX

21h•Onsite

About The Position

The Health Data Integrity Analyst performs data integrity, governance, and analytics work for the Health Division. The role analyzes complex 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. The listed annual salary ranges are $73,790–$96,849 for the Analyst level and $89,286–$117,188 for the Senior level, dependent on qualifications. The role includes analyzing enrollment, claims, utilization, and other healthcare data; validating file extracts and reporting requirements; supporting data governance sessions; documenting data-quality and ETL testing processes; resolving data-related questions with vendors; maintaining data warehouse documentation; developing queries and reporting methodologies; and creating Power BI visualizations, models, and dashboards. Senior-level duties additionally include automating queries, reviewing reports, participating in data-quality initiatives, and developing analytical tools and reports. The Health Division works to improve healthcare delivery for active and retired Texas public educators. TRS describes a culture of continuous learning, front-line decision-making, coaching, mentorship, innovation, and collaboration.

Requirements

Bachelor’s degree from an accredited college or university in accounting, finance, mathematics, statistics, business, healthcare administration, economics, or a closely related field.
A high school diploma or equivalent plus additional full-time experience analyzing healthcare claims or financial data, administering a health insurance plan, or similarly related experience may substitute for the degree on an equivalent year-for-year basis.
Three years of full-time, directly related, progressively responsible experience analyzing healthcare claims data or financial data, administering a health insurance plan, or similarly related experience.
For the Senior level, five years of full-time, directly related, progressively responsible experience in the stated areas.
A master’s or doctoral degree in a directly related field may substitute for experience on an equivalent year-for-year basis.
Knowledge of data warehouse concepts and writing SQL queries.
Knowledge of Extraction, Transformation, and Loading (ETL) workflows.
Skill in writing SQL queries to monitor and investigate data-quality issues.
Ability to complete detailed work accurately.
Ability to manage projects and organize and prioritize assignments in a fast-paced, changing environment.
Ability to communicate complex information to varied business users in accurate, concise, and actionable language.
Ability to use a personal computer and business software, including Microsoft Word, Excel, and Outlook, and to use spreadsheets for data analysis and presentation.
Ability to think critically, analyze problems, evaluate alternatives, and recommend effective solutions with attention to detail.
Ability to meet frequent deadlines, manage competing priorities and demands, and adapt to changing assignments.
Ability to establish and maintain professional working relationships with coworkers, agency staff, vendors, and other external contacts, and to work effectively on a team.

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 data 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.
Investigate data anomalies and perform root-cause analysis to identify data gaps and recommend solutions.
Validate new file extracts, verify that 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 automated ETL validation and verification processes.
Communicate with vendors to investigate and resolve data-integrity questions and manage complex data-related projects.
Maintain the data dictionary and data warehouse documentation, including data mappings, transformation rules, and business definitions.
Help evaluate Health Division business needs related to reporting tools and data sources and assess vendor proposals.
Develop queries to extract data for decision-making.
Research, recommend, and implement methodologies 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.
Develop Power BI visualizations and analyses using business models and DAX measures to identify trends and provide insight into health plans.
Create DAX measures in tabular models that integrate complex healthcare data.
For the Senior level, automate queries for spreadsheets, models, dashboards, and summaries; review and validate reports; participate in data-quality improvement initiatives; evaluate Health Division needs related to health data integrity; develop models, scorecards, dashboards, and other quantitative tools; and prepare, present, or distribute routine and ad hoc reports.
Perform related work as assigned.