Finance Systems - Business Analyst - AVICJP00002740

Location: Markham, ON (Hybrid – 3 days onsite, Tuesday & Wednesday mandatory)

Advantages
•Work with a well-established global insurance leader
•Hybrid work model (3 days onsite in Markham)
•Exposure to major transformation projects in finance and accounting systems
•Opportunity to work with advanced tools and platforms including Guidewire, Oracle, and Postgres
•Supportive and collaborative team environment

Responsibilities
•Analyze and document business requirements for finance and accounting systems
•Collaborate with business stakeholders to gather needs and define system enhancements
•Conduct gap analyses and create functional specifications
•Work with Guidewire (PolicyCenter, BillingCenter, ClaimCenter) and mainframe systems to ensure alignment with business goals
•Evaluate the impact of changes on P&L and balance sheet reporting
•Participate in system testing and validation activities
•Create SQL queries and manage data within Oracle and Postgres environments
•Develop reports, dashboards, and presentations for internal and executive stakeholders
•Provide user support and training on new features and systems
•Monitor system performance and troubleshoot issues
•Ensure compliance with IFRS17, OSFI, GISA, Facility Association, GAA and other regulatory frameworks

Qualifications
•Minimum 5 years of Business Analyst experience within Finance Systems, preferably in the insurance sector
•Strong knowledge of insurance accounting standards and regulatory reporting requirements
•Hands-on experience with Guidewire and mainframe constructs
•Solid understanding of ETL processes and their role in financial data transformation
•Advanced SQL scripting skills
•Proficient in Visio, Excel, PowerPoint, and Word
•Experience with process mapping, writing user stories, data modeling, and maintaining data dictionaries
•Strong verbal and written communication skills
•Proven ability to manage projects and collaborate across multiple departments
•Bachelor's degree in Finance, Business, Accounting, Computer Science or related field (preferred)

Summary
This is an exciting opportunity for a dynamic and detail-oriented Business Analyst with a passion for finance systems and insurance operations. You’ll play a vital role in supporting critical financial technology initiatives while ensuring data accuracy, system integrity, and compliance with industry standards. If you're looking for a challenging, rewarding role with long-term potential, we’d love to connect with you.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.