Financial Analyst – Project Financial Control, Power Query

Finance Professionals Inc.; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading financial institution in Downtown Toronto is seeking a Financial Analyst to manage the financial lifecycle of projects and ensure accurate financial reporting. The ideal candidate will have 3-4 years of experience in financial forecasting and proficiency in tools like Power Query and advanced Excel. A Bachelor's degree in Finance or Accounting is required. This role offers the opportunity to work with one of the Top 5 Banks in Canada.

Qualifications

• 3-4 years of experience in financial forecasting, accruals, Power Query, financial models and reporting.
• Solid understanding of accounting principles.
• 3+ years of experience with Advanced Excel (Index Match, VLOOKUP, complex formulas).

Responsibilities

• Own the end-to-end financial lifecycle of projects.
• Collaborate with Delivery Managers to maintain accurate forecasts.
• Deliver actionable insights and financial reports to stakeholders.
• Monitor timesheets using Clarity, Fieldglass, and JIRA/Confluence.

Skills

Financial forecasting

Accruals

Power Query

Financial models

Reporting

Advanced Excel

Power BI

Education

Bachelor’s degree in Finance, Accounting, Commerce

MBA

CPA

Tools

Excel

Power BI

Clarity

Fieldglass

JIRA/Confluence

Job description

Our client a leading financial institution inDowntown Toronto,is looking for a Financial Analyst – Project Financial Control, Power Queryto own the end-to-end financial lifecycle of projects—track actuals vs. forecasts, manage accruals, and ensure monthly payouts align with business case commitments. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in role:

• Financial Stewardship: Own the end-to-end financial lifecycle of projects—track actuals vs. forecasts, manage accruals, and ensure monthly payouts align with business case commitments.
• Forecasting & Budgeting: Collaborate with Delivery Managers to build and maintain accurate forecasts, identify potential overruns, and recommend corrective actions.
• Reporting & Analysis: Consolidate data from multiple platforms into centralized Excel models; deliver actionable insights and financial reports to stakeholders.
• Operational Excellence: Monitor timesheets (50–60 resources) using Clarity, Fieldglass, and JIRA/Confluence; ensure timely invoice processing and cost reconciliation.
• Vendor & Contract Oversight: Manage relationships with 30–40 vendors, oversee contract compliance, and maintain meticulous financial records.
• Strategic Support: Provide financial clarity to project teams, support regulatory reporting, and contribute to continuous improvement in financial controls.

Must-Have Skills:

• 3-4 years of strong experience in financial forecasting, accruals, Power Querry, financial models and reporting
• Solid understanding of accounting principles (Actuals vs. Accruals, CapEx vs. OpEx)
• 3–4 years of experience managing large data sets and project financials
• 3+ years of experience with Advanced Excel (Index Match, VLOOKUP, complex formulas, data centralization)
• Recent experience with of Power BI for data visualization

Nice-To-Have Skills:

• Knowledge of project management
• Experience with Clarity, Fieldglass, JIRA/Confluence
• Knowledge of capital markets and regulatory frameworks

Soft Skills Required:

• Meticulous attention to detail and analytical thinking
• Strong communication and stakeholder engagement skills
• High integrity and discretion with sensitive financial data
• Self-starter with a collaborative mindset and time management prowess

Education:

• Bachelor’s degree in Finance, Accounting, Commerce, or related field
• MBA is preferred
• CPA an asset

Finance professional is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.