Group underwriting - Data Analyst

Posting Date: Sep 21, 2023

Location: Quebec, CA New Brunswick, CA Nova Scotia, CA ON, CA

Company: Medavie Blue Cross

For over 75 years, Medavie Blue Cross has been a leading health and wellness partner for individuals, employers and governments across Canada. As a not-for-profit organization, we proudly invest in communities to help address some of Canada’s most pressing health care challenges. We are one of Canada's Most Admired Corporate Cultures, one of Canada’s Top 100 Employers, Canada’s Life & Health Insurer of the Year for 2021 and an Imagine Canada Caring Company. 
Our 2,400 professionals work across six provinces, united by our shared values of being caring, accountable, responsible, innovative and community-minded. We’re committed to ensuring our employees thrive in our award-winning, collaborative culture focused on ensuring health, wellness, and personal and professional growth through a variety of programs and support across our organization.
Together with Medavie Health Services, we are part of Medavie — a national health solutions partner with over 7,700 employees. Our mission is to improve the wellbeing of Canadians.



Job Title: Data Analyst 
Department: Underwriting 
Competition: 86085
Internal/External: Internal/External
Employment Type: Permanent, Full time 
Location: QC, ON, NB, NS (Remote)
Comprehensive Compensation and Benefits
Reports To: Team Leader, Underwriting



Position Summary
The Group Underwriting business focus is to establish, administer and manage customer focused financial solutions for new and existing group benefit programs that are in line with the company's growth and margin targets.  The Group Underwriting Growth team primarily focuses on overall execution of quotes that supports both the brokerage and corporate business for the three markets.
The Data Analyst’s main responsibility is to compile statistical data on competition quotes and provide comparison reports on various statistical information.  The role will work under the guidance of the Manager Leader and Senior Group Underwriting Consultant.

Key Responsibilities
•    Update and validate the data on the quotes produced.
•    Compile statistical data on competition quotes.
•    Produce various statistical reports.
•    Communicating with sales on quote specifications.
•    Establishment of renewals and quotes pricing which includes analysis of experience/trend to justify the reasons behind the renewal and quotes; and to recommend pricing alternates.  This also encompasses responding to client inquiries relating to pricing and experience. Processing ad hoc requests for rating for in-force groups.
•    Assist the underwriters in their various tasks.
•    Perform any other task of the same nature, or of a general nature, as required by his duties.
•    Build out comprehensive business intelligence & reporting for various stakeholders, keeping in mind the needs of varied audiences and the desire to drive insights & action
•    Effectively translate business and project needs into data extraction and manipulation plans
•    Leverage data expertise to support initiatives through scoping, implementation, impact analysis, and ongoing reporting
•    Possesses analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
•    Identifies, analyzes, and interprets trends or patterns in complex data sets.
•    Remains alert to new techniques for insights, analytics, and data visualization, and devises new ways of applying them.
•    Interprets data, analyzes results using statistical techniques and provide ongoing reports.
•    Gathers requirements and documents these requirements for use in various audits, reports, & projects.
•    Reporting and business intelligence
•    Insightful analysis of data
•    A passion for solving problems
•    Critical thinking skills
•    Business understanding

Required Qualifications
•    An undergraduate or graduate degree in mathematics, statistics, economics, finance, accounting or computer science, plus strong quantitative skills and background, or equivalent work experience
•    Minimum of two (2) years in Group Underwriting experience including knowledge of systems and processes
Other Qualifications:
•    Insurance knowledge (LOMA, CEBS or HIAA) would be an asset
•    Strong computer skills and experience working with the Microsoft Office Suite. Strong Excel skills (vlookups and pivot tables, macros)
•    Bilingualism (French and English) is mandatory
Core Competencies
•    Have an understanding of the group insurance business.
•    Are very organized and exhibits high attention to detail. Have excellent reasoning, judgement and decision-making abilities.
•    Communicates clearly and confidently verbally and in writing to a variety of audiences.
•    Self-directed with high levels of personal accountability and responsibility. Enjoys working autonomously in a collaborative team-based environment.
•    Demonstrates an understanding of how the job contributes to the overall Underwriting unit and helps others without being asked.
•    High attention to detail. Excellent reasoning, judgment and decision-making abilities.

We are an Equal Opportunity Employer. 


Medavie Blue Cross strives to foster a culture where everyone is enabled to achieve their full potential - a culture of diversity, equity and inclusion (DEI) where we live our values every day in the way we treat each other, our members and the communities we serve. Accessibility is a top priority.


For applicants with disabilities, we provide accommodations throughout the recruitment, selection and/or assessment process. If selected to participate in the recruitment, selection and/or assessment process, please inform Medavie Blue Cross Human Resources staff of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation. All personal information is collected under the authority of the Municipal Freedom of Information and Protection of Privacy Act.


We would like to thank all candidates for expressing interest. Please note only those selected for interviews will be contacted.

Job Segment: Database, Underwriter, Data Analyst, Business Intelligence, Computer Science, Insurance, Technology, Data