Data Production Analyst

7 days 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 NTT DATA Full time

    **Req ID**:228247 We are currently seeking a **Technical Product Owner - Data Solutions Analyst - Remote Canada Position** to join our team in Toronto, Ontario (CA-ON), Canada (CA). **How You'll Help Us**: As a Product Owner, you hold a key role on our Scrum teams by representing the interests of the business. Through working with stakeholders, you ensure...

  • Business Analyst

    1 week ago


    Montréal, Canada NTT DATA Full time

    Job Description **Company Overview**: **Req ID**: 232962 We are currently seeking a Bus. Systems Analyst - Agile to join our team in montreal, Quebec (CA-QC), Canada (CA). Business Analyst (IAM) + Agile Working in the Customer Identity & Access Management (CIAM) Fleet, the Business Analyst works in the Agile Squad using the Agile methodology with the...


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


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


  • Montréal, Canada NTT DATA Full time

    **Job Description**: We are currently seeking an **IAM Authentication Business Analyst - L3** to join our team in Montreal, Quebec (CA-QC), Canada (CA). **Position Overview**: - This position is on the Identity & Access Management (IAM) team in the Cyber Data Risk & Resilience organization. - Work closely with key stakeholders under the supervision of the...

  • Data Analyst

    2 months 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

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

  • Data Analyst

    6 days ago


    Montréal, Canada Sanimax Full time

    Your professional transformation starts here Are you full of great ideas? Do you dream of building a greener future as part of a company that values your skills and opinions? Are you looking for a flexible employer that will give you the opportunity to grow within the company? This job is for you! As part of our ongoing growth, we seek a highly motivated...

  • Data Analyst

    2 weeks ago


    Montréal, Canada National Bank of Canada Full time

    A career in data analytics and mainly in the IT - Wealth Management and Brokerage Operations sector allows you to put forward your passion for business intelligence. You have the opportunity to provide data to support or enhance the Bank's customer experience. As part of an experienced team dedicated to data, you can influence decision-makers through your...

  • Data Analyst, It

    2 months ago


    Montréal, Canada Studentcare Full time

    **Who we are**: ASEQ|Studentcare is the Canadian leader in health, dental and travel insurance for students across Quebec and Canada. We offer university and college students group insurance plans and other non-insurance products such as Student Assistance Programs (SAP) and telemedicine at attractive costs. Our objective is to make insurance easy and simple...


  • Montréal, Canada Air Canada Full time

    **Description** **Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.** The Product Manager, Data product is responsible for defining, prioritizing, and managing the backlog...

  • Data Analyst

    3 weeks ago


    Montréal, Canada National Bank of Canada Full time

    A career as a Data Analyst in the Corporate Development and Business Management team at National Bank is to ensure the successful execution and implementation of the strategic initiatives and projects as set by Corporate & Investment Banking (CIB) Executive Management. We are looking for a data analyst to assist in the data management and analysis valuation...


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

  • Product Analyst

    5 days ago


    Montréal, Canada Aylo Careers Full time

    Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet's safest and most popular platforms. With the support of an international team of dynamic and collaborative innovators, we are on a mission to enable safe user experiences and empower our communities by celebrating diversity, inclusion, and...

  • IT Support Analyst

    3 weeks ago


    Montréal, Canada Estruxture Data Centers Full time

    ** La version française suit la version anglaise. Cependant, le responsable du recrutement pour ce poste étant anglophone, veuillez soumettre votre curriculum vitae en anglais. **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an award-winning industry leader, our...

  • IT Support Analyst

    1 week ago


    Montréal, Canada Estruxture Data Centers Full time

    ** La version française suit la version anglaise. Cependant, le responsable du recrutement pour ce poste étant anglophone, veuillez soumettre votre curriculum vitae en anglais. **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an award-winning industry leader, our...

  • Data Analyst

    6 days ago


    Montréal, Canada MindGeek Careers Full time

    **Title: Data Analyst - User Journey** As a Data Analyst - User journey, you have a crucial role in extracting meaning from the mountain of data that our products generate. To do so, you will create advanced dashboards, build reports, dig into the data, and analyze trends. Working with a large-scale data lake platform that ingest billions of requests per...

  • Data Analyst

    2 weeks ago


    Montréal, Canada MaintainX Full time

    MaintainX is the world leading mobile-first workflow management platform for industrial and frontline workers. We are a modern IoT enabled cloud based tool for maintenance, safety, and operations on equipment and facilities. MaintainX powers operational excellence for 4,000+ businesses including Univar, Quikrete, ABInBev, Duracell, Marriott and...

  • Data Analyst

    2 months ago


    Montréal, Canada McGill University Full time

    Please refer to the job aid for instructions on how to apply. Under the direction of the project leader, the Data Analyst is responsible for creating business and functional requirements for the technological platform of the BRILLIANT project. Working with other members of the team and stakeholders, the qualified person will perform a variety of...

  • Analyst, People

    2 months ago


    Montréal, Canada Estruxture Data Centers Full time

    La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the country, over 760,000 square feet of space, over 130MW of power and access to over 1,400 network and cloud...