Early Careers: PSP Data & Analytics Associate Are you curious about the Insurance industry? This is a hybrid role with the flexibility to work both virtually and from our Montreal office. This role is not eligible for sponsorship, and we are unable to sponsor or take over sponsorship of an employment visa or work permit.
As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed. Maintaining and enhancing our in‑house applications built with C#, .NET and SQL Server, including adding new features, improving usability, and solve bugs raised by users. Fulfilling ad‑hoc data requests from colleagues by extracting, validating and formatting information from our systems for business, operational and reporting needs.
Building and supporting automation solutions (mail merge, Excel macros, C# utilities, Access queries, SQL 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 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. Documenting changes, processes and user guides to support knowledge transfer and provide clear references for both technical teams and non‑technical users. 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 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.
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;
Experience with C# and WPF using Visual Studio (academic, internship, or professional); Understanding of object‑oriented programming and development protocols; Solid understanding of SQL, preferably Microsoft SQL Server (basic queries, joins, 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 Robust Excel skills (formulas, functions, sorting/filtering) Experience integrating with Microsoft Office applications programmatically is an asset Basic understanding of SharePoint Experience with Kentico or Sitecore is an asset French / English bilingualism required due to frequent interactions with clients, colleagues, or partners based in Quebec, other Canadian provinces and/or internationally.
📌 Early Careers: PSP Data & Analytics Associate (Montreal)
🏢 Aon
📍 Montreal