About the Role
The Underwriting Analyst supports and enhances underwriting tools, reporting, pricing, and quoting systems while developing technical solutions for ad hoc underwriting requests.
Responsibilities
- 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.
Requirements
- 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.
- 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.
Skills
- Excel
- Power Query
- VBA
- Data analysis
- Reporting
- Pricing analysis
- Underwriting
- Insurance
- Group benefits
- Financial analysis
- Analytical
- Problem-solving
- Critical-thinking
- Organizational skills
- Communication skills
- Collaboration
- Teamwork
Location
- Toronto
- Winnipeg
- Burnaby
Work Type
- Full-time
Experience Level
- 3-5 years
Education Level
- Post-secondary education in Mathematics, Statistics, Economics, Finance, Actuarial Science, Business Analytics, or a related discipline
- Equivalent experience considered
- GBA designation or progress toward a professional industry designation is an asset
Salary/Compensations
- $65,000 - $80,000 per annum
Benefits
- 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
About the Company
- People Corporation is 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.
Equal Opportunity
- 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 careers@peoplecorporation.com
