Job description
Overview:
Propel is looking for a Data Analyst to join their team!
Are you looking to be part of a company where you have exciting opportunities to learn, grow and make a positive impact?
If that is what you’re looking for, this is your chance to be part of an amazing organization!
Under supervision of the Analytics Team Manager, the Data Analyst position primarily maintains a range of technical client deliverables for the Sales Executive/Consultant and the Account Management teams. The Data Analyst also works on ad hoc reporting and requests, assisting with more technical tasks, and acting as a client facing plan expert. Other common responsibilities include communication with carrier and vendor partners to negotiate quotes for coverage, and secure competitive pricing. Experience in the insurance industry, and specifically Employee Benefits, is highly desired.
Responsibilities:
If you're a California resident, please read the California Consumer Privacy Act prior to applying.
#pandoIQ
Propel is looking for a Data Analyst to join their team!
Are you looking to be part of a company where you have exciting opportunities to learn, grow and make a positive impact?
Join a team where each employee is empowered to listen generously, speak straight, collaborate, and build each other up through mutual accountability and shared success?
If that is what you’re looking for, this is your chance to be part of an amazing organization!
Under supervision of the Analytics Team Manager, the Data Analyst position primarily maintains a range of technical client deliverables for the Sales Executive/Consultant and the Account Management teams. The Data Analyst also works on ad hoc reporting and requests, assisting with more technical tasks, and acting as a client facing plan expert. Other common responsibilities include communication with carrier and vendor partners to negotiate quotes for coverage, and secure competitive pricing. Experience in the insurance industry, and specifically Employee Benefits, is highly desired.
Responsibilities:
- Generate new and first time client initial deliverables
- Roll over existing client templates to new plan years / structures
- Provide monthly / quarterly client utilization, experience and financial reporting for the largest and most complex clients
- Make adjustments to report inputs and visuals as needed
- Generate custom contribution models
- Analyze funding arrangements, including fully insured, self-insured, and level-funding
- Prepare and create ASO spreads for self-funded plans
- Create fully insured equivalents for self-funded plans
- Generate benchmarking and trend analysis
- Project client renewals and advise on overall client position
- Negotiate with incumbent and bidding carriers to ensure most competitive rates and products for clients and prospective clients
- Provide client deliverable feedback in client facing team calls and monthly / quarterly / annual emails communications
- Track and store workflow in ImageRight
- Remain current on industry trends and information, new product development, legislation, coverages, and online technology systems (e.g. carrier websites)
- Participate in meetings, industry seminars and training programs
- Provide training and act as a resource for the Employee Benefits department
- 3-5 years in the Employee Benefits industry
- Four year degree; preferably focused on mathematical field
- Minimum 1 year in an excel intensive technical role
- Proficiency with Microsoft Excel in creating and working with pivot tables, complex charts / formulas, large datasets, and data visualization
- Knowledge of ImageRight / Benefit Point / Springbuk / Deerwalk / Domo a plus
- Analytical, able to analyze claims data, compare quotes and have accuracy and decisiveness
- Strong organizational, verbal and written communications skills
We're an
equal opportunity employer
. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
If you're a California resident, please read the California Consumer Privacy Act prior to applying.
#pandoIQ
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.