Data Analyst

TechAlliance of Southwestern Ontario, London Economic Development Corporation; London; Hybrid; CAD 66,000 - 110,000; Full time

Benefits offered by this job

Career development

Health & Wellness benefits

Volunteer day

Pension & share plan

Employee discounts

Job summary

Canada Life in London, ON is seeking a Data Analyst to support Canada Operations & Business Enablement with analytics ranging from descriptive to predictive.

You will translate business needs into data, build dashboards, and collaborate with senior leaders; requires 1-3 years experience and a bachelor’s degree. The role offers a hybrid work model with three in-office days per week and CAD 65,800–109,700 base salary.

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 certification is preferred
• Proficiency in SQL and Python for data extraction, integration, and transformation

Responsibilities

• Translate business needs into data requirements, collect, integrate, clean, explore, model, and analyze large datasets and visualize results for leadership
• Build, implement and maintain data models, reports, and dashboards
• Work with large datasets that are not clean or fully modeled
• Define, implement, and monitor metrics and KPIs aligned with business objectives
• Enable effective collaboration with business partners and senior leaders

Skills

SQL

Python

Power BI

Data modeling

Data analysis

Communication

Education

Bachelor’s degree in a related field

Tools

SQL Server

Azure

Databricks

Power BI

Job description

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

As a Data Analyst, you will join Canada Life’s Canada Operations & Business Enablement, Data Analytics and Reporting 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

• Reliability Status Security Clearance – this can only be completed with candidates who receive an offer of employment. This is a personal security status that is required as a condition of employment before an employee can gain access to Protected B information, assets or work sites as outlined by the Government of Canada website. The cost of submitting these checks will be covered by Canada Life
• 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
• 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

Given the size and scope of our organization, we have the flexibility for this position to be located in the following head office locations: Toronto, London, Winnipeg. This role follows a hybrid work model, with an in-office presence required three days per week.

The base salary for this position is between $65,800 - $109,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,physicaland mental well-beingof 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,communitiesand 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 andpersonal days,we support communityinvolvement with avolunteer day.
• Financial Security:Company-matching pension plan,share ownership program andadditionalinvestment options.
• Rewards and Recognition:Employee recognition programs, service milestone celebrations, employee discounts and more!
• Emphasis onCommunity:We provide aworkplace whereemployeesfeel connected and supported throughEmployee Resource Groups (ERGs),mentorshipprograms,socialclubsandevents.

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 Lifewould like to thank all applicants, however only those who qualify for an interview will be contacted.

Location: London, ON, CA Winnipeg, MB, CA Toronto, ON, CA