Job Information
AON Consultant, data analysis in pension administration in Montreal, Canada
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.
We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email ReasonableAccommodations@Aon.com
#LI-AM3
#LI-HYBRID
2542818
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.
We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email ReasonableAccommodations@Aon.com
#LI-AM3
#LI-HYBRID