| Position Title: | Benefits Data Analyst (Sr. Benefits Consultant) |
| Date Posted: | September 29, 2017 |
| Job Location: | Milwaukee |
| Company Name: | The Medical College of Wisconsin |
| Contact: | Joanne Krueger 8701 Watertown Plank Road Milwaukee , WI 53226 jokrueger@mcw.edu www.mcw.edu |
| Description: | Purpose The Benefits Data Analyst/Underwriter performs a variety of professional, technical and analytical duties in support of the employee benefits programs for our organization. Incumbent will assist the Benefits Manager to plan, analyze, and design MCW’s employee benefits programs in line with our benefits strategy and participants needs. Data analysis of benefit plan claims, utilization and trends along with regulatory compliance is the primary focus of this role. Primary Functions 1. Analyzes participation and utilization for all benefits on a monthly, quarterly, and annual basis. Analyzes benefits experience for cost-control and risk-assessment factors. Uses data to monitor trends and recommend initiatives, benefit plan changes, vendor changes, and cost sharing. 2. Analyzes in-network provider utilization to identify gaps in provider network, appropriate discount arrangements and inappropriate utilization for use during the contract negotiation process with network providers and facilities. 3. Analyze historical claims data to provide cost or savings projections of plan design changes. Coordinate with MCW’s Insurance Broker the calculation of renewal rates for self-insured health and welfare plans based on analysis of claim experience, industry and demographics. 4. Review, maintain and recommend changes to all MCW benefits policies ensuring compliance with state and federal regulations. 5. Performs statistical, cost and financial analysis of data extracted from various sources. Prepares reports based on findings, including health care costs, healthcare trends, provider contracts, plan design changes and regulatory changes. 6. Serve as a project manager to facilitate plan changes, compliance requirements, and annual total compensation statements. Prepare an annual Compliance Calendar and manage to completion. Perform plan and/or benefits system testing. 7. Tracks year over year annual benefit plan expenses, compares overall benefits program cost to benchmark data 8. Other duties as assigned. Knowledge – Skills – Abilities
Organizational Structure Building: Research Park Department: Human Resources Division: Benefits Reports to (Title): Benefits Manager Direct Reports (Titles): None Collaborates with (Titles): Benefits team, Data Analytics team, HRIS team Specifications Appropriate education and/or experience may be substituted on equivalent basis Minimum Required Education: Bachelor’s Degree Minimum Required Experience: 5+ years of experience Preferred Education: NA Preferred Experience: Insurance, Underwriting, Data Analytics, Research Field: Mathematics, Finance, or other related technical field Certification: |
Serving communities throughout Wisconsin including Appleton, Eau Claire, Green Bay, La Crosse, Madison, Milwaukee, and many more.
