itjobs.ca Logo
Industry FinTech logo

Business Systems Analyst

Hybrid
CA$43 - CA$50/hourly
Entry Level
Full-Time

About the role

Location: Toronto, ON - Hybrid Pay Rate: $42.63/hr - $50.33/hr Contract Length: 4 Months with possibility for extension

We at Raise are hiring a Business Systems Analyst for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand. We’re hiring right now; if you’re interested, apply below for your chance to join a great place to work.

Responsibilities

External vendor data Analysis and monitoring Database Development from excel Vendor coordination & support

Data Analysis & Python/SQL Development

Write and maintain Python scripts and SQL queries to support day-to-day data analysis, reporting, and ad hoc investigation requests. Assist in transforming, cleaning, and validating data sourced from Excel files and other upstream systems. Collaborate with senior team members to develop and document reusable data pipelines and analytical workflows.

Database Development & Excel Migration

Support the migration of existing Excel-based datasets and processes into a structured relational database environment. Assist in designing and maintaining database tables, schemas, and data dictionaries to ensure data integrity and accessibility. Perform data quality checks and reconciliations to validate migrated data against source files.

OSFI Regulatory Log Analysis & Monitoring

Assist in the development and maintenance of an enterprise-level monitoring process for credit bureau activity logs in compliance with OSFI requirements. Analyze user activity logs received from credit bureau providers, including login/logout events, file uploads and downloads, and IP address tracking. Identify anomalies, flag potential compliance concerns, and escalate findings to senior risk and compliance stakeholders. Contribute to the preparation of regular monitoring reports and support audit and regulatory review activities as required.

Vendor Coordination & Support

Serve as a day-to-day point of contact for external data providers, managing routine inquiries and coordinating issue resolution. Track vendor SLA performance and flag deviations to senior team members for escalation. Support access review and member code maintenance activities for external vendor systems, ensuring adherence to change management standards.

Documentation & Process Support

Maintain clear and up-to-date documentation for analytical processes, database structures, log monitoring procedures, and vendor workflows. Identify opportunities to automate manual tasks and contribute to ongoing process improvement initiatives

Must-Have Skills

Proficiency in Teradata Python & SQL Proficiency: Hands-on experience writing Python scripts and SQL queries for data extraction, transformation, and analysis at a data analyst level. Analytical Mindset: Ability to interpret large datasets, identify patterns, and communicate findings clearly to both technical and non-technical audiences. Attention to Detail: Meticulous approach to data validation, log review, and documentation to support regulatory accuracy and compliance. Communication Skills: Clear verbal and written communication skills to coordinate with internal teams and external vendors effectively. Microsoft Excel: Solid working knowledge of Excel for data review, reconciliation, and transition planning.

Nice-to-Have Skills

JIRA, Vendor relationship managment.

Looking for meaningful work? We can help!

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/

In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com

#FIN24

About Industry FinTech

Financial Services