Data / Business Intelligence (BI) Analyst (12 month contract)

LAWPRO; Toronto; Hybrid; CAD 64,000 - 78,000; Full time

Benefits offered by this job

Hybrid work option

Health and Dental benefits

Job summary

LAWPRO invites a Data/BI Analyst to join our Knowledge Management team on a 12‑month contract. You will develop and publish Excel/Power Query reports and PowerBI dashboards, integrating data from multiple sources to support data‑driven decisions.

You will extract, clean and transform data with Python, train stakeholders, and collaborate across teams. Hybrid work is offered with competitive benefits and salary guidance.

Qualifications

• Bachelor's degree in Computer Science, Data Science, Information Systems or related field.
• Proficiency in data extraction, parsing, normalization, cleaning and transforming data.
• Proficiency in Python for ETL.
• 5+ years experience developing Excel, Power Query and PowerBI reports and dashboards.
• Strong problem solving, attention to detail and active listening.
• Self-starter and urgency-driven.
• Familiarity with data visualization techniques and data warehousing concepts.

Responsibilities

• Develop, maintain Excel and Power Query reports from multiple data sources.
• Develop, publish PowerBI dashboards to visualize data from various sources.
• Collaborate with stakeholders to translate requirements into reports/dashboards.
• Integrate PowerBI dashboards, Excel and M-Query reports into SharePoint and other systems.
• Train and support teammates on reports and dashboards for data analysis.
• Use Python and other tools to extract, clean, transform data and prepare data sets for reports.
• Monitor and optimize reports/dashboards for performance and accuracy.
• Share industry trends and best practices with the Knowledge Management team.
• Refine ERDs for data sources in collaboration with cross-functional teams.

Skills

Analytical thinking

Attention to detail

Problem solving

Active listening

Education

Bachelor’s degree in Computer Science / Data Science / Information Systems

Tools

PowerBI

Power Query

Python

SharePoint

M-Query

Job description

Data / Business Intelligence (BI) Analyst (12 month contract)

LAWPRO provides professional liability insurance to lawyers in Ontario and TitlePLUS® title insurance across Canada. Our mission is to help legal professionals practise with confidence by delivering insurance solutions, risk management expertise, and exceptional service. We are currently seeking an Data/BI Analyst to join our team on a 12-month contract (while the incumbent is on leave), providing an excellent opportunity to contribute to a respected organization that plays a vital role in supporting Canada’s legal community.

Job Description

The Data/BI Analyst, a member of the knowledge management team, specializes in developing reports and dashboards in, but not limited to, Excel, Power Query and PowerBI. Leveraging/utilizing various tools and technologies such as database queries/management, Python and data visualization using Microsoft PowerBI, the role will create and mine insights and present them via reports and interactive visualization dashboards to facilitate data supported decisions. In addition, the role will support and/or provide training to stakeholders and cross functional team members.

Key Responsibilities

• Develop, compose and maintain Excel and Power Query reports from various data sources
• Develop, compose, maintain and publish PowerBI dashboards to visualize data from various data sources
• Collaborate with business stakeholders and cross functional teams to understand/gather business requirements and translate into actionable reports and/or dashboards
• Collaborate with cross functional teams to integrate Microsoft PowerBI dashboards, Excel and M-Query reports into SharePoint and other systems to facilitate seamless user experience and access by stakeholders
• Train and support team members on how to modify and use the reports and PowerBI dashboards for data analysis/Business Intelligence and support data-driven decisions
• Leverage Python and other tools/technologies, where appropriate, to extract, parse, clean, normalize, transform data from various sources and establish data set(s) used in reports and dashboards
• Continuously monitor, refine and optimize the reports and dashboards for performance, accuracy, reliability and responsiveness
• Stay current and share key industry trends and best practices of reports and data visualizations, PowerBI, SharePoint integration and database management with the Knowledge Management team
• Collaborate with the cross functional team members to identify and refine ERD’s (Entity Relationship Diagrams) of various data sources

Job Specification

• Bachelor’s degree in Computer Science, Data Science, Information Systems or related field.
• Proficiency in data extraction from various sources; parsing, normalizing, cleaning, transforming and loading data to facilitate the composition of reports and dashboards.
• Proficiency in Python programming and to facilitate data ETL (Extract, Transform, Load).
• 5+ years experience developing Excel, Power Query and PowerBI reports and dashboards.
• Demonstrated strengths in problem solving abilities, attention to details and active listening.
• Self-starter, self-motivated and can work with a sense of urgency.
• Proficient with data visualization tools and techniques.
• Working knowledge of data warehousing concepts and techniques.
• Working knowledge of SharePoint administration, customization and optimization.
• Certification in PowerBI and/or related technologies is an asset.

LAWPRO Offers

• LAWPRO is an Ontario Certified Living Wage Employer. We offer competitive compensation commensurate with skills and experience.
• This role has a target starting salary of $71,000 per year. Final salary is determined based on experience, qualifications, and internal equity.
• Immediate eligibility for comprehensive Health and Dental benefits.
• Hybrid work option, providing flexibility while supporting collaboration and organizational needs.

October 9, 2026. Please note, LAWPRO does not utilize artificial intelligence (AI) in its recruitment practices at this time.

Diversity and inclusion matter at LAWPRO. If contacted for an interview, please advise if you require accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act.

My LAWPRO

Log in to access secured My LAWPRO content, tools, and resources.

LAWPRO provides errors and omissions insurance to Ontario lawyers in private practice. LAWPRO’s TitlePLUS title insurance program is available to Canadian lawyers and Quebec notaries.

The offices of LAWPRO are located on the traditional territory of many nations including the Mississaugas of the Credit, Anishnabeg, Chippewa, Haudenosaunee and Wendat peoples. Toronto is covered by Treaty 13 with the Mississaugas of the Credit. LAWPRO respects and acknowledges the histories, languages, knowledge systems, and cultures of First Nations, Metis, and Inuit nations.