Health Data Visualization Analyst

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

68d•$73,790 - $111,608•Onsite

About The Position

The Health Data Visualization Analyst is responsible for performing data visualization, analysis and reporting work to ensure that TRS can effectively communicate complex information regarding its health care programs. The incumbent will analyze complex data sources, develop effective data visualizations and stories, and collaborate with a variety of professionals to ensure the accuracy and effectiveness of data related communications. This position will proactively work with the Health Data Analytics team, Health Division staff, and agency employees. This onsite position in Austin, Texas will be filled at one of two levels - Health Data Visualization Analyst or Senior Health Data Visualization Analyst. The selected candidate will be offered the position level that most closely matches their education and experience.

Requirements

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.
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.
Best practices associated with data visualization.
Data analysis concepts and methods, including education equivalent to at least statistics for business.
Health benefit claims processing, Medicare, coordination of benefits, standard medical procedures, and billing.
Health care metrics related to cost and quality.
Effective written and verbal communication of complex information to people of varying backgrounds, including organizing and writing various types of communications and business materials; and drafting and delivering complex correspondence, reports, presentations, and proposals.
Managing projects, including planning, organizing, and prioritizing work assignments to manage a high-volume workload in a fast-paced and changing environment.
Researching, compiling and analyzing complex health care related data.
Thinking critically, analyzing problems, evaluating alternatives, and recommending effective solutions.
Completing detailed work with a high degree of accuracy.
Utilizing a personal computer and various business software programs including Microsoft Word, Excel, and Outlook, including using spreadsheets for data analysis and presentation.
Interpreting and applying complex laws, regulations, policies, and procedures.
Establish and maintain harmonious working relationships with co-workers, agency staff, and external contacts.
Work effectively in a professional team environment.
Work with large, highly-complex data sets and understand to convey key insights to a wide variety of audiences using accessible visualizations and reporting.
Learn new software tools, coding techniques, and industry related concepts.

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.