Senior Infrastructure Specialist DB
About The Position
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 the ability to drive initiatives that enable our development pipelines to continually be available and capable of meeting our business partners’ needs.
Requirements
- 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)
- 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
Nice To Haves
- Previous investment and/or insurance experience will be considered an asset
Responsibilities
- 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
Benefits
- Career Development: Opportunities for career advancement, access to industry-leading learning programs and up to $2,000 annually towards education reimbursement.
- Health & Wellness: Flexible health and dental benefits, plus a $5,000 mental health benefit to support your well-being.
- Time Off: In addition to regular vacation and personal days, we support community involvement with a volunteer day.
- Financial Security: Company-matching pension plan, share ownership program and additional investment options.
- Rewards and Recognition: Employee recognition programs, service milestone celebrations, employee discounts and more!
- Emphasis on Community: We provide a workplace where employees feel connected and supported through Employee Resource Groups (ERGs), mentorship programs, social clubs and events.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
