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.

As part of the IC & AN Data and Analytics team 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. In this role you will wear many hats: building Azure Data Factory and ETL processes, writing complex SQLs, supporting operational processes in both our data warehouse and Microsoft Azure data hub. We are looking for a candidate with 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 function
• 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
• Guide team members and 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
• Work will initially involve proficiency in MS SQL Server as the focus gradually shifts to Azure Databricks over the course of database migration.

QUALIFICATIONS:

• 8+ 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.

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.