Business Intelligence Developer managing finance processes and data visualization at McCarthy Tétrault. Responsible for developing dashboards and automating reports across multiple platforms.
Responsibilities
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.
Requirements
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.
Benefits
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.
Power BI Developer transforming raw data into insights via dashboards for ELITS Canada. Collaborating on business intelligence solutions that drive strategic decision - making.
Senior Business Intelligence Analyst at Clio focusing on data - driven decisions with the Business Intelligence team. Empowering stakeholders through data - oriented solutions to improve operations and drive growth.
Senior Procurement Business Intelligence Analyst at FCC improving procurement processes and managing third - party risks. Leading risk, quality assurance, and reporting activities for effective procurement lifecycle management.
Business Intelligence Analyst developing and delivering Power BI reports and collaborating with data teams at Alberta Blue Cross. Enabling users through training and supporting analytics initiatives.
Finance Data Operations & Business Intelligence Analyst focusing on automation and improving data processes within a growing asset management firm. Collaborating on Finance reporting and analytics while promoting an inclusive culture.
Senior Business Intelligence Analyst at Blackline Safety responsible for designing BI solutions and driving strategic business decisions through data analysis.
Finance Data Operations Analyst focusing on automating finance processes and delivering analytics. Collaborating in a team - driven environment to enhance reporting and decision - making in asset management.