ERS – Data Analyst

ERS is seeking a Data Analyst to perform routine to moderately complex data analysis and data research work for all ERS benefit programs within the Group Benefits Program, as well as for contracts managed by the Group Benefits Division. Work is performed under moderate to general supervision of the Data Science and Analytics team manager, with limited latitude for the use of initiative and independent judgment.

Requirements

• Performs Data Gathering and Analysis
• Performs data reporting and analysis for all ERS benefit programs
• Analyzes claim and premium experience on all insurance programs to determine financial integrity of each plan
• Researches benefit costs
• Reviews claims data to ensure benefits are processed correctly
• Prepares technical reports to help monitor the status of Accountable Care Organizations and other ERS initiatives
• Performs network analysis and develops reports to assist with management of GBP networks
• Researches business applications, methods and practices that may be applicable to the GBP
• Reconciles claims data to payments and researches discrepancies
• Researches techniques for monitoring and evaluating programs
• Assists with research to help determine the financial impact on issues that impact ERS benefit programs
• Assist in reviews of federal and state legislation for applicability to and impact on ERS benefit programs
• Assists in developing rates and contribution strategies by pulling reports and performing research for self-funded health, dental, vision, disability, and optional life plans
• Assists in the implementation of new technologies to enhance ERS policies and procedures with respect to benefit purchasing, implementation and administration
• Performs Financial Analysis and Reporting
• Prepares reports reflecting vendor credits, rebates and refunds expected and received
• Analyzes statistical and financial reports
• Prepares trend reports for all self-funded GBP programs
• Prepares rate spreadsheets, system text files and system load updates
• Assists in the preparation of agenda items and presentations to the ERS Board of Trustees
• Performs Data Visualization Reporting
• Assists in development of and maintaining data dashboards using tools such as Tabealu to create interactive visualizations in order to track metrics for GBP programs
• Assist in reviewing guidelines, procedures, rules and regulations and monitors compliance
• Assists in the development of contract values for governance reporting
• Assists in the development and review of procedures
• Assists in the calculation of vendor amounts at risk for performance guarantee assessments
• Attends work regularly in accordance with agency leave and attendance policies
• Complies with all applicable agency policies and procedures, including safety and standards of conduct
• Compiles routine statistical data
• Maintains security, privacy and confidentiality protocols
• Interprets results to identify significant differences in data
• Cleans and prunes data to discard irrelevant information
• Assist in preparing GeoAccess and similar reports
• Assist with Legislative Budget Board performance measures reporting
• Assists in developing methods for mitigating data issues and deploys those methods to correct issues
• Performs other duties as assigned

Benefits

• Flexible work schedules
• Competitive benefits
• Paid time off
• 401(k) matching
• Retirement plan
• Health insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Paid parental leave

Tagged as: Data Analysis