Consultant, Data Analysis in Pension Administration
6 months ago
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 2542818
-
Consultant, Data Analysis in Pension Administration
6 months ago
Montréal, Canada Aon Corporation Full timePosting 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...
-
Consultant, Pension Administration
5 months ago
Montréal, Canada Aon Corporation Full timePosting 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 timePosting 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 timeConsultant, 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 timeTELUS 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 timeTELUS 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 Full timeDo 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...
-
Quality Assurance Consultant
5 months ago
Montréal, Canada Aon Corporation Full timePosting 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,...
-
Data Analyst
6 months ago
Montréal, Canada Aon Corporation Full timePosting 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 timeTELUS 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 timeTELUS 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 timeTELUS 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 timeTELUS 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 timeTELUS 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 timePosting 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
6 months ago
Montréal, Canada LifeWorks Full timeTELUS 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 timePosting 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 timePension 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 timeAt 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 timePension 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...
