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.

At Sun Life, we work together, share common values and encourage growth and achievement. We offer many career paths that attract a wide variety of talent and skills. Follow a path that lets your talents shine.

Role Summary:

The Client Experience Office (CXO) is an important pillar of Sun Life's corporate strategy and as such, is seeking experienced data engineering individuals with a proven track record working with data consumers to extract meaningful insights from enterprise data. Senior Business data engineers play an indispensable role in assembling the necessary data products that fuel myriad of analytical models used by our various business units across Canada.

Reporting to the Manager of Data Engineering, the Senior Business Data Engineer will be a key member of Data Enablement Team responsible for building enriched data products that provide deep insights about our Client, Advisor, Product, Transactions along with their intricate relationships. The Senior Business Data Engineer will work with data analysts and data scientists to help answer complex business inquiries such as identifying new business opportunities, understanding our client behavior and optimizing areas of our sales cycles.

What will you do?

• Obsessed with understanding our enterprise data and interpreting it in the best way possible to derive business value
• Design and engineer data models that represent our key business entities such as our Advisor, Client & Product
• Ensure high level of data quality and data integrity are maintained across data sources for business
• Convert complex business and technical rules into logic for data flows and data pipelines
• Work with our Data Science teams to implement data products for various use cases
• Collaborate with stakeholders and incorporate into solution design for various use case requirements
• Standardize metadata into a common glossary along with the necessary documentation for data consumers

What do you need to succeed?

• 3-5 years hands-on experience working on AWS technologies for data processing and analytics
• 3+ years experience with AWS Glue for ETL, Glue Catalog, Glue Data Quality, AWS Step Functions, AWS Lambda, AWS Athena
• Experience in AWS CLI, Identity & Access Management (IAM) and BI Tools like Tableau and Quicksight is a definite plus.
• 3 years experience in Python, Pyspark and SQL
• Demonstrated experience in performance tuning of Spark jobs
• 5 years hands-on experience with relational database systems, relational models, dimensional models, and analytical models
• 3-5 years experience with engineering data products as input to various analytical models
• 3-5 years building feedback loops between model deployment and its data - i.e. tune & tweak data products to achieve scale, optimization, etc.
• Sound understanding of Data Management principles (data warehousing, data quality, master data management, etc.) and Data Governance principles. Sound understanding of data modelling and a passion for analytics
• Proven ability to leverage knowledge of data engineering to extract, conform and integrate a variety of operational data sources into production-grade data products
• Experience of popular data formats like Parquet, Iceberg is a definite plus.
• Excellent verbal and written communication skills; have executive presence and proven ability to partner with Data Scientists to articulate insights gleaned from the model and the underlying data

Education and Qualifications:

• Undergraduate degree in Computer Science, Mathematics, Engineering, or equivalent
• Graduate degree in business or quantitative science strongly preferred

Unique Requirements

• The candidate selected for this role is required to attain Canadian Reliability Security Clearance (administered by submitting fingerprints to the RCMP, who then conduct min. 5 year history checks)

What would be nice to have?

• Understand and Embrace Agile Operating Model
• Proven Experienced working as Product Owner in Scrum or Service Request Manager in Kanban projects
• Experience working in a large financial services organization
• Knowledge of fundamental statistical models & techniques

What's in it for you?

• We are proud to be on the 2024 Best Workplaces in Canada list by Great Place to Work.
• We're also listed as one of the Best Workplaces for Women and Best Workplaces with Most Trusted Executive Teams.
• In 2024, Sun Life ranked among the top 100 most sustainable global corporations by Corporate Knights for the 15th consecutive year, leading Canadian insurers.
• A caring, supportive, and inclusive culture
• Flexible Benefits from the day you join to meet the needs of you and your family
• Time off giving you the flexibility to focus on the moments that matter. 20 days vacation per year.
• Care Days available for self-care or care of others (i.e., family or others you may support) and Sick Days to support your well-being.

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 ***.

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: 78,000/78 000 - 128,000/128 000

Job Category: Advanced Analytics

Posting End Date: 10/11/2024