Senior Data Engineer

Sun Life • Waterloo, ON

8d • CA$80,000 - CA$128,000 • Hybrid

About The Position

The Client Experience Office (CXO) is an important pillar of Sun Life Canada’s Data and Analytics growth and corporate strategy and as such, is seeking experienced data engineering individual with a proven track record working with data consumers to extract meaningful insights from enterprise data. This Senior Business data engineer will play an indispensable role in assembling the necessary data products that fuel myriads 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 enquires such as identifying new business opportunities, understanding our client behavior and optimizing areas of our sales cycles. This is a senior individual contributor role bridging the requirements of Business consumers and data engineering practitioners to support the overall Business Data Strategy. This role will be partnering closely with CXO business stakeholders, enterprise governance and risk partners, and CXO data practitioners.

Requirements

• 3-5 years hands-on experience working on major Cloud technologies and programming languages for data processing and analytics
• 3+ years experience with AWS and Snowflake platforms for building robust ETL pipelines, Catalog management, Data Quality and Governance implementation to keep data compliant and reliable.
• 3+ years experience and proficiency in Python, Pyspark and SQL
• Demonstrated Experience in cost and performance optimization of Spark and SQL 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 and Iceberg
• 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

Nice To Haves

• Understand and Embrace Agile Operating Model
• Understanding of AI concepts and Machine learning and familiarity with AI services of AWS and Snowflake platforms
• Knowledge of fundamental statistical models & techniques
• Knowledge and experience working with DevOps technologies
• Experience working in a large financial services organization
• Experience in BI Tools like Tableau , Quicksight , Streamlit is a definite plus.
• Experience working with very large datasets and familiarity with big data technologies

Responsibilities

• 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 data assets
• Convert complex business and technical rules into logic for data flows and data pipelines
• Obsessed with understanding our enterprise data and interpreting it in the best way possible to derive business value
• 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

Benefits

• Wellness programs that support the three pillars of your health – mental, physical, and financial
• The opportunity to move along a variety of career paths with amazing networking potential.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree