Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them.

Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself.

You will help shape our journey in realizing increased business value from our data for our business partners. This team works on building data pipelines, integration projects, and data warehousing to facilitate business intelligence, visualization, and analytics for the Canada Life community. You will be part of a winning team that leads the way in delivering value for our business and to help accelerate Cloud adoption,  building Azure Data Factory and ETL processes, writing complex SQLs, supporting operational processes in both our data warehouse and Microsoft Azure data hub. This role requires strong technical background and solid development experience in data warehousing, ETL development tools, data modeling and design, and experience in the MS Azure / Azure Data Factory / Data Bricks ecosystem.

Essential Functions:

• 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
• 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
• Enhancements to existing databases

Qualifications:

• Bachelor’s Degree in Computer science, Mathematics, Statistics or in a related field.
• 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. Exposure to No SQL database is a plus
• 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)
• Good communication and collaboration skills

We are an equal opportunity employer with a commitment to diversity.  All individuals, regardless of personal characteristics, are encouraged to apply.  All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.