Posted last month
Data / BI (Business Intelligence) Analyst (12-month contract)
@ Lawyers Professional Indemnity Company
Toronto, Ontario
Overview
Lawyers Professional Indemnity Company (LAWPRO) is hiring a Data/BI Analyst on a 12-month contract to cover a leave. The role builds Excel, Power Query and Power BI reports and dashboards from multiple data sources, uses Python and SQL for ETL, and trains stakeholders. The posting states full-time hours, a hybrid work option, a target salary of $71,000 per year, and immediate eligibility for health and dental benefits.
Pay:
$71,000 a year
Responsibilities:
- Développer et maintenir des rapports Excel et Power Query à partir de diverses sources
- Publier et maintenir des tableaux de bord Power BI
- Former et soutenir les membres de l'équipe dans l'utilisation des rapports
- Utiliser Python pour extraire, nettoyer et transformer les données
Requirements summary:
- Baccalauréat en informatique, science des données ou systèmes d'information
- 5 ans et plus d'expérience en Excel, Power Query et Power BI
- Maîtrise de Python et des requêtes SQL
- Connaissance pratique de SharePoint
Tools & skills
Benefits mentioned
Source and dates
Employer career site / ATS feed · ultipro
- Employer posting date
- 2026-09-28
- First seen by our source
- 2026-10-08
- Source record updated
- 2026-10-16
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Data & analytics |
| Experience | 5+ years |
| Hours per week | 40 (estimated) |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Education | Bachelor’s degree (required) |
| Fields of study | Computer Science, Data Science, Information Systems |
| Perks mentioned | Generous paid time off, Flexible hours |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Lawyers Professional Indemnity Company
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
LAWPRO provides professional liability insurance in Ontario and title insurance across Canada.
Full company description
Lawyers' Professional Indemnity Company (LAWPRO) is a wholly Canadian owned insurance company that provides professional liability insurance to lawyers in Ontario and TitlePLUS title insurance coast-to-coast. LAWPRO is headquartered in Toronto, Ontario, Canada. LAWPRO provides the primary insurance coverage for members of the Law Society of Ontario in private practice, plus an optional excess program for law firms that wish to buy additional coverage. LAWPRO's innovative risk management initiative, practicePRO helps educate lawyers on common legal malpractice risks and how to avoid them. Through its TitlePLUS operation, LAWPRO also provides comprehensive title insurance and legal services coverage for residential purchase and mortgage-only/refinance transactions handled by lawyers. Incorporated in 1990 by the Law Society of Ontario, LAWPRO has operated independently of the Law Society of Ontario since 1995, with its own management and Board of Directors. The LAWPRO team provides the Ontario bar with cost-effective liability insurance, expert claims administration, and proactive risk and practice management initiatives to help prevent claims.
- LinkedIn followers
- 7,234
- People associated on LinkedIn
- 190
- Reported office locations
- 250 Yonge Street, Suite 3101, P.O. Box 3, Toronto, Ontario M5B 2L7, CA
- Business categories
- Law Enforcement
- Insurance
- Other recorded names
- Lawyers Professional Indemnity Company
- LAWPRO
- Specialties
- Legal Malpractice Insurance
- Title Insurance
- Risk management
- Legal malpractice claims prevention
- and Law practice management
- Profile identifies a recruitment agency
- No
- Reported total investment
- 0
Currency and observation date were not supplied; this is not a current valuation or a funding round.
Lawyers' Professional Indemnity Company (LAWPRO) is a wholly Canadian owned insurance company that provides professional liability insurance to lawyers in Ontario and TitlePLUS title insurance coast-to-coast. LAWPRO is headquartered in Toronto, Ontario, Canada. LAWPRO provides the primary insurance coverage for members of the Law Society of Ontario in private practice, plus an optional excess program for law firms…
| Field | Value |
|---|---|
| Industry | Insurance |
| Company size | 51-200 employees |
| Headquarters | Toronto, Ontario |
| Organization type | Privately Held |
| Year founded | 1995 |
| Specialties | Legal Malpractice InsuranceTitle InsuranceRisk managementLegal malpractice claims preventionand Law practice management |
| Open jobs on Jobsy | 7 |
| View page |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.