Business Intelligence Developer

McCarthy Tetrault LLP

Toronto, ON
$95,000-105,000 per year
Permanent
Full-time

26 days ago

Job Description:McCarthy Tétrault is a Canadian law firm that offers a full suite of legal and business solutions to clients in Canada and around the world. At McCarthy Tétrault, we offer challenging and rewarding career opportunities in our offices in Toronto, Montreal, Quebec City, Calgary and Vancouver. We are delighted to have earned the distinction of one of for the fourteenth consecutive year in 2026. Our culture is built on professional excellence, collaboration, innovation, thought leadership and entrepreneurialism. We embrace inclusion in all its forms and we provide the tools and opportunities to help our people develop to their full potential.We are recruiting for a Business Intelligence Developer to join our team in our Vancouver, Montreal, Calgary or Toronto office. The successful candidate must have a minimum of 3 years of experience in data visualization, data modeling and process automation, and will be responsible for creating interactive dashboards, developing and automating finance processes and reports, and managing data across platforms. McCarthy Tétrault employees benefit from a hybrid work environment. This position is to fill an existing vacancy.Salary Range (Toronto or Vancouver): $95,000 - $105,000 annuallyThe offered salary may vary based on the candidate’s job-specific knowledge, skills, and experience.As a Business Intelligence Developer, you will be:

Developing interactive dashboards, alerts and reporting templates to offer real-time actionable insights to stakeholders within the Finance department and to other internal stakeholders (Senior Leadership, Partners, etc.).
Leading the ongoing development and automation of finance reports, digital forms and processes, enhancing self-serve capabilities for internal stakeholders through BI tools and platforms, optimizing the end-user experience.
Managing, updating, and validating data across multiple platforms, ensuring accuracy and consistency.
Executing both routine and ad hoc reporting encompassing various firm dimensions like practice, region, industry, timekeeper, and more.
Providing technical expertise for the firm's finance digitization initiative, playing a pivotal role in its successful realization.
Planning and executing project management processes like requirements gathering, process mapping, quality assurance, rollout strategies, communication strategies, and change management plans for the firm’s finance digitization efforts.
Producing practical demonstrations showcasing the utilization of products tailored to our unique environments.
Building and maintaining strong relationships with internal (billing analysts, billing lawyers, paralegals, legal assistants, etc.) and external stakeholders, offering them comprehensive support and insights.

As our ideal candidate, you will distinguish yourself by the following profile:

University degree in a related field (e.g. Data Science, Computer Science, Finance or Engineering).
Minimum 3 years of relevant work experience, preferably acquired within a legal or professional services environment.
Experience building data models and dashboards with Power BI (preferred, including complex DAX queries and paginated reports), SSRS (preferred) or similar BI tools (Tableau, Qlik, etc.).
Proficiency with TSQL, with an emphasis on intricate query formulation. Familiarity with database maintenance is valued.
Capability to design automated alert systems using tools like SSRS and Power Automate.
Knowledge of enterprise solutions such as Power Apps and ServiceNow, and coding languages like Python & JavaScript.
Mastery in MS Excel, inclusive of VBA scripting for report automation.
Familiarity with AI agents creation (e.g. using Copilot Studio) for process automation would be an asset.
Excellent analytical and problem-solving skills; adept at creating meaningful insights from source data.
Very strong written and communication skills, with a demonstrated ability to summarize and convey complex information in a clear and concise manner. Capacity to demonstrate tact and diplomacy when dealing with internal and external clients and respect confidentiality.
Strong ability to prioritize concurrent activities, follow through on open items and provide status updates, unprompted. Deadline oriented.
Self-Starter & quick learner – willing to spend time investigating data on your own to minimize disruption to SMEs.

As a member of the McCarthy team, you will have access to:

Outstanding benefits from day one, including insurance premiums paid by the Firm and wellness and technology reimbursements.
Competitive compensation, paid overtime and generous time off, including a day off to volunteer and a day off for your birthday.
A commitment to professional development and growth opportunities for our people at all levels, supported by a culture that fully embraces and encourages two-way feedback.
Strong community involvement and a commitment to equity, diversity and inclusion.
A collaborative, cohesive culture that connects lawyers and business teams through collective purpose.

How to Apply:We encourage external candidates to apply online and internal applicants must apply directly through our internal careers portal on Espresso. We look forward to receiving your application.McCarthy Tétrault utilizes artificial intelligence (AI) technology as part of our application screening process to enhance the efficiency and effectiveness of our recruitment efforts by analyzing applications to identify candidates whose qualifications and experiences align with the requirements of the position.We thank all applicants for their interest in McCarthy Tétrault; however, only chosen applicants will be contacted. We regret that we are unable to respond to individual inquiries about application status. McCarthy Tétrault is an equal opportunity employer that fosters an inclusive, equitable, and accessible environment. Please notify us if you require accommodation at any time during the recruitment process.

McCarthy Tetrault LLP

Apply Now