Underwriting Analyst

People Corporation•Toronto, ON

1d•CA$65,000 - CA$80,000•Hybrid

About The Position

The Underwriting Analyst supports and enhances underwriting tools, reporting, pricing, and quoting systems while developing technical solutions for ad hoc underwriting requests. The Underwriting Analyst will analyze and interpret large and complex datasets to identify trends, risks, opportunities, and actionable insights for clients and internal stakeholders. They will develop, maintain, and enhance reporting tools, dashboards, and data models using Excel, Power Query, and other analytical tools. This role will assist with the development and continuous improvement of underwriting tools, processes, reporting automation, and data management practices. The analyst will 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. They will analyze claims experience, demographic data, financial results, and carrier proposals to develop recommendations and support strategic decision-making. Collaboration with carriers, consultants, Account Managers, brokers, and internal teams is essential to gather data and ensure accurate underwriting outcomes. The role involves identifying plan performance, claims trends, and reporting issues, and recommending solutions to internal stakeholders. Preparation of renewal analysis and reporting packages, including support for insurer negotiations, is also a key responsibility. The Underwriting Analyst will support new sales initiatives and revenue growth objectives through data-driven analysis and underwriting expertise, and provide underwriting and analytical consulting services to various stakeholders. Maintaining effective working relationships with insurers, Plan Sponsors, Plan Administrators, consultants, and internal partners is crucial.

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.

Nice To Haves

Experience with VBA or other automation tools is considered a strong asset.
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.

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.