Sr. Business Systems Analyst to perform Gap analysis and write SQL queries within P&C for a major insurance client - 785

Sr. Business Systems Analyst to perform Gap analysis and write SQL queries within P&C for a major insurance client - 785

Duration: 6 months with possible extension

Location: Hybrid Toronto (2 days in-office, no exceptions)

Must haves:

• 5+ years exp as a Business Systems Analyst
• Experience with writing SQL queries and data analysis.
• Strong IT GAP/requirements analysis
• Experience with P&C insurance, P&C Accounting, and regulatory reporting.

Nice to haves:

• Developer background

• Experience with ERP Oracle Cloud finance modules.

• Confluence & Jira knowledge

• CBAP, IIBA member or other BA designation certification.

• Scrum Master or experience with Agile methodologies.

• Practical experience with or within a Finance department in Billing, AR/AP, and General Ledger functions.

• Practical experience with or knowledge of preparing financial statements, P&C -1 in the specific reporting areas of premiums, claims and reinsurance.

• Knowledge of or experience working with IFRS 17 requirements.

• University degree, College diploma and/or Certifications in a related discipline or equivalent training and work experience.

Responsibilities:

· Research, analyse and document clear Functional Specifications, Use Cases, and describe complex business situations.

· Contribute to the development of functional solutions to address simple to highly complex business needs that may cross various technologies, applications, and functional areas.

· Work with development and confirm delivered solutions meet the business needs.

· Carry out complex work assignments with general direction from the leader and work independently to meet needs of the project and timelines.

· Manage small system enhancements from inception to completion.

· Actively participate or lead data gathering workshops to support the needs of Application Architects and Developers.

· Liaise with the technical designers during the Design and Development stages.

· Create and/or review test strategies.

· Assist the business and project managers to resolve change management issues.

· Provide business analysis support during functional and integrated testing of the applications.

· Assist team in preparing estimates on impact analysis, development, and testing for proposed application solutions.