Sr Engineer Data

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 businessinsights, 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.