Financial Reporting Data Analyst Power BI & Excel

Torys; Toronto; Hybrid; CAD 80,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Accommodations available

Job summary

Torys LLP in Toronto is seeking a Data Analyst, Reporting to deliver accurate financial and business reporting and provide insights for clients and internal stakeholders. You will translate stakeholder needs into clear reports, dashboards and recurring deliverables, using Excel, Power BI and SQL, with emphasis on data accuracy and reconciliation.

The role operates in a hybrid model (3 days in office) and involves collaboration with lawyers and Business Services, with onboarding cross-training to

Qualifications

• Post-secondary degree or diploma in Finance or Accounting, or equivalent experience.
• 3–5 years of related experience, preferably within a professional services firm.
• Proficiency in Microsoft Excel, including pivot tables.
• Working knowledge of SQL and Power Query; experience with Power BI Desktop, MDX/DAX is a plus.
• Experience extracting data from a complex accounting system (3E preferred).

Responsibilities

• Develop and maintain complex financial and non-financial reports and dashboards.
• Prepare data from various sources for reporting in Excel, Power BI and BI tools.
• Interpret financial information to identify trends and risks for stakeholders.
• Translate stakeholder objectives into clear reporting deliverables.
• Validate and reconcile reports and underlying data.
• Prepare client reporting packages and quarterly/annual presentations.
• Advise lawyers and Business Services on reporting requirements.
• Provide coverage during absences and peak periods.
• Maintain documentation for data sources and reporting processes.
• Review reports prepared by other analysts for accuracy.

Skills

Analytical skills

Problem solving

Communication

Client service orientation

Interpersonal skills

Team collaboration

Education

Finance or Accounting degree or equivalent

Tools

SQL

Power Query in Excel

Power BI Desktop

MDX/DAX

3E accounting system

Job description

Torys LLP in Toronto is seeking a Data Analyst, Reporting to deliver accurate financial and business reporting and provide insights for clients and internal stakeholders. You will translate stakeholder needs into clear reports, dashboards and recurring deliverables, using Excel, Power BI and SQL, with emphasis on data accuracy and reconciliation.

The role operates in a hybrid model (3 days in office) and involves collaboration with lawyers and Business Services, with onboarding cross-training to