- Analyze and interpret large and complex datasets to identify trends, risks, opportunities, and actionable insights for clients and internal stakeholders.
- Develop, maintain, and enhance reporting tools, dashboards, and data models using Excel, Power Query, and other analytical tools.
- Assist with the development and continuous improvement of underwriting tools, processes, reporting automation, and data management practices.
- Gain familiarity with pricing analysis and evaluating new business opportunities through TPA channels in order to be able to maintain and improve existing quote tools.
- Analyze claims experience, demographic data, financial results, and carrier proposals to develop recommendations and support strategic decision-making.
- Collaborate with carriers, consultants, Account Managers, brokers, and internal teams to gather data and ensure accurate underwriting outcomes.
- Identify plan performance, claims trends, and reporting issues, and recommend solutions to internal stakeholders.
- Prepare renewal analysis and reporting packages, including support for insurer negotiations.
- Support new sales initiatives and revenue growth objectives through data-driven analysis and underwriting expertise.
- Provide underwriting and analytical consulting services to various stakeholders.
- Maintain effective working relationships with insurers, Plan Sponsors, Plan Administrators, consultants, and internal partners.
- Post-secondary education in Mathematics, Statistics, Economics, Finance, Actuarial Science, Business Analytics, or a related discipline; equivalent experience will also be considered.
- 3–5 years of experience in underwriting, insurance, group benefits, financial analysis, or a similar analytical role.
- Advanced proficiency in Microsoft Excel, including Pivot Tables, advanced formulas, data analysis, and data clean up techniques.
- Experience using Power Query to transform, validate, and automate data processes.
- Experience with VBA or other automation tools is considered a strong asset.
- Demonstrated experience working with large datasets and producing insightful reports, analyses, and recommendations.
- Strong analytical, problem-solving, and critical-thinking skills with a high degree of accuracy and attention to detail.
- Ability to interpret complex data and communicate findings clearly to both technical and non-technical audiences.
- Strong organizational skills and the ability to manage multiple priorities and deadlines.
- Effective verbal and written communication skills.
- Strong collaboration and teamwork skills, including the ability to work across departments and with external partners.
- Knowledge of group benefits, underwriting principles, and/or the insurance industry is an asset.
- GBA designation or progress toward a professional industry designation is an asset.
Learn by working alongside our experts
Extended health care and dental benefits
A retirement savings plan with company contributions
A suite of Health & Wellness offerings
Mental Health programs and support for you and your family
Competitive compensation
At People Corporation we are committed to helping businesses succeed. We are a national provider of benefits, retirement, wealth, wellness, and human resource solutions. Our experts and solutions serve over 20,000 clients representing nearly 3 million Canadians. We offer customized solutions designed to fit the unique needs of businesses and their employees, members and stakeholders.
Providing an inclusive, accessible environment, where all employees and clients feel valued, respected and supported is something we're committed to. We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employee has the opportunity to reach their potential. If you require an accommodation or an alternative format of any posting please reach out to [email protected]
The base salary range for this position is $65,000 - $80,000 per annum.
This represents base salary only and does not represent other variable compensation components of our total compensation ( i.e. annual bonus, commission etc.). The actual base salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are selected to move forward in our recruitment process, the Talent Acquisition Specialist will be able to provide additional details of the total compensation for this role.
