Int. Reporting Analyst to act as a SME within the auto financing portfolio for large banking client - 138792

Title: Reporting Analyst
Contract Length: 6 Months
Location: Hybrid (2 days per week); 4th Floor, 20 Bay Street, Toronto, ON

Overview:

We are a product management team responsible for the bank’s subvented auto loan financing portfolio. We manage the full product life cycle including client onboarding, servicing, product design, implementation, enhancement, pricing, billing, reporting etc. The candidate will be responsible for preparing and distributing internal and client facing reporting and billing reconciliation for our auto manufacturer partners.

Responsibilites:

- Collaborate with stakeholders to design, develop and produce appropriate reports at regular intervals to provide insightful analytics for senior leadership team
- Provide in-depth analysis and reporting on business performance activities
- Leads change by identifying enhancements and improvements to existing processes and systems
- Drives automation across the existing reporting landscape
- Assist with annual planning process and provide any adhoc project portfolio or performance reporting
- Maintain a consolidated and comprehensive portfolio of reports
- Assist in monthly reviews, variance analysis and reconciliation with source data
- Confirms and reconciles financial and project reporting requirements
- Conduct business analysis tasks on an as needed basis
- Collaborate with internal teams to develop advanced analysis and modeling methods to drive deeper insight and identify revenue opportunities based on information gathering of current trends, competition and strategy

Must Haves:
- Advanced MS Excel skills, including macros, pivot tables, Vlookup

Nice to Haves:
- Previous FI experience 
- CMA candidates or MBA – preferred
- Data analytics (SQL or Oracle BI experience)
- Data visualization (Advanced Tableau experience)