Consultant, data analysis in pension administration

3 weeks ago


Montreal, Canada Aon Full time

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



  • Montreal, Canada Aon Hewitt Full time

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


  • Montreal, Canada Aon Full time

    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 office. Applicants must be legally authorized to work in Canada. This...


  • Montreal, Canada Aon Hewitt Full time

    Consultant, Defined Benefit Pension AdministrationDo 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 office.Applicants must be legally authorized to work in Canada. This role is not...


  • Montreal, Canada Aon Corporation Full time

    Consultant, Defined Benefit Pension AdministrationDo 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 office.Applicants must be legally authorized to work in Canada. This role is not...


  • Montreal, Quebec, Canada Aon Corporation Full time

    Consultant, Defined Benefit Pension AdministrationDo 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 office.Applicants must be legally authorized to work in Canada. This role is not...


  • Montreal, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Quebec, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Quebec, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Quebec, Canada Mercer Full time

    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, where you were raised or born, who you love or what your religious beliefs are. You...


  • Montreal, Quebec, Canada Mercer Full time

    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, where you were raised or born, who you love or what your religious beliefs are. You are welcome...


  • Montreal, Quebec, Canada Mercer Full time

    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, where you were raised or born, who you love or what your religious beliefs are. You are welcome...


  • Montreal, Canada Analysis Group Full time

    Overview The Analyst Intern-Health Care position is a paid opportunity for students interested in a 6-month international internship in Canada. While the internship takes place at Analysis Group’s office in Montreal, analyst interns are evaluated for full-time return offers at the Paris office. About Analysis Group’s HEOR Practice: Analysis...


  • Montreal, Quebec, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Quebec, Canada Mercer Full time

    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, where you were raised or born, who you love or what your religious beliefs are. You are welcome here....


  • Montreal, Quebec, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Canada Aon Full time

    Actuarial Configuration Specialist - Pension Administration Are you an actuarial analyst who also has strong analytical and computer skills? Do you enjoy looking into the details and have a highly developed ability to apply all the capabilities of software tools? Are you looking to take part in long-term projects for leading Canadian plans? Then...


  • Montreal, Quebec, Canada LifeWorks Inc. Full time

    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 provider - encompassing physical, mental and financial health - TELUS Health is...


  • Montreal, Canada Mercer Full time

    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, where you were raised or born, who you love or what your religious beliefs are.  You are...