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 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-premises 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. 3-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 Strong problem-solving and analytical thinking Clear written and verbal communication Collaborative, engineering-first mindset This job description is not intended to be an exhaustive list of all duties, responsibilities and qualifications of the job. The employer has the right to revise this job description at any time. You will be evaluated in part based on your performance of the responsibilities and/or tasks listed in this job description. You may be required perform other duties that are not included on this job description. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason. 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.