Data Production Analyst
Sun Life Waterloo North
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:
Location: Hybrid
The Client Data Solutions (CDSS) team's major business objective is to change, optimize and improve the manner in which we process and deliver data services to our group business lines – Group Benefits (GB) and Group Retirement Services (GRS). Our strategy is to build a service-oriented center of excellence model, which focuses on client (internal and external) service and recognizes the importance of all stakeholders and its impact to a centralized data management strategy. We specialize in:
- Inbound bulk data files and automated feeds from our clients into Sun Life (e.g., demographic data loads, asset transfer-in files, GRS enrolment and contribution feeds, etc.)
- Data loads, transfers, analysis and reporting to support client implementations, revisions, and ongoing service
This role specifically is on the CDSS Group Benefits (GB) Production team, which is responsible for handling large data loads to our systems based on our GB Clients’ needs. A key driver to the success of our team is finding people that possess a great mix of business knowledge, data manipulation skills and the ability to communicate well with our business partners to prioritize our clients’ needs.
Reporting to the Manager, Client Data Solutions, the Data Production Analyst is responsible for the coordination and execution of client data transfers to the appropriate Sun Life systems, with emphasis on accuracy and efficiency. This may involve working directly with Sun Life Service Representatives in Business Development, Implementation Project Managers, Plan Setup and Member Specialists in Operations.
Data manipulation will be required at the time of new business implementations or major amendments to existing customer plan designs, as well as ongoing maintenance of existing client data.
What will you do?
Production support inbound (processing various member data files from plan sponsors) (90%)
- Manipulate and reformat data files from the client’s format to a compatible Sun life format
- Coordinate with Sun Life’s Business Projects and Solutions and IT teams to ensure data is mapped accurately to plan set up
- Perform compares between two or more data files to identify discrepancies
- Responsible for claim history load transfers
- Create pre-populated enrolment forms, interim pay direct drug cards, and partial loader templates for plan members.
- Provide timely and accurate data file management support to Implementation Project Managers, Plan Setup and Member Specialists in Operations
Best practices and team development (10%)
- Collaborate continuously with team members to identify and implement process improvements and best practices, in order to enhance efficiency and productivity
- Document business processes and provide training on new or enhanced processes, when required.
- Adhere to quality, audit and time tracking checking functions within the team.
- Provide coaching to peers and Data Specialists on the team
- Support Manager with organizing and leading training sessions
What do you need to succeed?
- Advanced Excel skills (formulas, VLOOKUP, IF statements, pivot tables) is required
- Detail-oriented and analytical skills with an ability to work with large sets of data
- Organization, time management and prioritization skills to be able to work under pressure and meet quick turnaround times
- Collaborative, solutions-oriented and customer service skills
- As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required for Quebec only as the position reports to a unilingual English-speaking manager outside Quebec.
What will be nice to have?
- Experience with VBA macro or SQL.
- Knowledge of the Group Benefits businesses, products, and processes.
- Knowledge of plan setup and member administration on the OASIS and CHESS systems
Reasons why should you join us under the sun
- We’re proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Work® Canada!
- Opportunities to own your career development with programs to continuously learn, build skills, grow through coaching and more.
- Being part of our journey in developing the next greatest digital experience.
- Working together, sharing common values, and encouraging growth & achievement
- Time off giving you the flexibility to focus on the moments that matter. 15 days' vacation per year.
- Flexible Benefits from the day you join to meet the needs of you and your family.
- Pension Plan participation starts immediately, and you are automatically enrolled. We help you save more with Sun Life automatic and matching contributions and by including both your salary and bonus when making contributions.
#LI-Hybrid
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:
53,800/53 800 - 87,400/87 400Job Category:
Business Analysis - ProcessPosting End Date:
25/03/2024* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data management Excel SQL
Perks/benefits: Career development Equity Flex hours Flex vacation Salary bonus
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 Manager jobs
- Open MLOps Engineer jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Junior Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs