McCarthy Tétrault is a Canadian law firm recruiting a Business Intelligence Developer to join their team in Vancouver, Montreal, Calgary or Toronto office. The successful candidate will create interactive dashboards, develop and automate finance processes and reports, and manage data across platforms. The firm offers a hybrid work environment, competitive compensation, paid overtime, and generous time off, including a day off to volunteer and a day off for your birthday.
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
- Insurance premiums paid by the Firm
- Wellness and technology reimbursements
- Competitive compensation
- Paid overtime
- Generous time off
- A day off to volunteer
- A day off for your birthday
