Senior Business Systems Analyst / Structured Financing / Loan Financing / Toronto

Job summary

The role involves migrating program data into Databricks and translating complex financial data into actionable reporting. The analyst will work with technical and business teams to validate data and interpret financial reporting metrics.

Job details

We’re looking for an experienced Business Systems Analyst to join a financial services team supporting a large-scale structured financing and loan financing initiative. This is a contract opportunity focused on data migration, reporting, and analytics, with Databricks, SQL, Power BI at the core of the technology environment. This is a great opportunity for a Business Analyst who understands both financial services and data. You’ll play a key role in a major initiative migrating program data into Databricks, helping stakeholders turn complex financial data into accurate, actionable reporting. The ideal candidate is comfortable digging into data, challenging discrepancies, translating business requirements, and working closely with technical and business teams. Candidates must have prior experience working in structured financing or loan financing. You will regularly discuss and interpret financial reporting metrics such as face value of assets, adjusted borrowing value, advanced amounts, assigned values, and assigned amounts. Contract Duration: 12 Months Required Skills & Experience 5 to 10 years of Business Analysis experience Banking or financial services experience is a must Must have a strong understanding of structured financing or loan financing Strong background in analytics, reporting, and data analysis Experience building business and operational reports Ability to interpret financial metrics including: Face value of assets Adjusted borrowing value Advance amounts Assigned values and amounts Strong requirements gathering and stakeholder management skills Experience validating data and identifying discrepancies Desired Skills & Experience Databricks experience preferred Strong SQL skills Experience with Power BI and/or Tableau Experience translating business requirements into reporting and data solutions The Offer You Will Receive The Following Benefits Statutory Vacation Holiday Pay Hybrid working structure in downtown Toronto, walking distance from Union Station Current Vacancy: Yes Use of AI in Hiring: No Posted By: Maxwell Bevan

What you’ll do

The role involves migrating program data into Databricks and translating complex financial data into actionable reporting. The analyst will work with technical and business teams to validate data and interpret financial reporting metrics.

Requirements

Candidates must have 5 to 10 years of business analysis experience within banking or financial services, specifically in structured or loan financing. Proficiency in data analysis and experience with tools like SQL, Power BI, or Databricks is highly desired.

Benefits

• Statutory Vacation • Holiday Pay

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• Data Validation · Preferred
• Data analysis · Preferred
• Reporting · Preferred
• Business analysis · Preferred
• Requirements gathering · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Business Analysis
• Structured Financing
• Loan Financing
• Data Migration
• Reporting
• Analytics
• Databricks
• SQL
• Power BI
• Tableau
• Requirements Gathering
• Stakeholder Management
• Data Validation
• Financial Metrics Interpretation

Job areas

• Finance & Accounting
• Data & Analytics
• Technology
• Consulting