Business Intelligence Developer
McCarthy Tétrault
full-time
Posted on:
Location Type: Hybrid
Location: Toronto • Canada
Visit company websiteExplore more
Tech Stack
About the role
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data modelingdashboard developmentDAX queriesTSQLVBA scriptingautomated alert systemsdata analysisreport automationAI agents creationprocess mapping
Soft Skills
analytical skillsproblem-solving skillswritten communicationverbal communicationtactdiplomacyprioritizationself-starterquick learnerdeadline oriented