Business System Analyst, Data Analysis (Python/SQL)

Job Description

Business System Analyst, Data Analysis (Python/SQL):
On behalf of our Banking client, Procom is searching for a Business System Analyst, Data Analysis (Python/SQL) for a 4-month role. This position is a hybrid position with 4 days onsite at our client’s Toronto office.

Business System Analyst, Data Analysis (Python/SQL) - Job Description:
This role plays an important part at the intersection of data analysis, system development, and regulatory compliance within the Group Risk Management department. The position involves technical work focusing on Python/SQL-based data tasks and OSFI-mandated log analysis, along with supporting vendor relationships to ensure operational continuity.

Business System Analyst, Data Analysis (Python/SQL) - Responsibilities:
• Write and maintain Python scripts and SQL queries for data analysis, reporting, and ad hoc requests
• Assist in cleaning and validating data sourced from Excel files and other systems
• Support the migration of Excel-based datasets into a structured relational database environment
• Analyze user activity logs and contribute to monitoring reports for compliance
• Serve as a point of contact for external data providers and manage inquiries
• Maintain documentation for analytical processes and vendor workflows
• Identify opportunities to automate manual tasks and improve processes

Business System Analyst, Data Analysis (Python/SQL) - Mandatory Skills:
• 2-3 years of BSA experience
• Proficiency in Python and SQL for data extraction and analysis
• Analytical mindset for interpreting large datasets and identifying patterns
• Attention to detail for data validation and regulatory compliance
• Strong communication skills for coordinating with teams and vendors
• Solid working knowledge of Microsoft Excel

Business System Analyst, Data Analysis (Python/SQL) – Nice-to-Have Skills:
• Familiarity with Power BI or Tableau for dashboard creation
• Experience with Jira and/or Confluence for task tracking and collaboration
• Comfort using SharePoint for documentation management
• Basic understanding of OSFI guidelines or compliance frameworks
• Prior experience in vendor management

Business System Analyst, Data Analysis (Python/SQL) – Assignment Length:
This is a 4-month contract position.

Business System Analyst, Data Analysis (Python/SQL) - Start Date:
ASAP.

Business System Analyst, Data Analysis (Python/SQL) - Assignment Location:
Toronto, Ontario, Canada. This is a hybrid position with 4 days in office.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.