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

Toronto, ON
Hybrid
Posted Sep 30, 2026
1 position

$71,000 / year

Opens an external site

Employment type: Full-time
Experience level: Senior · 5+ years
Minimum education: Bachelor’s degree
Posting language: English
Working hours: 40 hours per week

Job summary

Develop and maintain Excel, Power Query, and Power BI reports and dashboards, preparing data from multiple sources with SQL, Python, and other tools. Work with stakeholders to define reporting needs, integrate dashboards with SharePoint and other systems, train users, optimize reporting solutions, and refine data-source entity relationship diagrams.

Job details

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. * Proficiency in database SQL queries/management. * 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. * Four weeks’ vacation. * Hybrid work option, providing flexibility while supporting collaboration and organizational needs. Interested applicants should submit their application by 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.

What you’ll do

Requirements

A bachelor's degree in Computer Science, Data Science, Information Systems, or a related field is required, along with 5+ years of experience developing Excel, Power Query, and Power BI reports and dashboards. Candidates should be proficient in Python, SQL, data extraction and ETL, and data visualization, with working knowledge of data warehousing and SharePoint; Power BI certification is an asset.