Corporate Analytics; Pricing) Co-Op Student; Hybrid

Position: CORPORATE ANALYTICS (PRICING) CO-OP STUDENT (HYBRID)
WHO WE ARE   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.
THEROLE IN A NUTSHELL   Base Salary: $22.50 / hour   Reporting to the Manager, Enterprise Pricing,the student will join the team in supporting pricing and forecasting initiatives 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 standard mathematical 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 student with exposure to these areas.
Enterprise Finance Responsibilities:
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, sett ingrates, and providing detailed analysis and projections
Analyze product 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
WHO WE'RE LOOKING FOR     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)
NICE TO HAVE     Understanding of group benefits and insurance industry

Experience with data visualization tools such as Tableau
Experience in process migration
Bilingualism (English & French)
THE CULTURE   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…