ERS - Data Analyst

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=107759andPostingSeq=1Job DescriptionOur mission is simply stated: ERS offers competitive benefits to enhance the lives of its members. Each team member across the agency contributes to our ongoing success. ERS is open for business five days a week, 8:00 am to 5:00 pm, to meet customers where they need us: in person, on the phone, in their communities, and online. ERS currently offers opportunities that include flexible work schedules.ERS does not sponsor or assume sponsorship of an employment visa at any time.ERS is seeking a Data Analyst to perform routine to moderately complex (journey level) 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.Essential Responsibilities include, but are not limited to: Performs Data Gathering and AnalysisPerforms data reporting and analysis for all ERS benefit programs; insurance, flexible benefits, Medicare Part D and actuarial consulting.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 discrepanciesResearches 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 ReportingPrepares 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 ReportingAssists in development of and maintaining data dashboards using tools such as Tableau to create interactive visualizations in order to track metrics for GBP programsAssist 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.Other Duties and Responsibilities: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 ith 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.Data Analyst III performs all essential functions of the Data Analyst II role, in addition to the following:Identify and interpret data patterns and trends and assess data quality. Prepare concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.Required Minimum Qualifications: application for employment must reflect how you meet each of the following minimum qualifications:Graduation from an accredited four-year college or university with a degree in science, mathematics, or similar analytic field. Qualifying experience beyond the minimum required may substitute for education.Two (2) to three (3) years (depending on classification level) of work experience in data or statistical analysis. Preferred Qualifications: Your application for employment should reflect how you meet the following preferred qualifications:Data analysis experience in healthcare industry, insurance or employee benefits administration, especially with large group plans. Experience with statistical software such as Microsoft SQL Server, R, and Tableau.PLEASE NOTE: All submissions should contain complete job history entries, which includes job title, dates of employment, name of employer, and a description of duties performed as related to the position you are applying for. Resumes lacking sufficient detail, such as a summary of experience in lieu of progression of work history may not meet minimum qualifications.Other Information: In accordance with state law, authorization for telework may not be awarded to an employee as a condition of hiring. As an agency process, new employees complete a 30 day fully onsite period before evaluation for a telework agreement. This position may require access to privileged, confiden