Position Summary:
The Employee Benefits Data Analyst plays a key role in supporting OVD Insurance clients by managing monthly reporting and transforming complex plan data into clear, actionable insights. This role analyzes medical plan costs, demographics, and other factors affecting the risk profile of select clients, evaluating financial performance and identifying trends, risks, and cost drivers, with the goal of proactively reducing the client's risk profile and overall costs. This is an evolving role that adapts to industry changes, client needs, and reporting requirements, and is expected to grow with the analytics function over time, including helping evaluate and/or implement new data and reporting tools and programs.
Location: Grand Rapids, MI
Work Model: Hybrid (3 days onsite & 2 days remote) in Grand Rapids, MI
Here's what you’ll do:
-
Retrieve claims reports from carriers and 3rd party data analytics vendors
-
Create and update monthly tracking reports for all self-funded and level-funded groups and larger fully insured groups.
- Provide analysis regarding any outliers in monthly reports that may affect risk/costs to agents and clients. Provide explanations and answer client/agent questions regarding reports and analyses.
-
Identify trends, risks, cost drivers, and utilization patterns impacting healthcare spend for assigned clients, and communicate findings clearly to agents, clients, and internal leadership
-
Review underwriting period claims and provide notice to agents if clients are likely to experience a significant increase at renewal.
-
Project renewal increases for agents based on current claims
-
Assist in reviewing renewals from carriers upon request, helping identify areas agents can use as negotiating points with the carrier to reduce renewals
-
Identify discrepancies between carrier and 3rd party data analytics vendors. Develop short-term solutions to correct discrepancies and collaborate with carriers and 3rd party data analytics providers to develop long-term solutions for eliminating them.
-
Perform other plan analyses upon agent request
-
Assist in evaluating and/or implementing new data analytics tools and reporting programs
Here’s what you’ll need:
-
Current Life, Accident, and Health Insurance Certification with the State of Michigan required, or willingness to obtain within 6 months of hire.
-
3+ Years of experience with medical plan analytics, underwriting, or reporting at an agency, medical carrier, or TPA
-
Strong Excel skills (ex. formula application and creation), with a willingness to build toward more advanced functionality
-
Ability to identify data accuracy concerns and proactively work to find long-term solutions to resolve them.
-
Ability to provide detailed work with a minimum of errors.
-
Solid understanding of the cost components of fully insured and self-funded health plans (e.g., premiums, claims, stop-loss, administrative fees, PBM costs).
-
Understanding of current technology and reporting systems, with a willingness to help evaluate other data analytics tools and programs.
-
Ability to work full-time in a hybrid capacity (management discretion) at the Grand Rapids facility
-
Strong oral and written communication skills, including the ability to translate “technical speak” in a way that end users at all levels can understand.
-
High energy work ethic with ability to work independently while maintaining excellent customer relationships.
-
Ability to work collaboratively with others.
-
Ability to work without direct supervision.
-
Regular and predictable attendance.
Core Competencies:
-
Accuracy: Achievement of correct and precise work.
-
Accountability: Acceptance of responsibility and one's own actions.
-
Written Communication: Ability to write letters, reports, articles, and e-mails using clear and concise vocabulary, style, grammar, and punctuation.
-
Customer Orientation: A desire to serve clients by focusing efforts on listening and responding effectively to customer questions, resolving customer problems to their satisfaction, and evaluating customer satisfaction.
-
Problem Solving: Ability to recognize courses of action which can be taken to handle problems or potential problems and applying contingency plans to solve those problems.
Work Environment & Physical Requirements:
The work environment and physical demands described here are representative of those that may be encountered and must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.
-
Ability to sit at a desk for an extended period.
-
While performing the duties of this job, the employee may be regularly required to stand, sit, talk, hear, reach, stoop, kneel, and use hands and fingers to operate a computer, telephone and keyboard.
-
Specific vision abilities required by this job include close vision requirements due to computer work and the ability to read and understand written word.
OVD Insurance is an Equal Opportunity Employer, including disability and veteran, that celebrates diversity and believes employing a diverse workforce is key to our success. We are committed to providing equal employment opportunities to all individuals. All applicants will be considered for employment without attention to race, color, religion, age, sex, sexual orientation, gender identity, national origin, veteran, or disability status.
To Executive Search Firms & Staffing Agencies: OVD Insurance does not accept unsolicited resumes from any agencies that have not signed a mutual service agreement. All unsolicited resumes will be considered OVD Insurance property, and OVD Insurance will not be obligated to pay a referral fee. This includes resumes submitted directly to Hiring Managers without contacting OVD Insurance Human Resources Talent Department.
We are not able to sponsor work visas for this position.
This job description does not list all duties of the job. Employees may be asked by management to perform other duties as needed. The Company reserves the right to revise this job description at any time. This job description is not a contract for employment and does not infringe upon the Company’s at-will employment status.
