Are you thrilled by data mining, data transformation and analytics? Are you interested in learning pension administration? Are you looking to work on short and/or long-term projects for leading Canadian plans? Aon has the opportunity you have been waiting for! Aon is looking for a Senior Database Analyst for our implementation team within pension administration. The team collaborates with internal teams and/or client teams to implement and support solutions for clients. This is an excellent opportunity for a data 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 The Senior Data Analyst will be analyzing, documenting, mapping, coding and loading data into Aon's proprietary Pension and Benefits Administration systems based on client requirements. They will also be testing the data loading and debugging issues/defects before data is moved to production. They will also be: Working on the different aspects of the Extraction Transformation Landing (ETL) process Reviewing the project requirements to ensure completeness of requirements from a design and testing perspective Recovering data tables and coding scripts to convert legacy databases to a new system Documenting data integrity reports (reconciliation/validation) Identifying and fixing database issues Leading all aspects of day-to-day work per priorities Building reports 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 Bachelor's degree in computer science, math, or equivalent work experience in an analytical area Excellent understanding of database structures (tables, temporary tables, storing procedures, user operations) Pension work experience desired Strong computer skills (Excel, Word) Ability to interpret and understand requirements documentation Is analytical, organized and proactive Keen attention to detail French / English bilingualism required due to frequent interactions with clients, colleagues, or partners based in Quebec, other Canadian provinces and/or internationally. 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 2555786