Business Analyst - Corporate Treasury

IFG International Financial Group Ltd; South Frontenac; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading bank in Canada is seeking a skilled Business Analyst for a hybrid position in Toronto. This role, within the Corporate Treasury team, involves data automation and validation using SQL and Python, alongside critical data analysis tasks. The ideal candidate will possess strong Excel skills and relevant experience at a financial institution.

Qualifications

• 4-5 years of experience with SQL & Python.
• Strong understanding of Excel (VLOOKUPS, PivotTables).
• Excellent critical thinking and communication skills.

Responsibilities

• Utilize scripts to extract data for business decisions.
• Run SQL and Python scripts.
• Automate processes using Python.

Skills

SQL

Python

Excel

Critical Thinking

Organization

Communication Skills

Education

Degree in Business or Computer Science

Job description

Our client, a Top 5 Bank in Canada, is looking to hire a Business Analyst for their Corporate Treasury team for an initial 9-month contract. This role is currently hybrid in Toronto.

The candidate will be working with the Funds Transfer Pricing team within Corporate Treasury to replace the current internal FTP calculation engine.

Responsibilities Include:

• Utilize various scripts to extract data that will drive business decisions
• Run SQL scripts
• Run Python scripts
• Automate processes using Python
• Input raw data results into Excel and format them
• Check and validate data before it is sent out
• Participate in UAT testing based on system results

Qualifications:

• 4-5 years of experience with SQL & Python
• Strong understanding of Excel (VLOOKUPS, PivotTables, etc.)
• Excellent critical thinking, organization, and communication skills (both written and oral)
• Experience at a major financial institution (Nice to Have)
• A degree in Business or Computer Science (Nice to Have)

If you are qualified and interested in discussing this role in more detail, please submit your resume to Spencer Young at [e-mail].

#VMS