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:
This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada].
About the role:
At Sun Life Financial, Data Engineer is an important role that strives to reconcile the corporate data landscape with the business requirements as defined by the Application Services Team. In this role, the Data Engineer will perform analysis and provide designs/solutions for various projects consistent with the corporate data architecture. The Experience Platform (XP) is a modern platform providing world class interactions for our Clients, Advisors, and Partners. This Platform will deliver data and analytic services through approaches such as streaming, APIs, micro-services (containerization), and cloud services.
What will you do?
- Will play an active role in MongoDB engineering across - Full lifecycle implementation from requirements analysis, platform selection and setup, technical architecture design, application design and development, testing, and deployment
- Work with business users, SMEs, peer developers and other analysts to deliver high quality data models, architectural designs
- Develop MongoDB schema design by applying the suitable design patterns based on specific use cases.
- Develop and maintain conceptual, logical, and physical data models
- Contribute to analysis, solution design, development, and implementation of operational and data warehouse projects.
- Setup the physical data model including all physical database configurations such as indexes, tablespaces, table partitions, table constraints, relationships, etc.
- Drive innovation by keeping current on relevant data trends via researching, presenting, and accurately articulating the benefits and goals of data architecture related technologies, such as Big Data, Cloud technologies, Kafka, and NoSQL
- Expect to work with a fast-paced large agile team on complete software delivery lifecycle.
What do you need to succeed?
- Has designed high performant MongoDB Collections, Document schemas.
- Has hands on experience on data sync strategies from Kafka to Mongo Sync connector-based architectures.
- Has extensive architecture, design and implementation experience on MongoDB
- Has architected, designed and implement sharding and indexing strategies for MongoDB
- Strong analytical and problem-solving abilities
- Experience in Database design, administration, and security management
- Knowledge of MongoDB administration, installation, troubleshooting in AWS environments
- In-depth understanding of MongoDB architecture
- 10+ years of overall experience in IT. Experience with databases in Commercial cloud (Google Cloud Platform, Azure, AWS), SQL Server, Oracle, DB2, PostgreSQL and Redshift is preferred, and IMS (optional),
- Strong working experience of data modeling, data warehousing, metadata management, database design and development 5+ years.
- Logical and physical data modelling – 7+ years (dimensional and 3NF). In addition to all the traditional modelling techniques, the incumbent must also possess the knowledge to create logical data models using the Class Modelling technique as well the Generic Data Modelling approach.
- Experience with data modeling using PowerDesigner and/or ER/Studio (for mongoDB)
- Familiar with MongoDB Schema Design Patterns and the applicable use cases, solid design and working experience with MongoDB – 2+ years
- Excellent communication, presentation, and interpersonal skills
Nice to Have:
- Provide technical and data leadership to the application development group, IT, and the enterprise.
- Work closely with key client and IT stakeholders in understanding business needs and recommend solutions.
- Collaborate with domain and enterprise architects for delivery in compliance to strategic enterprise direction
- Create and maintain data architecture, data management standards and conventions, data naming standards, and metadata standards to ensure effective availability, scalability, security, and integrity of data assets.
Preferred Skills:
- Solid business and technical acumen, with demonstrated agility in learning and ability to become comfortable with unfamiliar businesses areas or technologies
- Ability to work in a dynamic environment with changing priorities
- Strong relationship management and consulting skills
- Solid written and verbal communication skills
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.
- Pension, stock and savings programs to help build and enhance your future financial security.
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:
80,000/80 000 - 130,400/130 400
Job Category:
IT - Application Development
Posting End Date:
30/07/2023