Senior Infrastructure Specialist, Database

Permanent Full Time 

-

We are looking for a Senior Infrastructure Specialist, Database.

As part of the IWIS/AN Data and Analytics Team you will help provide the data foundation for planning and decision making at Canada Life.  You will provide technical leadership and hands-on skills to support the systems that enable the collection, integration, analysis and presentation of information to be used by the Canada Life community.

In this role you will wear many hats: building Azure Data Factory and ETL processes, writing complex SQL, and supporting operational processes in both our Data Warehouse and Microsoft Azure data hub. In addition, the role requires experienced thought leadership and ability to drive initiatives that enable our development pipelines to continually be available and capable of meeting our business partners’ needs.

What you will do

• 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
• Apply enhancement and provide support for initiatives related to existing legacy databases

What you will bring 

• 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
• 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

-

The base salary for this position is between  $63,500- $117,400 annually.  This represents base salary only and does not represent other variable compensation components of our total compensation ( i.e. annual bonus, commission etc).  If you are selected to move forward in our recruitment process, your recruiter will be able to discuss additional details of our total rewards program with you.

Career opportunities will be open a minimum of 5 business days from the date of posting, closing dates will vary depending on the search activity. All applications received will be reviewed on a rolling basis.

Be your best at Canada Life- Apply today!

Being a part of Canada Life means you have a voice. This is a place where your unique background, perspectives and talents are valued, and shape our future success.

You can be your best here. You’re part of a diverse and inclusive workplace where your career and well-being are championed. You’ll have the opportunity to excel in your way, finding new and better ways to deliver exceptional customer and advisor experiences.

Together, as part of a great team, you’ll deliver on our shared purpose to improve the well-being of Canadians. It’s our driving force. Become part of a strong and successful company that’s trusted by millions of Canadians to do the right thing.

Canada Life serves the financial security needs of more than 13 million people across Canada, with additional operations in Europe and the United States. As members of the Power Financial Corporation group of companies, we’re one of Canada’s leading insurers with interests in life insurance, health insurance, investment and retirement savings. We offer a broad portfolio of financial and benefit plan solutions for individuals, families, businesses and organizations. 

We are committed to providing an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. We are dedicated to building a workforce that reflects the diversity of the communities in which we live, and to creating an environment where every employee has the opportunity to reach their potential. 

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Canada Life policies. To request a reasonable accommodation in the application process, contact talentacquisitioncanada@canadalife.com.

Canada Life would like to thank all applicants, however only those who qualify for an interview will be contacted.

#LI-Hybrid