Data Analyst, Reporting

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

Benefits offered by this job

Hybrid work model

Onboarding cross-training

Job summary

Torys LLP is seeking a Data Analyst, Reporting to deliver accurate financial and business reporting and provide insights for clients and internal stakeholders. You will translate needs into clear reports and dashboards, supporting the firm’s decision-making processes.

The hybrid role requires Excel, SQL, Power BI and data extraction from accounting systems; you will work with lawyers and Business Services to ensure accurate, timely reporting and cross-training within the team.

Qualifications

• Post-secondary degree or diploma in Finance or Accounting, or equivalent experience.
• 3–5 years of related experience, preferably in a professional services firm.
• Proficiency in Microsoft Office, especially Excel with pivot tables.
• Working knowledge of SQL and Power Query in Excel; Power BI, MDX/DAX assets.
• Experience extracting data from a complex accounting system (3E is a plus).
• Strong analytical and problem-solving skills; able to handle tight deadlines.

Responsibilities

• Develop and maintain complex financial and non-financial reports and dashboards for client, management and business needs.
• Prepare data from various sources for reporting and analysis in Excel, Power BI and other BI tools.
• Validate and reconcile reports, dashboards and underlying data.
• Prepare client reporting packages and matter management reports.

Skills

Excel Pivot Tables

SQL

Power Query

Power BI

MDX/DAX

3E Accounting System

Analytical Thinking

Education

Finance or Accounting degree

Tools

Excel

Power BI Desktop

Job description

Position Overview

The Data Analyst, Reporting is responsible for delivering accurate financial and business reporting and providing insights that support the needs of clients and internal stakeholders. This role translates stakeholder needs into clear reports, dashboards and recurring deliverables.

Key Accountabilities

• Develop and maintain complex financial and non-financial reports and dashboards for client, management and business needs.
• Support improvements to the firm’s reporting capability by assessing and applying appropriate tools and approaches.
• Prepare data from various sources for reporting and analysis in Excel, Power BI and other business intelligence tools.
• Interpret financial and business information to identify trends, risks and relevant insights for stakeholders.
• Translate stakeholder objectives, measures and requirements into clear and accurate reporting deliverables.
• Validate and reconcile reports, dashboards and underlying data, resolving discrepancies before distribution.
• Prepare client reporting packages, including quarterly and annual presentations, financial templates and ad hoc information.
• Develop matter management reports for clients and internal stakeholders.
• Advise lawyers and Business Services professionals on reporting requirements, deliverables and interpretation.
• Provide reporting and analytical coverage during absences, peak periods and changing business needs.
• Maintain documentation for data sources, reporting requirements, calculations and processes.
• Review reports, dashboards and supporting analysis prepared by other Analysts for accuracy, completeness and appropriate interpretation.
• Provide financial data, reporting and analytical support for projects and firm initiatives.

Attributes & Experience

• Post-secondary degree or diploma in Finance or Accounting, or equivalent experience, is essential.
• 3 to 5 years of related experience, preferably within a professional services firm.
• Proficiency in the Microsoft Office suite, with expert knowledge of Excel, including pivot tables, is required.
• Working knowledge of SQL and Power Query in Excel is required. Experience with Power BI Desktop, MDX, and/or DAX would be an asset.
• Experience in extracting data from a complex accounting system is required. Experience with 3E would be an asset.
• Excellent analytical and problem-solving skills with the ability to quickly grasp complex assignments; the aptitude to analyze a variety of considerations, determine what’s important, and assess possible courses of action.
• Ability to plan, organize, schedule, and deliver within tight deadlines in a high-pressure environment.
• Strong client service orientation combined with the ability to manage multiple client needs at the same time.
• Excellent communication skills (verbal and written) with the ability to interact with individuals at all levels of the organization with tact and diplomacy.
• Ability to build strong working relationships with key stakeholders of the firm.
• Strong interpersonal skills with the ability to work well both independently and collaboratively within a team environment.
• Strong aptitude for utilizing technology and continuous process improvement.
• Sound judgment including the ability to deal with confidential information with utmost discretion.
• Exceptional attention to detail.

Additional information

Hybrid

This position is part of our hybrid work model with 3 days in the office per week. As part of our onboarding, new hires are required to be in the office more often for the first few months of employment to ensure they receive the requisite cross training.

This job posting is for an existing vacancy.

Salary will be determined based on the candidate’s skills, experience, and qualifications.

We are committed to leveraging innovative tools to enhance our recruitment process. As part of this, we use AI-powered tools to assist in the initial stages of candidate shortlisting and screening. These tools help us evaluate applications more efficiently and consistently by focusing on qualifications, experience, and skills relevant to our roles. Although we use this technology, all applications are reviewed, and decisions made by our Human Resources team to ensure fairness and alignment with our firm policies. If you have any questions or concerns about this process, feel reach out to us at [e-mail].

At Torys, we are committed to diversity in the recruitment, retention and advancement of our people. We believe that diversity of backgrounds, experience and perspectives enhances the quality of our work and enriches our lives. We are committed to fostering an inclusive and accessible work environment. Accommodations are available for applicants with disabilities. If you require immediate accommodation at any time during the recruitment process, please contact Jenny Tavares, Director, Human Resources at [e-mail].

All offers of employment are subject to background checks. This process includes criminal record checks, social media checks, and employment and educational background checks.

Posted Min Pay Rate

CAD $80,000.00/Yr.

Posted Max Pay Rate

CAD $90,000.00/Yr.