Early Careers: PSP Data & Analytics Associate

Early Careers: PSP Data & Analytics Associate Are you curious about the Insurance industry? Interested in working with a team of experts who are generous with sharing their knowledge, and joining an industry leading, highly inclusive organization? This could be the perfect opportunity 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 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 team and we are passionate about helping our colleagues and clients succeed. What the day will look like Maintaining and enhancing our in‑house applications built primarily with C#, .NET and Microsoft SQL Server, including adding new features, improving usability, and solving bugs raised by users. Fulfilling ad‑hoc data requests from colleagues by writing and optimizing SQL queries to extract, validate and format information from our systems for business, operational and reporting needs. Building and supporting automation solutions (mail merge, Excel macros, C# utilities and SQL Server scripts) that streamline office workflows and improve efficiency. Acting as a liaison between business users and Aon IT, helping to translate user requirements into technical requests (e.g., application changes, folder or network access, permission updates). Partnering with Aon IT teams to coordinate and test system upgrades, patches and infrastructure changes, ensuring our C#/.NET and SQL Server–based applications remain stable and available with minimal downtime. Developing and maintaining business reports (for example, attendance and other key performance or operational reports) using tools such as Crystal Reports, Excel and SQL Server. Documenting changes, processes and user guides to support knowledge transfer and provide clear references for both technical teams and non‑technical users. Participating in regular team meetings to discuss priorities, review upcoming work, and contribute ideas for improving our systems and processes How this opportunity is different This role provides an opportunity to observe the full lifecycle of internal tools and applications, from understanding end‑user needs through composing, build, testing, deployment and ongoing support. You will have direct contact with business users, giving you a clear view of how your work improves efficiency and supports critical day‑to‑day operations. You will be working for a business unit supporting high profile clients in the professional services industries, operating in multiple insurance markets (US, UK, Bermuda, Canada) and will have the chance to interact with people from all those locations. We are a small team, you will gain broad, hands‑on experience across application development, data/reporting, automation and basic infrastructure coordination rather than being limited to a narrow specialization. You will work closely with experienced colleagues in both the business and Aon IT, with opportunities for mentorship, on‑the‑job learning and exposure to enterprise‑grade tools and environments. The systems you support are important to our business; you will quickly see the impact of your work and be encouraged to propose and implement improvements. Skills and experience that will lead to success Recent graduate with a Bachelor’s degree or diploma in Software engineering, Computer science, Programming specialization, Information technology specialization, Systems Administration, or a relevant field; Hands‑on experience with C# (preferably using WPF) in Visual Studio, including building and debugging desktop applications (academic, internship, or professional); Understanding of object‑oriented programming and development protocols; Solid understanding of SQL, with a strong preference for Microsoft SQL Server (writing queries, joins, basic performance tuning, and simple stored procedures); Experience with Microsoft Access for database queries, table design, and relationships Familiarity with HTML, CSS, and JavaScript for basic web pages and user interfaces Strong Excel skills (formulas, functions, sorting/filtering) Experience integrating C# applications with Microsoft Office (e.g., Excel, Outlook, Word) programmatically is an asset Basic understanding of SharePoint Experience with Kentico or Sitecore is an asset Good interpersonal and communication skills, both verbally and written; French / English bilingualism required due to frequent interactions with clients, colleagues, or partners based in Quebec, other Canadian provinces and/or internationally. High discernment and professional presentation skills. Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate. #AonLaunchCanada #LI-KT2 2585906

The associate will maintain and enhance in-house applications using C#, .NET, and SQL while fulfilling ad-hoc data requests and building automation solutions. They will also act as a liaison between business users and IT to coordinate system upgrades and provide technical support.

Candidates must have a Bachelor’s degree or diploma in a relevant technical field such as Software Engineering or Computer Science. Proficiency in C#, SQL, and Microsoft Office applications is required, along with bilingualism in English and French.

• HTMLSouhaitée
• SQLSouhaitée
• CSSSouhaitée
• Microsoft ExcelSouhaitée
• SharePointSouhaitée
• JavaScriptSouhaitée
• .NETSouhaitée
• Communication SkillsSouhaitée
• C++Souhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• C#
• .NET
• SQL Server
• WPF
• Visual Studio
• Object-oriented programming
• SQL
• Microsoft Access
• HTML
• CSS
• JavaScript
• Excel
• SharePoint
• Communication skills
• Bilingualism
• Data Reporting
• Professional Presentation
• Insurance Industry
• Sitecore (Software)
• Workflow Management
• Curiosity
• Bilingual (French/English)
• Knowledge Transfer
• HyperText Markup Language (HTML)
• JavaScript (Programming Language)
• .NET Framework
• Microsoft Excel
• Access Network
• Application Development
• Automation
• C# (Programming Language)
• Cascading Style Sheets (CSS)
• Communication
• Computer Science
• Information Technology
• Crystal Reports (Reporting Software)
• Database Queries
• System Administration
• Excel Macros
• Mentorship
• Microsoft Visual Studio
• Microsoft Office
• Windows Presentation Foundation
• Microsoft SQL Servers
• Operations
• Microsoft SharePoint
• Software Engineering
• Sorting
• Stored Procedure
• SQL (Programming Language)

• Technology
• Software
• Data & Analytics
• Consulting
• Data Analytics Associate
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists

Formation minimale

Baccalauréat

Expérience minimale

0+ ans

Postuler avant le

14 août 2027

Langue de l’offre

anglais

Heures de travail

40 heures par semaine