Underwriting Analyst

People Corporation; Toronto; On-site; CAD 65,000 - 80,000; Full time

Benefits offered by this job

Extended health care and dental

Retirement savings plan with company

Health & Wellness offerings

Mental Health programs

Competitive compensation

Job summary

People Corporation in Toronto, Winnipeg, or Burnaby seeks an Underwriting Analyst to support underwriting tools, reporting, pricing, and data-driven decision making. You will analyze large datasets, develop dashboards in Excel and Power Query, and collaborate with carriers and internal teams to improve underwriting outcomes.

You will work with experience in Excel, Power Query, and possibly VBA, delivering insights and recommendations to support strategic decisions and growth in a dynamic

Qualifications

• Post-secondary education in Mathematics, Statistics, Economics, Finance, Actuarial Science, Business Analytics, or related discipline; equivalent experience considered.
• 3–5 years of underwriting, insurance, group benefits, financial analysis, or similar analytical role.
• Advanced proficiency in Microsoft Excel, including Pivot Tables, advanced formulas, data analysis, and data cleanup.
• Experience using Power Query to transform, validate, and automate data processes.
• Experience with VBA or other automation tools is an asset.
• Demonstrated experience working with large datasets and producing insightful reports, analyses, and recommendations.
• Strong analytical, problem-solving, and critical-thinking skills with accuracy and attention to detail.

Responsibilities

• Analyze and interpret large and complex datasets to identify trends, risks, opportunities, and insights for clients and stakeholders.
• Develop, maintain, and enhance reporting tools, dashboards, and data models using Excel and Power Query.
• Assist with development and improvement of underwriting tools, processes, and data management practices.
• Evaluate new business opportunities through pricing analysis to maintain and improve quote tools.
• Analyze claims experience, demographic data, financial results, and carrier proposals to support decisions.
• Collaborate with carriers, consultants, Account Managers, brokers, and internal teams to gather data and ensure accurate underwriting outcomes.
• Identify plan performance and reporting issues, and recommend solutions to stakeholders.
• Prepare renewal analyses and reporting packages, including insurer negotiations support.
• Support new sales initiatives and revenue growth through data-driven 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.

Skills

Analytical thinking

Communication

Collaboration

Attention to detail

Education

Post-secondary education in Mathematics

Statistics

Economics

Finance

Actuarial Science

Business Analytics

equivalent experience

Tools

Excel

Pivot Tables

Power Query

VBA

Job description

We are seeking an Underwriting Analyst to join our team in Toronto, Winnipeg, or Burnaby. 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.
• 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.

To be successful as an Underwriting Analyst with People Corporation, you will need:

• 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.

What's in it for you:

• 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. 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. 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.

For more information on Accessibility at People Corporation, visit our link https://www.peoplecorporation.com/en-ca/accessibility-statement.