Underwriting Analyst

380 Underwriting; Winnipeg; On-site; CAD 65,000 - 80,000; Full time

Benefits offered by this job

Extended health care and dental

Retirement savings plan with company"s

Health & Wellness offerings

Mental Health programs

Job summary

People Corporation seeks an Underwriting Analyst to join our team in Winnipeg. You will analyze large datasets, develop reporting tools, and support pricing and quoting systems, collaborating with carriers and internal teams to improve underwriting outcomes.

The role requires 3–5 years of analytical underwriting experience, strong Excel/Power Query skills, and the ability to communicate findings clearly to both technical and non-technical audiences.

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 clean up techniques.
• Experience using Power Query to transform, validate, and automate data processes.
• Experience with VBA or other automation tools is a strong asset.
• Demonstrated experience with large datasets and producing insightful reports, analyses, and recommendations.

Responsibilities

• Analyze and interpret large 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 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 to maintain 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.

Skills

Analytical thinking

Attention to detail

Effective communication

Team collaboration

Education

Post-secondary education in Mathematics, Statistics, Economics, Finance, Actuarial Science, Business Analytics

Tools

Excel

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.