Report Development & Analysis (45%)
- Supporting the Analytics and business management teams and assisting in the development of business line strategy, reporting and forecasting.
- Key deliverables include business unit profit & loss reporting, mortgage renewal & pricing analyses, mortgage continuity reports and budget/forecasts.
- Meet with management to evaluate and understand the scope, goals and needs of reporting requests and assist in the design, development and operationalization of reporting solutions that fulfill these requirements.
- Fulfilment of information reporting requests received from various Business Units across the Bank.
- Assisting in the development, compilation, and monitoring of key performance indicators (KPIs) in addition to other pertinent management reporting and analysis.
- Leading daily/weekly/monthly reporting over compliance to key risk indicators (KRIs), management targets, management guidelines, corporate policy, and risk appetite
- Assisting in the reporting, identification, assessment, and analysis of operational risk inherent in products, activities, processes, and systems.
- Providing unbiased and objective opinion and analysis of business decisions.
Financial Modeling (40%)
- Apply financial modelling concepts to enhance existing forecasting process including data automation and procedure documentation.
- Development and maintenance of financial models and outputs that are distributed to management on a monthly and quarterly basis
- Run detailed financial models/ templates, liaise with various business units and extract and work with data from various information sources
- Employ advanced Excel skills such as Pivot Tables, Nestled “IF” Statements, VLOOKUP, OFFSET, SUMIFS, MATCH-INDEX, etc. to assist in building efficient and accurate financial models.
Financial Analysis/Ad Hoc Reporting (15%)
- Proactively find ways to improve the technical accuracy, validation and organization of financial models
- Investigate and respond to ad hoc requests as required with a high degree of flexibility and attention to detail
- Reporting requests may require the candidate to collect, consolidate and analyze financial data and key performance metrics derived from various sources
- Assisting with ad-hoc projects such as peer benchmarking, migration analyses, and market research
- Collaborating with staff and vendors to advance projects
Let's Talk About You!
- Completion of an undergraduate degree in Commerce/Business Administration, Economics, Accounting or an equivalent combination of education and experience
- Possess or in progress of a professional designation such as CPA, CFA or a degree in a quantitative discipline, finance, or accounting would be considered an asset
- Two years of experience in an accounting, analytics, forecasting, financial planning & analysis, or business partner role
- Knowledge of the credit union system and/or financial services sector, and finance principles.
- Demonstrated ability using MS Office (Excel, Access, PowerPoint and Word)
- Advanced Microsoft Excel skills (including developing/running macros, pivot tables, nested “if” functions, VLOOKUP, MATCH/INDEX, ISERROR, OFFSET functions)
- Ability to work extensively with formulas, numbers and spreadsheets
- Advanced proficiency in Microsoft BI tools (MS Power Query & Power BI) and/or Access Database would be considered an asset
- Advanced proficiency in SQL and/or SSRS would be considered an asset
- Advanced ability to clearly communicate (written and verbal)
- Knowledge of financial statements and associated reporting is required
- Possess strong problem-solving and analytical skills
- Strong attention to detail & organizational skills
- Ability to handle multiple competing priorities (multi-tasking)
- Enjoys working in both team and individual environments
- Advanced interpersonal skills and the ability to develop strong working relationships
- Advanced attention to detail and the ability to manage time and meet deadlines
Similar Jobs
What We Do
MakeBank on everyday banking: Earn high interest on every dollar Say no to fees No minimum balances Powered by Equitable Bank, a Schedule I Canadian Bank EQB Inc. (formerly Equitable Group Inc.) trades on the Toronto Stock Exchange (TSX: EQB and EQB.PR.C), directly serves over 607,000 Canadians through its wholly owned subsidiary Equitable Bank, Canada's Challenger Bank™, and serves over 200 Canadian credit unions that serve over 6 million of their members with products and services. Equitable Bank has grown to become Canada's 7th largest independent Schedule I bank with over a $119 billion in assets under management and assets under administration, and a clear mandate to drive real change in Canadian banking to enrich people's lives. At Equitable Bank, we are as invested in our employees as we are in our business. That’s why we are consistently recognized as one of Canada's Top Employers – a rating that comes from our 1,800 employees. Equitable Bank’s inclusive, welcoming, and pride-inducing workplace earned it the honour of being recognized as one of the top 50 organizations on the 2023 list of Canada’s Best Workplaces™. Founded over 50 years ago, Equitable Bank provides diversified personal and commercial banking, and through its EQ Bank platform (eqbank.ca), which has been named #1 Bank in Canada for three consecutive years on the Forbes World's Best Banks list for 2021, 2022, and 2023. Equitable Bank website: www.equitablebank.ca EQ Bank website: www.eqbank.ca Specialties Lending, Mortgages, Residential Lending, Commercial Lending, Reverse mortgages, Insurance lending, Equipment leasing , Credit Union, Trust, and Funds Management
