Senior Data Engineer

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

We are looking for an experienced and high-performing individual to join our Data Engineering team in Corporate IT as a Sr Data Engineer.  This senior technical role is responsible for the building, deployment, and support of data integration for BI reporting and analytic solutions, and application integration solutions. The Data Solutions & Engineering team in Corporate IT is an evolving group leading SLF in the application of leading-edge solutions against SLF business opportunities.  Our team is diverse and inclusive and value the variety of background and experience in all aspects of the role.  The team is involved in exciting projects using leading-edge technologies and leveraging our PWC, IICS and AWS Cloud based data platform for advanced analytics and data science.

What will you do?

• Support and contribute to the construction and maintenance of robust and efficient data applications and reusable frameworks
• Participate in all aspects of the development cycle from design and development to release planning and implementation of data systems.
• Apply best practices to all data engineering areas, including on premise, AWS, or a combination. This includes areas such as Operational Excellence, Security, Reliability, Performance Efficiency, and Cost Optimization
• Collaborate with other data developers across various locations to ensure all code follows applicable standards and is efficient and easily maintainable
• Support development of high-level solution options and estimates for project proposals, and detailed work estimates in support of assigned work
• Deliver solutions according to Systems Development Life Cycle (SDLC) methodology for either waterfall or agile projects
• Develop and manage effective working relationships with other departments, groups or personnel with whom work must be coordinated.

What do you need to succeed?

• Minimum 5 years of experience in developing solutions for data warehouse and system integrations using ETL tools and demonstrated experience using Power Center and IICS
• Experience with data modeling using ERwin or PowerDesigner and the Data Model Driven Approach
• Experience designing and building development framework for Power Center and IICS
• Experience working with Oracle, DB2, MS-SQL server and essential to have demonstrated strong core competency in SQL
• Experience with full end-to-end data solutions, from data assessment needs to data structure building, to data modelling, and data visualizations
• Strong understanding of AWS core data services and data service design patterns, or a proven desire and ability to learn AWS services (AWS Glue, S3, Lambda etc.)
• Experience with Business Intelligence and Data Warehouse overall design
• Excellent collaboration skills and proven ability to adapt to challenges, coaching and mentoring
• Ability to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT mode
• Ability to engage with a team of diverse skill sets and interface with peripheral technical teams

Preferred Skills

• Experience with production implementation change management processes
• Experience with project management and software development life cycle/SDLC; Agile and Lean (3+ years)
• Excellent documentation skills including technical writing, Visio, PowerPoint, flowcharting (3+ years)
• Strong communication and analytical skills, including conceptual, requirements interpretation, solution creation and problem-solving abilities
• Experience with Big Data technologies (Hadoop, Cassandra, Redshift, etc.)

What’s in it for you?

• A flexible work schedule, so long as it includes core working hours
• Competitive salary
• Being part of our journey in developing the next greatest digital experience
• Flexible Benefits from the day you join to meet the needs of you and your family.
• Wellness programs that support the three pillars of your health – mental, physical, and financial.
• Membership in a highly collaborative, supportive, and productive team
• An extensive support system for continual learning including company-run courses and access to online learning platforms

*Candidates must be eligible for Reliability Status Clearance which requires that they have lived and worked in Canada for the previous 5 consecutive years.

#LI-Hybrid #LI-remote

The Base Pay range is for the primary location for which the job is posted.  It may vary depending on the work location of the successful candidate or other factors.  In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance.  Certain sales focused roles have sales incentive plans based on individual or group sales results. 

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to thebrightside@sunlife.com.

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

82,000/82 000 - 135,000/135 000

Job Category:

IT - Technology Services

Posting End Date:

05/04/2024