Senior Data Analyst – IFRS9 ECL & SQL Analytics

407 ETR; Vaughan; On-site; CAD 70,000 - 90,000; Full time

Job summary

A transportation organization located in York Region, Vaughan, is seeking a Financial Analyst to analyze financial data, develop ECL models, and prepare complex financial reports. The ideal candidate will have strong SQL skills, advanced proficiency with financial analysis tools, and at least 5 years of relevant experience. This position requires collaboration with various departments to enhance financial operations and reporting efficiency.

Qualifications

• Minimum 5 years of experience in financial reporting or analytics role.
• Experience with large datasets is considered an asset.
• Exceptional working knowledge of MS applications including Access, Excel, Outlook, Word, and PowerPoint.

Responsibilities

• Analyze financial data and develop ECL models.
• Develop SQL queries for data extraction and ad-hoc reporting.
• Prepare detailed trend analysis and business models.

Skills

Advanced proficiency in SQL

Financial analysis

Data analysis

Tableau

Python

Project management

Strong interpersonal skills

Education

Bachelor's Degree in Accounting, Finance or Computer Engineering

Finance/Accounting Designation (e.g., CPA or CFA)

Tools

Peoplesoft

SAP

Salesforce

SAS

Power BI

Job description

A transportation organization located in York Region, Vaughan, is seeking a Financial Analyst to analyze financial data, develop ECL models, and prepare complex financial reports. The ideal candidate will have strong SQL skills, advanced proficiency with financial analysis tools, and at least 5 years of relevant experience. This position requires collaboration with various departments to enhance financial operations and reporting efficiency.