Permanent Full Time

Reporting to the Associate Manager, Management Information, Finance, working closely with our Individual Customer business partners, you will be a key member on the team involved in creating queries and reports. The team also participates in some projects, acting as subject matter experts concerning system data availability.

What You Will Do

• Meeting with various business partners, at all levels, to clarify requirements, understand needs, and possibly negotiate completion dates depending upon priorities and deadlines.
• Contributing to the documentation of accurate business requirements, which will be used not only by the team, but by the QA team and possibly the project team as well.
• Creating code to pull required data out of tables within our systems to create a usable report or query for the requestor.
• Perform testing to ensure queries/scripts are accurate
• Participating in projects to provide expertise from a data gathering perspective. Sometimes pulled into meetings to clarify what can and can’t be gleaned from a system’s available data tables.
• Answering questions from business partners about past and current queries. Also providing information as requested to the Audit team for their purposes.
• Maintaining our inventory to ensure query versions are tracked.
• Populating reports to measure individual and team productivity.
• Providing support for daily, weekly, bi-weekly, and monthly reports.
• Participating in new initiatives, both internal and external to the team.

What You Will Bring

• Experience is required for one or more of the following: Power BI, SQL Server/Management Studio, Access, Excel
• Knowledge of Wealth Decisions is an asset
• Knowledge or experience using end-user reporting tools languages would be an asset (e.g. SQL and DAX)
• Knowledge of our segregated funds and/or mutual fund systems, products, and processes is an asset
• A strong technical aptitude
• Experience with database management
• Demonstrated analysis and problem-solving skills
• Demonstrated ability to work within tight deadlines and with the ability to manage competing/changing priorities
• Strong written and verbal communication skills
• Ability to work well independently and in a team setting

Given the size and scope of our organization, we have the flexibility for this position to be located in the following head office locations: London, Toronto, Winnipeg. The base salary for this position is between $50,400 - $83,900 annually. This represents base salary only and does not represent other variable compensation components of our total compensation ( i.e. annual bonus, commission etc). If you are selected to move forward in our recruitment process, your recruiter will be able to discuss additional details of our total rewards program with you.

Career opportunities will be open a minimum of 5 business days from the date of posting, closing dates will vary depending on the search activity. All applications received will be reviewed on a rolling basis.

Be your best at Canada Life- Apply today!

Being a part of Canada Life means you have a voice. This is a place where your unique background, perspectives and talents are valued, and shape our future success.

You can be your best here. You’re part of a diverse and inclusive workplace where your career and well-being are championed. You’ll have the opportunity to excel in your way, finding new and better ways to deliver exceptional customer and advisor experiences.

Together, as part of a great team, you’ll deliver on our shared purpose to improve the well-being of Canadians. It’s our driving force. Become part of a strong and successful company that’s trusted by millions of Canadians to do the right thing.

Canada Life serves the financial security needs of more than 13 million people across Canada, with additional operations in Europe and the United States. As members of the Power Financial Corporation group of companies, we’re one of Canada’s leading insurers with interests in life insurance, health insurance, investment and retirement savings. We offer a broad portfolio of financial and benefit plan solutions for individuals, families, businesses and organizations.

We are committed to providing an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. 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.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Canada Life policies. To request a reasonable accommodation in the application process, contact talentacquisitioncanada@canadalife.com.

Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted.