Data Production Analyst

2 weeks ago


Montréal, Canada Sun Life Full time

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.

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



  • Montréal, Canada Sun Life Full time

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

  • Data Analyst

    1 month ago


    Montréal, Canada Youville Haussmann Park Full time

    Unleash Engagement with Alice & Smith Metalab and join our team in transforming user experiences! XR Server, our cutting-edge gamification engine built on Microsoft Azure PlayFab, empowers companies to create captivating ecosystems and build community. Level up your skills and be part of the gaming revolution! Alice & Smith Metalab is the proud SI arm of...

  • Product Analyst

    1 week ago


    Montréal, Canada Big Fish Games, Inc. Full time

    **Company Summary** Product Madness is a Global Powerhouse where the greatest mobile games and experiences are crafted by world-class talent. A top-grossing leader in free to play mobile games, we have more than 800 team members working across seven global talent hubs including London (headquarters), USA, Canada, Spain, Poland and Ukraine. With remarkable...


  • Montréal, Canada Canadian Security Intelligence Service Full time

    **Important**: **Closing Date** 2024-03-29 **Reference Number** 22-968-08-020 **Job Category** Experienced **Who Can Apply** Canadian Citizens **Location** Montréal, Québec Ottawa, Ontario Toronto, Ontario **Salary Range** $99,392 - $120,917 **Status** Indeterminate (permanent) **Language Requirement** Bilingual Non Imperative CBB BBB EE **Job...

  • Data Analyst

    1 month ago


    Montréal, Canada Vault Credit Corporation Full time

    **Get to Know Vault Credit Corporation** Vault is a non-bank private lending company offering a wide array of financial services such as mortgage, leasing and lending products. Vault has a devoted team of experts with years of experience in both financial services and real estate. We are dedicated to delivering products and services that meet the diverse...

  • Master Data Analyst

    1 week ago


    Montréal, Canada CN Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you're part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a...

  • Data Analyst

    1 month ago


    Montréal, Canada Newrest Full time

    En tant que Data Analyst chez Newrest, vous serez responsable de la collecte, de l'analyse et de l'interprétation des données afin de fournir des informations précieuses à l'entreprise. Vous travaillerez en étroite collaboration avec les équipes opérationnelles et managériales pour identifier des opportunités d'amélioration et de croissance, tout...

  • Data Analyst

    1 month ago


    Montréal, Canada Foodtastic Full time

    **About the Company** Founded in 2016, Foodtastic is already one of the largest restaurant companies in Canada. We have increased system sales in the last four years from less than $50mm to over $750mm. Our current portfolio of 23 brands includes Milestones Grill & Bar, Second Cup Café, Pita Pit, La Belle et La Boeuf, and Rôtisseries Benny. **Data...

  • Data Analyst

    3 weeks ago


    Montréal, QC, Canada Zortechsolutions Full time

    JD Data Analyst profile should be of level II with 3-5 Yrs. in PL/SQL, Python, Data export to pdf, TOPD, SQL and Data importing into UAT sites. Dealing with AWS S3, SFTP sites and BISCOM for data storage and Data Transfer. Scripting, root cause analysis and development of fixes during testing phase. Validating data and coordinating GO-Live activities...


  • Montréal, Canada Dialogue Full time

    Your role as Senior Product AnalystReporting the Senior Director of Product Management in the Member Experience group, you will contribute to Dialogue’s mission of improving the health and wellness of employees by defining and driving its member experience via data.More broadly, the Member Experience group is responsible for the entire journey of our...

  • Data Analyst

    1 month ago


    Montréal, QC, Canada Noverka Conseil Full time

    At Noverka, our values illustrate who we are and define our convictions: Human, Transparent, Passionate. We are driven by innovation and success, both in our relationships and in our practices. Finding the right job for the right person is what we do best! Our client, an insurance organization is looking for a Data Analyst. Job description : The Data...


  • Montréal, Canada Canadian National Railway Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you’re part of making sure our business is running optimally and safely―helping keep the economy on track. We welcome students who share their ideas, perspectives and understanding of new technologies with our teams. In return, we provide the opportunity...


  • Montréal, QC, Canada Hunter Bond Full time

    Data Analyst - Montreal - Up to $75,000 CAD + Bonus + Package Client: Elite FinTech Client Experience Level: 1+ years Salary: Up to $75,000 CAD + Bonus + Package Our elite FinTech client is looking for a Data Analyst to join their Event Analysis team. You will work on the analysis of post event data, reports and providing insight. Python experience...


  • Montréal, QC, Canada Hunter Bond Full time

    Data Analyst - Montreal - Up to $75,000 CAD + Bonus + PackageClient: Elite FinTech ClientExperience Level: 1+ yearsSalary: Up to $75,000 CAD + Bonus + PackageLocation: Montreal (hybrid)Role· Our elite FinTech client is looking for a Data Analyst to join their Event Analysis team. You will work on the analysis of post event data, reports and providing...

  • Data Analyst

    1 month ago


    Montréal, Canada Canadian National Railway Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you’re part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a...


  • Montréal, Canada Budge Studios Full time

    **Analyste de produits/Product Analyst **Responsabilités: - Effectuer des analyses afin de fournir des informations utiles qui aideront à prendre des décisions concernant les produits, le marketing et d'autres décisions de l'entreprise; - Optimiser les performances grâce à des tests A/B et multivariés; - Communiquer efficacement des informations par...


  • Montréal, QC, Canada Dialogue Full time

    Your role as Senior Product Analyst Reporting the Senior Director of Product Management in the Member Experience group, you will contribute to Dialogue’s mission of improving the health and wellness of employees by defining and driving its member experience via data. More broadly, the Member Experience group is responsible for the entire journey of our...

  • Data Analyst

    4 days ago


    Montréal, Canada Decathlon Canada Full time

    Decathlon is the largest sports retailer in the world. The Canadian branch was founded in 2018 and there are now 10+ stores across the country, with plans to expand even more in the future years. The artificial intelligence team in Canada, one of the largest in the company, is responsible for helping the country become more data driven, managing an API for...

  • Master Data Analyst

    2 days ago


    Montréal, Canada Canadian National Railway Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you're part of making sure our business is running optimally and safely helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a difference....

  • Data Analyst

    16 hours ago


    Montréal, Canada Samsung Ads Full time

    **Data Analyst** **Life at Samsung Ads** We are proud to build a world class organization that thrives on**:Collaborating closely, problem-solving, breaking new ground and adapting quickly to a rapidly evolving industry.** We are looking for a long-term contract (18 months), Data Analyst! We offer a **remote/hybrid work environment** made easy for you...