Health Data Visualization Analyst

Summary: The Teacher Retirement System of Texas is committed to driving high-quality healthcare for Texas public educators. The Health Data Visualization Analyst will perform data visualization, analysis, and reporting to effectively communicate complex information regarding healthcare programs. Responsibilities: - Develops high-visibility presentations, reports, and briefings to executive leadership, the TRS Board of Trustees and legislative stakeholders, including narratives and talking-points to help explain and contextualize data and TRS programs - Develops and creates models, scorecards, dashboards, and other quantitative analytical tools based on a thorough understanding of business and industry requirements - (Senior) Coordinates with data analysts, actuaries, and communications staff to produce data needed to effectively convey insights - Produces accessible, actionable, and timely data visualizations to promote effective decision and shared understanding among a large and varied set of audiences - Helps design and implement data visualizations for internal plan management, including dashboards and reports related to changes in utilization and enrollment - Coordinates and develops complex reporting for school districts in collaboration with other TRS staff - Prepares, presents, and/or distributes routine and ad hoc reports - Helps organize key assets, including charts, reports, and data summaries, to ensure accessibility for providing timely and consistent answers to requests - 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 - Participates in efforts to benchmark TRS program with comparators and peers including large employers, school districts, and state group health programs - Helps identify data quality issues and participate in initiatives to improve data quality - Assists with evaluating the Health Division's business needs related to reporting tools and assessing vendors proposals for data analysis services - Assists in the tracking of legislation and legislative requests and cost estimation for legislative fiscal notes - Conducts research to help identify solutions to achieve program goals - May assist with preparation professional papers or reports - Reviews and analyzes various routine vendor reports on a monthly, quarterly, and annual basis - Participates on special projects, task forces, and committees as needed - Develops and maintains business data model in analysis server tabular models for use with PowerBI - Design and maintain data ingestion process to move data from data warehouse into tabular model - Create measures using DAX code in tabular model that integrate highly complex health care data, including risk scores, enrollment, claims data, and other data sources to build measures that reduce the time-to-insight across high volumes of data - Develop visualizations and analysis in PowerBI dashboards using business model and DAX measures to identify key trends and facilitate executive insight into health plans - Performs related work as assigned Required Qualifications: - 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 - 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 and visualizing health care claims data or financial data, administration of a health insurance plan or similarly related experience. (Senior Health Data Visualization 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 using software such as Adobe Illustrator, Excel, PowerPoint, R, and PowerBI to develop data visualizations - Knowledge of best practices for designing data visualizations and crafting data-related narratives - Experience with SQL and data analytic software such as R, Python, Excel, and/or PowerBI - Experience communicating data to decision makers to facilitate business and/or policy decisions - Knowledge of the U.S. health care industry and concepts relevant to purchasers/insurers such as deductibles, actuarial value, risk scores, quality measures, and payment strategies for pharmacy benefits - Experience working with the Texas Legislature - Advanced degree with quantitative focus Required Skills: Data visualization, PowerBI, DAX, SQL, R programming, Python programming, Excel, Adobe Illustrator, Health care claims data analysis, Health care financial data analysis, Health insurance plan administration, Health care industry knowledge, Data modeling, Effective written communication, Project management