Health Data Integrity Analyst

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.