Business Systems Analyst, Systems & Data Transformation

Role overview

Analysis and requirements

• Elicit, analyze, document, and validate business, functional, non-functional, data, integration, and reporting requirements.
• Create BRDs, user stories, use cases, acceptance criteria, process flows, data flow diagrams, interface specifications, and traceability matrices.
• Translate business needs into solution-ready system requirements; perform impact analysis and maintain requirements traceability.
• Assess current and target systems, data flows, integrations, controls, and operational impacts.

Insurance, data, and systems

• Support policy administration, claims, underwriting, billing, payments, renewals, endorsements, and insurance product configuration.
• Support Canadian regulatory, compliance, privacy, audit, and operational risk initiatives affecting insurance products, processes, data, and technology controls.
• Use SQL for data analysis, validation, reconciliation, root-cause analysis, and operational reporting; review database objects with database teams.
• Validate data migration, mapping, conversion, transformation, and reconciliation; analyze APIs, batch processes, message flows, and data feeds.

Delivery and collaboration

• Support UAT, SIT, regression testing, production investigations, defect triage, and data-related incident analysis.
• Review technical designs, provide functional input in solution discussions, and coordinate with developers, architects, QA, project managers, operations, and vendors.
• Act as a liaison between business and technical teams, lead requirements walkthroughs, present recommendations, and manage stakeholder expectations.
• Work across Agile and Waterfall environments.

Experience and education

• At least 6 years as a Business Systems Analyst, Systems Analyst, or technically oriented Business Analyst.
• At least 3 years in Canadian insurance or a closely related regulated financial services environment.
• Experience supporting large-scale implementations, modernization, integrations, migrations, enhancements, or vendor platform projects.
• Strong Canadian insurance domain knowledge and strong SQL expertise; experience querying databases.
• Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or a related field.

Technical skills and tools

• Experience with data mapping, interface specifications, source-to-target mapping, data lineage, and business rules documentation.
• Knowledge of stored procedures, packages, triggers, functions, and views; application architecture, web applications, APIs, data models, and enterprise system design.
• Knowledge of REST and SOAP services, file-based integrations, messaging platforms, batch processing, and system-to-system data exchanges.
• Listed tools include Databricks, SQL Server, JIRA, Confluence, Microsoft Visio, and Microsoft Excel.
• Insurance platforms may include Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar platforms.

Preferred qualifications

• Insurance platform experience with Guidewire, Duck Creek, PolicyCenter, ClaimCenter, BillingCenter, or similar Canadian systems is preferred.
• Cloud platforms, data warehouses, reporting, document management, workflow, and integration technology knowledge is preferred.
• API integration and microservices experience, CBAP, CCBA, PMP, or Agile certifications, and experience with distributed or offshore teams are preferred.
• Nice-to-have experience includes ETL, Power BI or Tableau, DevOps and CI/CD, microservices and event-driven architectures, and basic XML, JSON, and XSD knowledge.

Work arrangement

• The role is located in the Toronto office and follows a hybrid work model combining weekly in-office and remote days.

Compensation and benefits

• Base salary range is $119,000 to $139,000 per year, with an opportunity for an annual company bonus.
• Benefits include health and dental coverage, health or wellness spending accounts, pension and optional RRSP matching, paid time off, learning support, and wellness resources.