Senior Data Engineer
Sun Life Waterloo King
Full Time Senior-level / Expert Clearance required USD 120K - 195K *
Sun Life
Sun Life is a financial services company providing financial planning, life insurance, health insurance, investments and more.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 currently looking for a Senior Data Engineer with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Engineer on the Data Engineering and Operations team, you will be joining a group of hardworking and savvy innovators who has made it their mission to find new ways to glean value out of rapidly increasing volumes of operational data in Canadian Operations.
Working within a diverse and motivated team of analytics professionals, the Senior Data Engineer will lead the development of efficient data capture and transformation processes and complex data models that form the core of a new generation of analytics services and self-serve solutions for our customers in Canadian Operations.
What will you do?
- Lead development of new batch/low-latency analytical solutions that leverages both traditional and emerging technologies
- Design, develop and implement highly scalable data capture and transformation processes
- Create effective ETLs/ELTs to move large volumes of data from various operational systems to dimensional data models for analytics consumption
- Act as principal designer and reviewer for new data models, make data architectural decision, and provide coaching on data modeling and process design
- Expand and grow data existing platform capabilities to solve new data problems and challenges
- Ensure all automated processes preserve data integrity by managing the alignment of data availability and integration processes
- Support quantitative analysts and data scientists with data discovery and rapid assembly of large data sets from disparate sources
- Identify opportunities for new data acquisition and new uses for existing data resources
- Research and make recommendations for new data management technologies and software engineering practices. Collaborate on decisions around the use of new tools and practices
- Perform quality assurance and testing according to risk assessment guidelines to minimize operational, reputation, and legal risk.
- Define data retention policy, establish data governance best practice, and create automated anomaly detection services
- Document and update business continuity and disaster recovery procedures.
- Engage in ongoing collaboration with data architects, modellers and other members to achieve common goals.
- Provide guidance to development teams regarding best practices and design patterns for analytics solutions. Coach and provide guidance to junior team members
- Produce and maintain support documentation for ongoing operations.
- Act as Tier-2/3 support to troubleshoot and resolve technical issues with production data models and services
What will you need to succeed?
- University degree in Computer Science, Software Engineering, or equivalent.
- Experience with hybrid data environments that leverage both distributed and relational database technologies to support analytics services
- Solid understanding of data warehousing principles, architecture and its implementation in complex environments.
- Hands-on experience with development of ELT/ETL processes in traditional and distributed environments
- Experience as designer of complex Dimensional data models for analytics services
- Experience with development for Microsoft SQL Server Analysis Services or equivalent technologies
- Experience with various testing methodologies and user acceptance testing.
- Solid skills in SQL, Python, C++, Java and other languages used in data manipulation
- Experience with AWS Glue and Big Data technology
- Experience with processing large datasets from multiple sources.
- Ability to operate effectively and independently in a dynamic, fluid environment.
- Strong verbal and written communications skills with experience in relating complex concepts to non-technical users.
- Demonstrated ability to exchange ideas and convey complex information clearly and concisely
- Proven ability to lead and drive projects and assignments to completion
- Experience with optimization and tuning of large data extracts for Tableau
- Familiarity with Agile development practices.
- Understanding of ITIL processes Incident/Change/Release management methodologies.
- Knowledge of Insurance or Financial Services industry.
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)
To see if you are eligible for this clearance, please review the section 201 on the Federal Government site (https://www.tpsgc-pwgsc.gc.ca/esc-src/personnel/pdcf-rsrp-eng.html)
What’s in it for you?
- Great Place to Work® Certified in Canada and the US - 2022
- Great Place to Work® award for Best Workplaces for #HybridWork
- 2022 Named “Best Places to Work” by Glassdoor - 2021
- Canada Award for Excellence for Mental Health at Work
- 2021 Flexible hybrid work model including in-country work-from-home if you prefer.
#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:
76,000/76 000 - 125,000/125 000Job Category:
Advanced AnalyticsPosting End Date:
17/05/2024* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture AWS AWS Glue Big Data Computer Science Data governance Data management Data Warehousing ELT Engineering ETL ITIL Java Python RDBMS Research Security SQL Tableau Testing
Perks/benefits: Career development Equity Flex hours Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Intern jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Product Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Engineering Manager jobs
- Open Junior Data Engineer jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Data quality-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open LLMs-related jobs
- Open APIs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs