Reporting Data Analyst - 12 Month Contract

Canada Life; London; On-site; CAD 60,000 - 100,000; Full time

Benefits offered by this job

Career development

Health benefits

Time off

Pension plan

Employee recognition

Community ERGs

Job summary

Canada Life, a leading Canadian insurer, seeks a Reporting Data Analyst to support analytics across Canada Operations & Business Enablement. Core work includes translating business needs into data solutions, building dashboards, and enabling decision-making with KPIs and insights.

You will partner with senior leaders, manage multiple priorities, and contribute to a mature analytics program using Power BI, SQL, Python, Azure and Databricks.

Qualifications

• 1-3 years of relevant experience and a bachelor’s degree in a related field or equivalent experience
• Microsoft Power BI Data Analyst Associate (PL-300) certification is preferred
• Demonstrated experience with SQL, Python, SQL Server, Azure, Databricks, and Power BI with interactive dashboards
• Ability to write efficient SQL and Python to extract, integrate, and transform data from multiple sources
• Proficiency in Power BI data modelling, Power Query, and DAX
• Experience with raw data and large datasets; strong data analytics and statistical modeling knowledge
• Strong communication and presentation skills; ability to learn quickly and handle multiple priorities
• Financial Services experience would be an asset

Responsibilities

• Translate business needs into data requirements and build data pipelines and models
• Create, implement and maintain reports and dashboards
• Work with large, imperfect datasets and ensure data quality
• Communicate insights and recommendations to leadership with clear visuals
• Define, implement and monitor KPIs aligned with business objectives
• Collaborate with business partners and senior leaders to drive data-driven decisions
• Support analytics projects through their lifecycle from conception to presentation

Skills

SQL

Python

Power BI

Data modelling

Visualization

Communication

Problem solving

Azure Databricks

SQL Server

Education

Bachelor's degree in related field

Tools

SQL Server

Azure

Databricks

Power BI

DAX

Power Query

Job description

Temporary Full Time

We are looking for a Reporting Data Analyst.

As a Reporting Data Analyst, you will join Canada Life’s Canada Operations & Business Enablement, Information Management team. In this role you will support all Canada Operations and Business Enablement teams with the development, implementation, and maintenance of analytics solutions ranging from descriptive and diagnostic to predictive.

The Analyst, Data & Analytics supports decision making, monitors business performance, and provides actionable insights using analytics and statistical techniques.

In this role, you will assist in modelling, analysing, and predicting business processes. You will translate business requirements into data, reporting, and analytics projects, which you will support throughout their entire lifecycle.

What You Will Do

• Translate business needs into data requirements, collect, integrate, clean, explore, model, and analyze large datasets and visualize results and present to business leaders
• Build, implement and maintain data models, custom reports, and dashboards
• Work with large datasets that are not consistent, clean, or fully modelled
• Communicate effectively and demonstrate critical thinking and business acumen.
• Define, implement, and monitor metrics and KPIs and ensure ongoing strategic alignment with short and long-term business objectives
• Enable effective, efficient working relationships with business partners
• Work closely with senior leaders to understand business drivers and enable them to make decisions based on data
• Support projects throughout the entire analytics lifecycle
• Present and communicate insights and recommendations in a visual and simplified manner

What You Will Bring

• 1-3 years of relevant experience and a bachelor’s degree in a related field of study, or an equivalent combination of education and experience
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) certification is preferred
• Demonstrated experience in working with data analytics tools (SQL, Python), Databases (SQL Server), Cloud (Azure, Databricks), data visualisation tools (Power BI) with experience at creating interactive dashboards
• Ability to write efficient SQL and Python queries to extract, integrate, and transform data from multiple sources, and to automate data pipelines
• Proficiency in Power BI, Data Modelling, Power Query, and DAX
• Microsoft Power BI Data Analyst (PL‑300) certification preferred
• Experience working with raw data and manipulating large datasets
• Good knowledge in data analytics and statistical modelling
• Strong communication and presentation skills
• Proven ability to learn quickly and independently and handle multiple priorities in a challenging work environment
• Experience within the Financial Services sector would be an asset

The base salary for this position is between $59,800 - $99,700 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

• Career Development: Opportunities for career advancement, access to industry-leading learning programs and up to$2,000 annually towards education 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 additionalinvestment 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.

Learn more about Canada Life.

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.