Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

As part of the IWIS/AN Data and Analytics Team, you will provide the data foundation for planning and decision-making at Canada Life. You will offer technical leadership and hands-on skills to support systems for data collection, integration, analysis, and presentation for the Canada Life community. This role involves building Azure Data Factory and ETL processes, writing complex SQL, and supporting operational processes in our Data Warehouse and Microsoft Azure data hub, requiring experienced thought leadership to drive initiatives for development pipelines.

Responsibilities

Build data pipelines in MS Azure platform supporting structured and unstructured data consumption from various sources using Azure Data Factory and Data Bricks
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 facilitate 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 to and improve 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 enhancements and provide support for initiatives related to existing legacy databases

Requirements

5+ years of hands-on experience in developing data solutions with a strong background in data warehousing (incorporating a Kimball dimensional design methodology)
Strong relational database development experience in MS SQL is required
Experience in developing ETL constructs using Informatica or an equivalent tool
Recent development experience in MS Azure platform (Databricks, ADF), Kafka, Python (or R), Change Spark, and Data Capture (CDC)
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

Skills

Azure Data Factory
ETL processes
SQL
Data Warehouse
Microsoft Azure
Data modelling
MS Azure platform
Databricks
Kafka
Python
R
Change Spark
Data Capture (CDC)
Informatica
API
Microservice integration

Location

Hybrid

Work Type

Permanent
Full Time

Experience Level

5+ years

Education Level

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

Salary/Compensations

$85,200 - $135,200

Benefits

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.

About the Company

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!

Equal Opportunity

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.