Job description
Welcome to ivari
Let us introduce ourselves. With 300 employees across Canada, ivari is a company that’s making a difference in the world of life insurance. How? By finding and hiring employees who are passionate about helping people protect their families, and by giving them the best, most supportive workplace possible.
At ivari, everyone is welcome! It is our mission to attract, develop, and retain a workforce that is as diverse as the customers we serve and the communities in which we do business. We offer an inclusive and accessible work environment where all employees and customers feel valued, respected, and supported.
Here’s the job opportunity…
As a Product Data Analyst at ivari, you are primarily responsible for handling the Life Special Quote mailbox and providing data analytics from internal and external data. The reports you provide to management reflect ongoing market activities and identify product opportunities. In this role you will:
- Handle and track life special quotes email box which includes complex manual calculations, analysis and escalations.
- Generate and reconcile Excel files, create templates, tables using SQL for Quarterly and Annual LIMRA surveys
- Generate Excel or PowerPoint reports/summaries from LIMRA survey results
- Document processes as required
- Complete analysis of data and reconcile with internal sales reports
- Advanced Excel knowledge for adhoc reports
- Support operational and in-force process issues including system requirements to support inforce and legacy products when required.
- Work with Product managers & Pricing department when required for product intiatives
- Assist information technology departments or other business units when required for projects, such as data clean up, excel support from queries.
What we are looking for…
- Minimum 5 years work experience in a data analytics or similar function in the life insurance industry
- Post-Secondary Degree in Actuarial Science, Computer Science or another related field
- Knowledge of Life insurance products, Contracts and Systems
- Advanced knowledge of Excel formulas (Offset, Index, Match) and queries Power BI, VBA, Infomaker, Access, PowerPoint
- Proficient in executing queries and creating tables (implicit and explicit variables, transformation commands)
- Self-motivated independent worker who takes initiative
- Analytical and problem-solving capabilities
- Strong organizational skills and attention to detail
- Ability to function in a rapidly changing and demanding environment while managing multiple initiatives simultaneously is a must
- Experience in business analysis is an asset
- French as a second language would be an asset
What's in it for you
At ivari, it's important for us to keep our people motivated, recognized and rewarded. We offer competitive base salaries plus a bonus, one of the many reasons ivari is a great place to work.
We also offer health and dental benefits for the entire family from Day 1! But that’s just the beginning. When you join the ivari team you also get…
- A fantastic vacation plan and time off
- A pension plan with 100% match by ivari
- Employee savings plan with 75% match to help you save even more
- Flexible and hybrid work arrangements
- Opportunities for professional development
- Recognition programs to cheer you on, motivate and reward
- Wellness programs to keep you healthy and happy
Who you are…
Someone who enjoys a culture where everyone is genuinely respectful and you can be your authentic self every day. Your contributions and opinions are not only sought, but valued. You know the importance of, and live by, our core values of…
- Bringing clarity and focus to your work
- Taking ownership and doing what you say you will
- Remaining flexible
- Collaborating with others
Does this sound like you? We’re looking for great people to join our team!
Our commitment to inclusivity is reflected in the safeguards, policies and commitments we have in place to remove barriers and provide equal opportunities to prospective and current employees, without discrimination.
To apply, please email your resume to: [email protected]
A Human Resources representative is available to consult with applicants who require accommodation in the application or recruitment process. Any information shared by the applicant about an accommodation will be treated as confidential. If you do require an accommodation, please email [email protected].
About ivari
CEO: Todd Lawrence
Revenue: Unknown / Non-Applicable
Size: 501 to 1000 Employees
Type: Company - Private
Website: www.ivari.ca