Financial Analyst, Analytics

EQ Bank | Equitable Bank; Toronto; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An innovative financial institution is seeking a Financial Analyst to join their dynamic team. In this role, you will leverage your analytical skills to support data-driven decision-making and enhance financial reporting. You will engage with various teams to develop strategies and provide insights that drive business performance. This position offers a unique opportunity to work in a hybrid environment, contributing to a transformative banking experience while enjoying competitive benefits and a supportive culture that values diversity and inclusion.

Benefits

Competitive discretionary bonus

Market leading RRSP match program

Medical, dental, vision, life, and disability benefits

Employee Share Purchase Plan

Maternity/Parental top-up

Generous vacation policy

Annual professional development allowance

Comprehensive Career Development program

Qualifications

• Completion of an undergraduate degree in Commerce, Economics, or Accounting.
• Two years of experience in analytics, financial planning & analysis.

Responsibilities

• Compile and create information for analysis to support decision making.
• Develop and maintain financial models for management reporting.

Skills

Analytical Skills

Problem-Solving Skills

Communication Skills

Advanced Excel Skills

Financial Modeling

Attention to Detail

Education

Undergraduate Degree in Commerce/Business Administration

Professional Designation (CPA, CFA)

Tools

Microsoft Excel

Power BI

SQL

MS Power Query

Job description

Join a Challenger

Being a traditional bank just isn’t our thing. We are big believers in innovating the banking experience because we believe Canadians deserve better options, and we challenge ourselves and our teams to creatively transform what’s possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If you’re not afraid of taking on big challenges and redefining the future, you belong with us. You’ll get to work with people who will encourage you to reach new heights. We like to keep things fun, ask questions and learn together.

We are a big (and growing!) family. Overall we serve more than 670,000 people across Canada through Equitable Bank, Canada's Challenger Bank, and have been around for more than 50 years. Equitable Bank's wholly-owned subsidiary, Concentra Bank, supports credit unions across Canada that serve more than six million members. Together we have over $125 billion in assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our customers have named our EQ Bank digital platform (eqbank.ca) one of the top banks in Canada on the Forbes World's Best Banks list since 2021.

The Work

The primary purpose of the Financial Analyst, Analytics role is to compile and create information to conduct analysis to facilitate fact-based, informed decision making and integration of risk-based management throughout the company. Additionally, this position manages relationships to support the delivery of information, analysis, and reporting to various users throughout the company including management and business leads. The candidate must possess strong communication, analytical and problem-solving skills.

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

What we offer [For full-time permanent roles]

• Competitive discretionary bonus
• Market leading RRSP match program
• Medical, dental, vision, life, and disability benefits
• Employee Share Purchase Plan
• Maternity/Parental top-up while you care for your little one
• Generous vacation policy and personal days
• Virtual events to connect with your fellow colleagues
• Annual professional development allowance and a comprehensive Career Development program
• A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience

The incumbent will be working hybrid and in office time will be spent working from Equitable Bank’s additional office space located at 351 King Street East, Toronto, ON.

Equitable Bank is deeply committed to inclusion. Our organization is stronger and our employees thrive when we honour and celebrate everyone’s diverse experiences and perspectives. In tandem with that commitment, we support and encourage our staff to grow not just in their career path, but personally as well.

We commit to providing a barrier-free recruitment process and work environment for all applicants. Please let us know of any accommodations needed so that you can bring your best self to the application process and beyond. All candidates considered for hire must successfully pass a criminal background check and credit check to qualify for hire. While we appreciate your interest in applying, an Equitable recruiter will only contact leading candidates whose skills and qualifications closely match the requirements of the position.

We can’t wait to get to know you!