Senior IT Business Analyst

Marsh; Toronto; Hybrid; CAD 143,000 - 213,000; Full time

Benefits offered by this job

Health and welfare benefits

Tuition assistance

Retirement programs

Employee assistance programs

Job summary

Marsh in Toronto, Canada, seeks a Senior IT Business Analyst to support the Affinity & Program business. The role is hybrid, requiring three days in the office weekly, with a focus on program policy renewals and data capture, policy rating, and document generation.

You will translate business needs into technical specs, manage tickets in ADO, and coordinate UAT with business users and the COE Call Centre. Strong Excel, SQL, and Velocity knowledge are expected.

Qualifications

• Advanced knowledge of insurance/brokerage operations and program renewals.
• 4+ years as a Senior IT Business Analyst managing end-to-end renewals.

Responsibilities

• Collaborate with stakeholders to gather and document requirements for Program Policy renewals.
• Translate business needs into technical specs for client data, policy rating, and document/report generation (quotes, packages, bordereaux, certificates).
• Communicate requirements to Dev and QA using ADO tickets and track prioritization.
• Support data migration into the Velocity brokering system using data analysis tools.
• Develop test data and test cases for User Acceptance Testing (UAT) and coordinate with business users and COE Call Centre.
• Create process maps showing current workflows and future state changes.
• Conduct functional and system integration testing and troubleshoot issues.
• Manage communications with clients and end users and generate renewal completion metrics reports.

Skills

Advanced Excel

SQL knowledge

Stakeholder communication

UAT coordination

Change management

Self-management

French/English bilingual

Tools

Velocity

ADO

Job description

We are seeking a talented individual to join our team at Marsh. This role will be based in Toronto, Canada. This is a hybrid role that has a requirement of working at least three days a week in the office.

This role will provide critical support to the Affinity & Program business in Canada. This role offers the opportunity to work within a dynamic, cross-regional team dedicated to driving program renewals and new business initiatives.

We will count on you to:

• Collaborate with business stakeholders to gather and document detailed requirements, focusing on Program Policy renewals.
• Translate business needs into technical specifications for client application data capture, policy rating, and document/report generation (e.g., quotes, policy packages, bordereaux, certificates of insurance).
• Communicate requirements clearly to Development and QA teams using the ADO Ticketing System, tracking and prioritizing tickets to meet project deadlines.
• Utilize data analysis tools to support client and application data migration into the Brokering System (Velocity).
• Develop test data and comprehensive test cases to facilitate User Acceptance Testing (UAT), coordinating UAT activities with business users and the COE Call Centre team.
• Create process maps to illustrate current workflows and proposed future state changes.
• Conduct functional and system integration testing to validate solutions and troubleshoot issues for timely resolution.
• Manage communications with clients and end users, and generate system reports tracking client renewal completion metrics.

What you need to have:

• Advanced knowledge of the insurance and brokerage industry with a strong background in Program Business operations.
• 5+ years of experience as a Senior IT Business Analyst, managing Program Renewals end-to-end.
• Familiarity with and adherence to Change Management processes.
• Proficient in Microsoft Excel at an advanced level.
• Excellent written and verbal communication skills, with experience conducting end-user training alongside business partners.
• Strong self-management and organizational skills.

What makes you stand out:

• Direct experience with insurance Program Policy renewals and familiarity with Broker Management Systems, particularly Velocity.
• Advanced Excel skills (including VLOOKUP, HLOOKUP, and complex functions), strong data analysis, manipulation, extraction, merging abilities, and working knowledge of SQL and database management.
• Bilingual proficiency in French and English is highly desirable.

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have an impact on colleagues, clients and communities.
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

Marsh (NYSE: MRSH) is a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit marsh.com, or follow us on LinkedIn and X.

Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005, Marsh will provide a reasonable accommodation to employees and prospective employees to the point of undue hardship upon request and as required in respect of the individual’s particular restrictions and limitations. If you require a specific accommodation because of a disability or medical need, please contact [e-mail].

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one "anchor day" per week on which their full team will be together in person.

The applicable base salary range for this role is $102,600 to $152,600.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, retirement programs as well as employee assistance programs.

This is a Replacement position.