Jobs
>
Montréal

    Consultant, data analysis in pension administration - Montreal, Canada - Aon

    Aon
    Default job background
    Full time
    Description

    Are you thrilled by data mining, data transformation and analytics? Are you interested in learning pension administration? Are you looking to work on long-term projects for leading Canadian plans? Aon has the opportunity you have been waiting for

    Aon is looking for a Data Consultant for our implementation team within pension administration. The team collaborates with internal teams to implement and support solutions for clients. This is an excellent opportunity for an analyst looking to familiarize with pension administration OR an experienced pension administration colleague with proven data management abilities.

    This is a hybrid role working both virtually and from our Montreal office.

    Applicants must be legally authorized to work in Canada. This role is not eligible for sponsorship, and we are unable to sponsor or take over sponsorship of an employment visa or work permit.

    Aon is in the business of better decisions

    At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organization, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.

    What the day will look like

    Develop and Implement Strategies:

  • Create and implement data conversion strategies and plans.
  • Analyze and map data from different sources to the desired target systems.
  • Data Accuracy and Completeness:

  • Ensure data accuracy and completeness during the conversion process.
  • Perform data cleansing and transformation activities as needed.
  • Collaborate with cross-functional teams to identify and resolve any data conversion issues.
  • Documentation:

  • Maintain documentation of data mappings and conversion processes.
  • Produce reconciliation and validation reports.
  • Support and Troubleshooting:

  • Provide operational support and troubleshooting during data conversion.
  • Participate in peer reviews and inspections of requirements documents, functional/technical designs, and code.
  • Create migration packages and develop scripts for data and code objects to be migrated across instances.
  • How this opportunity is different

    Our highly collaborative team drives innovation through ideas and implementation of solutions that allow an enhanced digital member experience and more efficient internal processing. You will have the ability to take part in exciting projects which help redefine the Canadian pension administration services.

    Skills and experience that will lead to success

  • BS or BA degree in computer science or related field, or equivalent experience
  • Strong understanding of database structures (tables, temp tables, stored procedures and user-defined functions)
  • Experience with scripting languages like VBA, VBS or other equivalent.
  • Experience with MS SQL and SSIS or other data-loading software
  • Knowledge of Pension and/or Benefits Administration is an asset
  • Bilingualism (French/English) is an asset
  • Organized and thorough
  • Team-oriented but able to self-motivate and direct
  • Able to communicate and inform team members of status, progress and challenges
  • Capable of problem identification and resolution
  • Able to learn from others and adapt to standards
  • Able to express complex technical concepts effectively, both verbally and in writing
  • Occasional evening and weekend work to meet timelines.
  • Frequent computer use for extended periods.
  • Access information using a computer and related components and peripherals.
  • Participation in training sessions, presentations, and meetings.
  • How we support our colleagues

    In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two "Global Wellbeing Days" each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working



  • Mercer Montréal, Canada

    **Senior Associate** · At Mercer, we're creating a culture where you can bring your authentic self to work. When you join us, you bring your inclusive energy and enthusiasm to a team that values you personally and professionally - regardless of who you are, what you look like, wh ...


  • Mercer Montréal, Canada

    Job Description For Posting · At Mercer, we're creating a culture where you can bring your authentic self to work. When you join us, you bring your inclusive energy and enthusiasm to a team that values you personally and professionally - regardless of who you are, what you look l ...


  • Willis Towers Watson Montréal, Canada

    Associate, Pension Administration · - Montreal, CA · June 14, 2023 · **The Role** · As an Associate in our Pension Administration Group, you will perform a wide variety of recurring defined benefit plan administration services for clients, contribute to special projects, and prov ...


  • Mercer Montréal, Canada

    **Pension Administration Analyst Internship** · **What can you expect?** · - Are you looking to join a team that accomplishes outstanding and innovative work? Mercer is the global leader for trusted HR and related financial advice, products, and services. In our work with clients ...


  • Aon Corporation Montréal, Canada

    Posting Description: · **Consultant, Defined Benefit Pension Administration**: · Do you have experience in pension administration? Do you want to work alongside industry leaders? Then Aon has the opportunity for you · This is a hybrid position with the ability to work both virtua ...


  • Aon Montréal, Canada

    Consultant, Defined Benefit Pension Administration · Do you have experience in pension administration? Do you want to work alongside industry leaders? Then Aon has the opportunity for you · This is a hybrid position with the ability to work both virtually and from our Montreal of ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • WTW Montréal, Canada

    **The Role** · As an Associate in our Pension Administration Group, you will perform a wide variety of recurring defined benefit plan administration services for clients, contribute to special projects, and provide ad hoc client support services. You will serve as the day to day ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • Willis Towers Watson Montréal, Canada

    Consultant, Pension Administration · - Montreal, CA · June 13, 2023 · As a Consultant in our Pension Administration Group, you will perform a wide variety of recurring defined benefit plan administration services for clients, contribute to special projects, and provide ad hoc cli ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • Mercer Montréal, Canada

    **Our Work** · **What can you expect?** · - Are you looking to join a team that accomplishes outstanding and innovative work? Mercer is the global leader for trusted HR and related financial advice, products, and services. In our work with clients, we make a positive impact on th ...


  • LifeWorks Montréal, Canada

    Build a meaningful career · At LifeWorks, we offer more than career opportunities, we provide career opportunities to make meaningful contributions to people's lives. The extraordinary expertise of a more than 7,000-strong workforce is harnessed to support the employees and famil ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • Canada Life Assurance Company Montréal, Canada

    Pension plan Administrator · **Description: · - Permanent Full Time- Group Retirement Services (GRS) Administration provides administration services for a variety of group products, including RRSP, RPP, DPSP, TFSA, Investment Only and various non-registered plan types. In this ro ...


  • LifeWorks Montréal, Canada

    TELUS Health is empowering every person to live their healthiest life. Guided by our vision, we are leveraging the power of our leading edge technology and focusing on the uniqueness of each individual to create the future of health. As a global-leading health and well-being prov ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...


  • LifeWorks Montréal, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...