Back to jobs

Business Systems Analyst, Systems & Data Transformation

Pay
$119,000–139,000/year · BasePlus bonus — pay source
Employee Referral Program and Recognition Program Our base salary range for this role is between $119,000 and $139,000 per year, plus an opportunity for an annual company bonus based upon a percentage of eligible pay. The salary estimate displayed represents the typical salary range for candidates hired in this position. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have, and comparison to internal equity. This role is located in our Toronto office on 390 Bay St, and we operate in a hybrid work model. This job posting is for an existing vacancy.
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Elicit and document business, functional and data requirements, including BRDs and user stories

  • Write and interpret SQL queries for data validation, reconciliation and root-cause analysis

  • Validate data migrations, mappings and conversions across source and target systems

  • Define test scenarios and support SIT, UAT and regression testing

  • Act as liaison between business users and technical teams, presenting findings to senior stakeholders

From the employer’s posting
Elicit, analyze, document, and validate business, functional, non-functional, data, integration, and reporting requirements from stakeholders.
Write and interpret SQL queries for data analysis, validation, reconciliation, root-cause analysis, and operational reporting.
Validate data migration, data mapping, conversion, transformation, and reconciliation activities across source and target systems.
Define and review test scenarios, test cases, acceptance criteria, expected results, and regression coverage based on business and system requirements.
Act as a liaison between business users and technical teams.

What you’ll bring

All qualifications

Core experience

  • 6+ years of experience as a Business Systems Analyst, Systems Analyst, or technically oriented Business Analyst.
  • Experience with data mapping, interface specifications, source-to-target mapping, data lineage, and business rules documentation.
  • Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or a related field.
  • Knowledge of ETL processes.
  • 3 to 5+ years of experience within the Canadian insurance industry or a closely related regulated financial services environment.
  • Strong SQL expertise for data analysis, validation, reconciliation, troubleshooting, and reporting.

Preferred experience

  • Experience with Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar Canadian insurance platforms.
  • Communication & Presentation Skills
  • Knowledge of cloud platforms, data warehouses, enterprise reporting solutions, document management systems, workflow platforms, and integration technologies.
  • Experience with API integrations and microservices architecture.
Qualification wording
6+ years of experience as a Business Systems Analyst, Systems Analyst, or technically oriented Business Analyst.
Experience with data mapping, interface specifications, source-to-target mapping, data lineage, and business rules documentation.
Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or a related field.
Knowledge of ETL processes.
3 to 5+ years of experience within the Canadian insurance industry or a closely related regulated financial services environment.
Strong SQL expertise for data analysis, validation, reconciliation, troubleshooting, and reporting.
Experience with Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar Canadian insurance platforms.
Communication & Presentation Skills
Knowledge of cloud platforms, data warehouses, enterprise reporting solutions, document management systems, workflow platforms, and integration technologies.
Experience with API integrations and microservices architecture.
Education & alternatives
Education - Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or a related field. - Relevant certifications in Business Analysis, Business Systems Analysis, Insurance, Agile methodologies, or technology delivery are preferred.
Apply at Munich Re

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 13, 202636 days ago
Recorded sightings
118
Last seen by us
Nov 18, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 36

Similar jobs usually come down between day 5 and day 43.

At Munich Re, jobs usually come down by about day 34.

From 15,291 similar postings that came down, and 60 of Munich Re’s. Coming down is not always a hire.

Munich Re is hiring

24 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Analyst hiring is picking up
  • Takes jobs down at a usual pace
  • 8% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Databricks
  • Excel
  • Power BI
  • SQL Server
  • Tableau
Where the posting names them
The successful candidate will possess strong Business Systems Analyst experience within the Canadian insurance industry, with the ability to bridge business needs and technology delivery across policy administration, underwriting, claims, finance, engineering, inspections, data integrations, and vendor implementations. The role requires systems-level analysis, clear functional and technical documentation, SQL-based data validation, and effective collaboration with business stakeholders, architects, developers, QA teams, operations teams, and vendor partners. Job Responsibilities
3. Data, Systems & Integration Analysis - Write and interpret SQL queries for data analysis, validation, reconciliation, root-cause analysis, and operational reporting. - Analyze large datasets to identify trends, anomalies, and business insights.
- Validate data migration, data mapping, conversion, transformation, and reconciliation activities across source and target systems. - Support UAT, SIT, production issue investigations, defect triage, and data-related incident analysis using SQL, logs, interface files, and system documentation. - Analyze APIs, batch processes, message flows, data feeds, reference data, and downstream reporting impacts related to system changes.
- Experience with data mapping, interface specifications, source-to-target mapping, data lineage, and business rules documentation. - Strong SQL expertise for data analysis, validation, reconciliation, troubleshooting, and reporting. - Experience querying databases.
- Databricks - SQL Server - JIRA
Tools & Technologies - Databricks - SQL Server
- Microsoft Visio - Microsoft Excel - Insurance platforms and core systems such as Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar policy, claims, billing, underwriting, and reinsurance platforms
- Knowledge of ETL processes. - Experience with reporting tools such as Power BI or Tableau. - Exposure to DevOps and CI/CD pipelines.

Your next step

Complete your application on careers.munichre.com. The employer’s form will show what is required.

Applying through Radancy (TalentBrew)

  • Radancy (TalentBrew) runs the employer’s careers site, but the application itself usually runs on another system, often Workday or Taleo. The advice for that system applies once you click Apply.

Already applied? Track this application

Job description

View original posting ↗

HSB Canada, part of Munich Re, is Canada's premier engineering-driven specialty insurer, bringing deep technical expertise to help clients stay ahead of complex, emerging, and technology-based risks. We combine specialty insurance with inspection, engineering, and technology-enhanced services to redefine risk protection, with leading capabilities across cyber, equipment breakdown, renewable energy, and IoT technology services.

Backed by Munich Re, one of the world's most experienced and financially stable insurance and reinsurance groups, HSB Canada combines global strength with deep knowledge of the Canadian market. Building on a long legacy of innovation and technical excellence, we continue to evolve our capabilities to address modern and emerging risks, from cyber and artificial intelligence to connected technologies.


Primary Objectives

The successful candidate will possess strong Business Systems Analyst experience within the Canadian insurance industry, with the ability to bridge business needs and technology delivery across policy administration, underwriting, claims, finance, engineering, inspections, data integrations, and vendor implementations.
The role requires systems-level analysis, clear functional and technical documentation, SQL-based data validation, and effective collaboration with business stakeholders, architects, developers, QA teams, operations teams, and vendor partners.


Job Responsibilities

1. Business Systems Analysis & Requirements Management

  • Elicit, analyze, document, and validate business, functional, non-functional, data, integration, and reporting requirements from stakeholders.
  • Conduct workshops, interviews, and requirements elicitation sessions.
  • Create and maintain BRDs, user stories, use cases, acceptance criteria, process flows, data flow diagrams, interface specifications, and traceability matrices.
  • Translate business needs into clear system requirements and solution-ready specifications for technology delivery teams.
  • Perform impact analysis for proposed changes and enhancements.
  • Ensure traceability of requirements throughout the project lifecycle.
  • Assess current-state and target-state systems, data flows, integration points, controls, and operational impacts across insurance platforms.
  • Experience working within Agile and Waterfall environments.

2. Canadian Insurance Domain Expertise

  • Analyze and support business processes related to:
    • Policy Administration
    • Claims Management
    • Underwriting
    • Billing and Payments
    • Renewals and Endorsements
    • Insurance Product Configuration
  • Work closely with business users to improve operational efficiency.
  • Support Canadian regulatory, compliance, privacy, audit, and operational risk initiatives affecting insurance products, processes, data, and technology controls.
  • Understand Canadian P&C insurance, specialty insurance, and reinsurance, including:
    • Policy lifecycle
    • Claims lifecycle
    • Underwriting rules
    • Billing processes
    • Renewals and endorsements
    • Broker and customer servicing models

3. Data, Systems & Integration Analysis

  • Write and interpret SQL queries for data analysis, validation, reconciliation, root-cause analysis, and operational reporting.
  • Analyze large datasets to identify trends, anomalies, and business insights.
  • Work with database teams to review stored procedures, packages, triggers, functions, and views.
  • Validate data migration, data mapping, conversion, transformation, and reconciliation activities across source and target systems.
  • Support UAT, SIT, production issue investigations, defect triage, and data-related incident analysis using SQL, logs, interface files, and system documentation.
  • Analyze APIs, batch processes, message flows, data feeds, reference data, and downstream reporting impacts related to system changes.

 

4. Application & Technical Collaboration

  • Collaborate with development teams on system and data-related projects.
  • Understand application architecture and integration points.
  • Participate in solution design discussions and provide functional input.
  • Review technical designs to ensure alignment with business requirements.
  • Coordinate with developers, architects, QA teams, and project managers.

 

5. Delivery, Testing & Quality Assurance

  • Define and review test scenarios, test cases, acceptance criteria, expected results, and regression coverage based on business and system requirements.
  • Support SIT, UAT, and regression testing activities.
  • Perform requirements validation and defect triage.
  • Ensure delivered solutions meet business expectations, system design intent, data quality standards, Canadian regulatory obligations, and operational readiness requirements.

 

6. Stakeholder Management

  • Act as a liaison between business users and technical teams.
  • Conduct project status meetings and requirements walkthroughs.
  • Present findings, recommendations, and business cases to senior stakeholders.
  • Manage stakeholder expectations and proactively address business concerns.

 

Qualifications

  • 6+ years of experience as a Business Systems Analyst, Systems Analyst, or technically oriented Business Analyst.
  • 3 to 5+ years of experience within the Canadian insurance industry or a closely related regulated financial services environment.
  • Proven experience supporting large-scale system implementations, modernization initiatives, integrations, migrations, enhancements, or vendor platform projects.
  • Strong Canadian insurance domain knowledge.

 

Technical & Systems Skills

  • Experience with data mapping, interface specifications, source-to-target mapping, data lineage, and business rules documentation.
  • Strong SQL expertise for data analysis, validation, reconciliation, troubleshooting, and reporting.
  • Experience querying databases.
  • Knowledge of stored procedures, packages, triggers, and views.
  • Understanding of application architecture, web applications, APIs, integration patterns, batch processing, data models, and enterprise system design.
  • Knowledge of REST APIs, SOAP services, file-based integrations, messaging platforms, and system-to-system data exchanges.

 

Tools & Technologies

  • Databricks
  • SQL Server
  • JIRA
  • Confluence
  • Microsoft Visio
  • Microsoft Excel
  • Insurance platforms and core systems such as Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar policy, claims, billing, underwriting, and reinsurance platforms

 

Preferred Qualifications

  • Experience with Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar Canadian insurance platforms.
  • Knowledge of cloud platforms, data warehouses, enterprise reporting solutions, document management systems, workflow platforms, and integration technologies.
  • Experience with API integrations and microservices architecture.
  • CBAP, CCBA, PMP, or Agile certifications.
  • Prior experience working with distributed or offshore teams.

 

Key Competencies

  • Requirements Gathering & Analysis
  • Business Process Modeling
  • Stakeholder Management
  • Insurance Domain Expertise
  • Systems Analysis, Data Analysis & Validation
  • Integration Analysis & Technical Documentation
  • Problem Solving
  • Communication & Presentation Skills
  • Agile Methodology
  • Risk Analysis
  • Documentation & Reporting

 

Education

  • Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or a related field.
  • Relevant certifications in Business Analysis, Business Systems Analysis, Insurance, Agile methodologies, or technology delivery are preferred.

 

Nice-to-Have Skills

  • Knowledge of ETL processes.
  • Experience with reporting tools such as Power BI or Tableau.
  • Exposure to DevOps and CI/CD pipelines.
  • Experience working with microservices and event-driven architectures.
  • Basic understanding of XML, JSON, and XSD schemas.
 
 
 

 

Company Benefits:

Together, we engage with everything we have and are, to help humankind act braver and better. Go further with HSB.

We are pleased to offer our employees great benefits and resources to support their mental, physical and financial wellbeing. These include:

  • An engaging and collaborative environment that promotes continuous learning and development
  • A hybrid work environment that combines weekly in-office and remote days
  • A great compensation package including an annual company bonus
  • Competitive company-paid flexible health and dental benefits, starting on your first day
  • Flexible dollars provided by the company to put towards a Health Spending Account and/or Wellness Spending Account
  • Wellness program with tools and resources supporting your mental, physical, and financial wellbeing – on and off the job
  • Participation in the DC Pension Plan with a progressive employer contribution scale based on tenure starting at 4%, plus optional company match in the RRSP plan
  • Generous time off including vacation, personal days, unplanned time, Statutory Holidays and company-wide early closure half-days
  • Learning and development programs and resources, including unlimited access to LinkedIn Learning, Education Assistance Program, and reimbursement for professional fees
  • Employee Referral Program and Recognition Program

 

Our base salary range for this role is between $119,000 and $139,000 per year, plus an opportunity for an annual company bonus based upon a percentage of eligible pay. The salary estimate displayed represents the typical salary range for candidates hired in this position. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have, and comparison to internal equity.


This role is located in our Toronto office on 390 Bay St, and we operate in a hybrid work model. This job posting is for an existing vacancy. 


We do not use AI in our recruitment process - applications are reviewed by our team to ensure a fair and personalized experience.


HSB Canada is committed to providing a work environment that is inclusive and free of employment barriers and discrimination.  Accommodations will be made for qualified applicants with a disability throughout the recruitment process.  If you receive a request for an interview and you have a disability which will require an accommodation to support your participation, please consult with Human Resources or contact hr@hsb.ca as soon as practical so that suitable accommodations can be arranged.


We thank all candidates for their interest; however only those selected for interview will be contacted.

 

Demand for Analyst roles

New Analyst postings at the employers we follow are up 25% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 990, the most 1,513, and the latest week had 1,366.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Employee Referral Program and Recognition Program Our base salary range for this role is between $119,000 and $139,000 per year, plus an opportunity for an annual company bonus based upon a percentage of eligible pay. The salary estimate displayed represents the typical salary range for candidates hired in this position. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have, and comparison to internal equity. This role is located in our Toronto office on 390 Bay St, and we operate in a hybrid work model. This job posting is for an existing vacancy.
Location & working pattern

Toronto, Canada

- An engaging and collaborative environment that promotes continuous learning and development - A hybrid work environment that combines weekly in-office and remote days - A great compensation package including an annual company bonus
More source context
Our base salary range for this role is between $119,000 and $139,000 per year, plus an opportunity for an annual company bonus based upon a percentage of eligible pay. The salary estimate displayed represents the typical salary range for candidates hired in this position. Factors that may be used to determine your actual salary include your specific skills, how many years of experience you have, and comparison to internal equity. This role is located in our Toronto office on 390 Bay St, and we operate in a hybrid work model. This job posting is for an existing vacancy. We do not use AI in our recruitment process - applications are reviewed by our team to ensure a fair and personalized experience.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.