Permanent Full Time

As part of the ADCL Shared Services - Data and Analytics Team you will help provide the data foundation for planning and decision making at Canada Life. You will provide technical leadership and hands-on skills to support the systems that enable the collection, integration, analysis and presentation of information to be used by the Canada Life community.

In this role you will wear many hats: building in Azure Data Factory and Databases, writing complex SQL, stored procedures, and supporting operational processes in both our Data Warehouse and Microsoft Azure data hub. In addition, the role requires experienced thought leadership and ability to drive initiatives that enable our development pipelines to continually be available and capable of meeting our business partners’ needs.

What you will do

• Develop, maintain, and optimize SQL Server T‑SQL solutions, including writing and maintaining complex stored procedures, functions, and queries

• Perform SQL Server Database Administration tasks such as monitoring, backups, recovery, maintenance, and troubleshooting

• Design and implement star‑schema and data‑warehouse–style database models to support reporting and analytics needs

• Analyze and improve database performance, including query optimization, indexing strategies, and resource utilization

• Provide database‑related production support, diagnosing issues, resolving incidents, and partnering with application teams to ensure system stability

• Build data pipelines in MS Azure platform that supports the consumption of structured and unstructured data from various sources with the use of Azure Data Factory and Data Bricks

• Work will involve proficiency in MS SQL Server as the focus gradually shifts to Azure Databricks over the course of database migration

• Collaborate with cross functional teams to analyze, transform, and model large complex data sets for business insights, operational reporting, and analytics

• Develop data solutions that facilitates re-usability across various business functions

• Develop and support the creation of conceptual, logical, and physical data models

• Lead and support the migration of on-premise data solutions to the MS Azure platform

• Actively contribute and improve our data solutions and best practices

• Collaborate with internal technical stakeholders and business partners for solving data related technical issues

• Advise others on Data Modelling and the use of database technologies

• Apply enhancement and provide support for initiatives related to existing legacy databases

What you will bring

• Bachelor’s degree in Computer Science, Mathematics, Statistics or in a related field.

• 10+ years of hands-on experience in developing data solutions with a strong background in data warehousing (incorporating a Kimball dimensional design methodology)

• High proficiency in SQL Server T‑SQL development, including the design and implementation of complex stored procedures, functions, and queries

• Strong experience with SQL Server Database Administration, including maintenance, monitoring, backups, recovery, and troubleshooting

• Recent development experience in MS Azure platform (Databricks, ADF), Kafka, Python (or R), and Change Spark

• Hands‑on experience with change data capture (CDC) solutions or implementations is an asset.

• Previous investment and/or insurance experience will be considered an asset

• Good communication and collaboration skills

• Seeks to understand business needs, and delivers high quality service to the business while understanding the organization’s vision, purpose and values

• Passionate about technology, the user experience, demonstrates inner self starter, and is accepting of and open to learning new ideas outside scope or knowledge

• Familiar with API, microservice integration

• Explains technical issues to diverse audiences

• Decision-making: understands the costs and benefits of actions, and makes recommendations towards the most appropriate one, uses collaboration and judgement to form conclusions -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.

The base salary for this position is between**$85,200 - $135,200**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 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 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.

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 talentacquisitioncanada@canadalife.com*. 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.

#LI-Hybrid