Job
Description
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
