Finance Data Analyst

Canada Life Group; Kitchener; On-site; CAD 60,000 - 90,000; Full time

Benefits offered by this job

Career Development

Health & Wellness

Time Off

Financial Security

Rewards and Recognition

Community

Job summary

Canada Life in Kitchener, Ontario, is seeking a Finance Data Analyst to strengthen FP&A through data management, reporting, and analytics. You will ensure data integrity, support month-end processes, and deliver key financial and operational reports.

Collaboration with Finance, Commissions, and Sales teams is essential for accurate analysis. The role emphasizes building robust data models in Power BI/Power Pivot, advanced Excel use, and SQL/SAP familiarity.

Qualifications

• 2+ years of experience in financial analysis or data analytics.
• Power Query and Power BI data modeling experience.
• Advanced Excel skills for data manipulation and analysis.
• Experience with SAP including journal entries.
• Strong attention to detail and data integrity.
• Ability to manage multiple deliverables within tight month-end timelines.
• Proactive in automation and process improvement.

Responsibilities

• Support month-end processes by preparing and organizing data for reporting and system updates.
• Collaborate with team to consolidate and validate financial and operational data.
• Help improve processes to reduce manual work and increase efficiency.
• Manage adjustments and updates to data, ensuring accuracy with financial records.
• Act as a point of contact for questions related to data updates and issue resolution.
• Prepare and deliver recurring reports to support business performance tracking.
• Maintain and update various reports on trends, performance, and key metrics.
• Take ownership of specific data processes, ensuring completeness and timely delivery.
• Perform ad-hoc analysis to support business decisions and stakeholder requests.
• Identify opportunities to enhance data quality, reporting, and processes.

Skills

Power BI

Power Query

Excel

SQL

SAP

Analytical thinking

Stakeholder management

Automation mindset

Power Pivot

Education

Bachelor's degree in Accounting/Finance or related field

Tools

SQL queries (SELECT/UPDATE/DELETE)

Job description

Select how often (in days) to receive an alert:

The FP&A (Financial Planning & Analysis) team in the Finance Department is looking for a Finance Data Analyst to add to our growing team. The role will support the FP&A function through data management, reporting, and analytics. This role is responsible for maintaining data integrity, supporting month-end processes, managing adjustments to reconcile reporting data to the General Ledger, and delivering critical financial and operational reporting. The successful candidate will also collaborate with Finance, Commissions, and Sales Field teams to ensure accurate and timely data analysis and reporting.

What you will do:

• Support month-end processes by preparing and organizing data for reporting and system updates.
• Collaborate with team members to consolidate and validate financial and operational data.
• Help improve processes to reduce manual work and increase efficiency.
• Manage adjustments and updates to data, ensuring accuracy and alignment with financial records.
• Act as a point of contact for questions related to data updates and issue resolution.
• Prepare and deliver recurring reports to support business performance tracking.
• Maintain and update various reports on trends, performance, and key metrics.
• Take ownership of specific data processes, ensuring completeness, accuracy, and timely delivery.
• Perform ad-hoc analysis to support business decisions and respond to stakeholder requests.
• Identify opportunities to enhance data quality, reporting, and overall processes.

What you will bring:

• Education background in Accounting and/or Finance or another relevant field
• 2+ years of experience in financial analysis, data analytics or a similar role
• Demonstrated Power Query and Power Pivot/Power BI (data model) experience in building and maintaining data transformation processes and reporting
• Advanced Excel skills for data manipulation and analysis
• Experience with preparing and utilizing SQL SELECT, UPDATE, DELETE queries is an asset
• Experience working with SAP including preparing journal entries
• Strong attention to detail and data accuracy
• Dedication to upholding a high level of data integrity within our data and reporting processes
• Ability to manage multiple deliverables within tight month-end timelines
• Analytical mindset with strong problem-solving skills
• Effective communication and stakeholder management
• Proactive approach to identifying automation and process improvement opportunities

The base salary for this position is between $60,000 - $89,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.

Grow with Canada Life

We’re united by a shared purpose: to improve the financial, physical and mental well‑being of Canadians. Our company is trusted by 1 in 3 Canadians and contributes to the strength of communities across the country.

We’re looking for people who live our values everyday: we step up, we do the right thing, and we deliver – for our customers, communities and each other. Are you someone who always strives to do the right thing, who steps up for themselves and others, and who delivers with impact? Then we want to hear from you!

What we offer

We’re committed to supporting our employees through every stage of their career. Here’s what you can expect as a full-time or part-time permanent team member:

• Career Development: Opportunities for career advancement, access to industry-leading learning programs and up to$2,000 annuallytowardseducation reimbursement.
• Health & Wellness: Flexible health and dental benefits,plus a $5,000 mental health benefit to support your well‑being.
• Time Off:In addition to regular vacation and personal days, we support community involvement with a volunteer day.
• Financial Security: Company-matching pension plan, share ownership program and additional investment options.
• Rewards and Recognition: Employee recognition programs, service milestone celebrations, employee discounts and more!
• Emphasis on Community:We provide a workplace where employees feel connected and supported through Employee Resource Groups (ERGs), mentorship programs, social clubs and events.

We’re committed to removing barriers and ensuring equal access to employment. Applicants requiring reasonable accommodation during the application process may contact [e-mail]. All information provided will be handled in accordance with applicable laws and Canada Life policies.

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

#LI-Hybrid

Location:

Kitchener Ontario, ON, CA, N2P 2G5