Location:
1900 Aldrich Street
Austin, Texas, 78723
United States
Health Data Integrity Analyst or Associate
| Requisition ID: |
req1155 |
Employment Type: |
Unclassified Regular Full-Time (URF) |
| Division: |
Health Analytics |
Compensation: |
Depends on Qualifications |
| Location: |
Alpha Building |
Job Closing: |
11/15/2024 5:00pm |
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 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.
The Health Data Integrity Analyst or Associate is responsible for performing a mix of data integrity, governance, and analytic work. The incumbent will analyze 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 a primarily remote position that will occasionally require the selected applicant to report to the TRS offices, located in Austin, TX, based on business needs. All applicants must reside in the state of Texas upon employment and continue to reside in Texas throughout employment with TRS.
Position posted at two levels (Health Data Integrity Analyst Associate and Health Data Integrity Analyst). Selected applicant will be offered the position level that most closely matches their education and experience.
Starting Salary information
Health Data Integrity Analyst Associate: $62,113 - $77,640 annually
Health Data Integrity Analyst: $73,790 – $92,237 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.
• 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.
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.
• 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
• One (1) year 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.
• 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. (Health Data Integrity Analyst)
• 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
• Basic 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.
