Corporate Analytics; Pricing) Co-Op Student; Hybrid

When it comes to health, we’re always looking for waysto push for better. It’s why we were founded in the first place. In 1957, our founder, pharmacist William Wilkinson, witnessed a mother sacrifice her healthby forgoing her own medicine to pay for her sick daughter’s prescription. Heknew there had to be a better way. So, he introduced North America’s first prepaid drug plan, and Green Shield was born as a not-for-profit with a missionto support better health for all Canadians.

We aren’t just a health and benefits company. We’rethe only not-for-profit social enterprise that brings worlds of coverage and care together, all in one place.
We’re noble challengers, purposefully building a betterway and we need the best people to help us create a more holistic approach thattakes care of the mind and body.
Our mission is to create better health for all Canadians, and we know that starts with our employees.

Reporting to the Manager, Enterprise Pricing,the student will join the team in supporting pricing and forecastinginitiatives across the enterprise. This position provides excellent opportunities in learning and implementing financial concepts in a corporate environment and getting a broad understanding of the overall organization.

Working in small teams of one to three individuals, the student will participate in the execution of actuarial duties by performing standardmathematical calculations and the implementation of R and SQL (programming languages) throughout standard processes. The team includes Actuarial Insurance Pricing and Non-Actuarial Enterprise Pricing teams and will provide the studentwith exposure to these areas.

• Investigate and identify the different revenue and expense components of product lines
• Support the development of manual rates across all lines of business. Includes the development of normalization factors, proposing credibility adjustments,and communicating results to management
• Support pricing exercises which include recommending pricing assumptions, settingrates, and providing detailed analysis and projections
• Analyzeproduct enhancements, emerging experience, and marketplace trends and communicate results to management
• Support key metric reporting on the profitability of various product lines and provide feedback on opportunities for improvement
• Review current reports and develop enhanced forms and methods of delivery
• Assiston ad hoc work such as custom-tailored product pricings, new product developments, and complex underwriting quotes

• Working towards a recognized bachelor’s degree or master’s degree in actuarial science, mathematics, computer science, or technical or quantitative discipline from an accredited college or University required
• Superior analytical and problem-solving skills
• Advanced knowledge of Microsoft Excel
• Ability to process and manipulate large amounts of data
• Excellent planning, organizing, and time management skills with strong attention to detail
• Desire to learn and ability to think critically
• Working knowledge of SQL (select statements)
• Working knowledge of R (data frames, dplyr, ggplot)

• Understanding of group benefits and insurance industry
• Experience with data visualization tools such as Tableau
• Experience in process migration
• Bilingualism (English & French)

We believe a career should be meaningful. Not just ameans to earn a living. Our culture is one where everyone's voice is heard andvalued. Because that’s what it takesto create better health for all. We dare to challenge the status quo. And we’redriven by people who have challenged theirs. We believe that your workplace should empower you to be the best version of yourself.

That’s why…