Consultant, Data Analysis in Pension Administration

5 months ago

Montréal, Canada Aon Corporation Full time

Posting 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

Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

LI-AM3

LI-HYBRID

  • Consultant, Data Analysis in Pension Administration

    5 months ago

    Montréal, 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...

  • Consultant, Pension Administration

    4 months ago

    Montréal, Canada Aon Corporation Full time

    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 virtually and from our Montreal office. - Applicants must be legally authorized to work in...

  • Consultant, Defined Benefit Pension Plan

    5 months ago

    Montréal, Canada Aon Corporation Full time

    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 virtually and from our Montreal office. **_ Applicants must be legally authorized to work...

  • Consultant, Defined Benefit Pension Plan

    5 months ago

    Montréal, 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 role is not...

  • Technician, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Quality Assurance Consultant

    5 months ago

    Montréal, Canada Aon Corporation Full time

    Posting Description: Do you have experience in pension administration? Do you enjoy project work, analysis of data and testing? This could be the role for you! This is a hybrid role with the flexibility to work both virtually and from our Montreal office. Applicants must be legally authorized to work in Canada. This role is not eligible for sponsorship,...

  • Quality Assurance Consultant

    5 months ago

    Montréal, Canada Aon Full time

    Do you have experience in pension administration? Do you enjoy project work, analysis of data and testing? This could be the role for you! This is a hybrid role with the flexibility to work 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...

  • Data Analyst

    5 months ago

    Montréal, Canada Aon Corporation Full time

    Posting 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 Analyst for our implementation team within pension...

  • Technician, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Associate Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Associate Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Associate Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks 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...

  • Associate Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks 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...

  • Pension Requirements Analyst

    5 months ago

    Montréal, Canada Aon Corporation Full time

    Posting Description: **Pension Requirements Analyst** Do you have a background in pension administration and an ability to summarize (and sometimes challenge) complex procedures? 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 Requirements Analyst (consultant...

  • Associate Consultant, Pension Administration

    5 months ago

    Montréal, Canada LifeWorks Full time

    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, mental and financial health - TELUS Health is improving health outcomes for...

  • Pension Implementation Requirements Analyst

    5 months ago

    Montréal, Canada Aon Corporation Full time

    Posting Description: **Pension Requirements Analyst** Do you have a background in pension administration and an ability to summarize (and sometimes challenge) complex procedures? 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 Pension Requirements Analyst...

  • Pension Implementation Requirements Analyst

    5 months ago

    Montréal, Canada Aon Full time

    Pension Requirements Analyst Do you have a background in pension administration and an ability to summarize (and sometimes challenge) complex procedures? 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 Pension Requirements Analyst (consultant level) for our...

  • Manager Pension

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

  • Pension Plan Administrator

    5 months ago

    Montréal, Canada Canada Life Assurance Company Full time

    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 role you’ll contribute to the effective record-keeping and reporting for GRS...