{bc}
indeed

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

Lawyer's Professional Indemnity Company
Toronto, CAN
Fulltime, Contract
Hybrid
$71,000 per year
Discovered 4 weeks ago
ExcelPower QueryPower BIPythonSQLETL

Full Job Posting

Role overview

The Data/BI Analyst joins LAWPRO’s knowledge management team on a 12-month contract while the incumbent is on leave.

The role develops reports and interactive dashboards and presents insights to support data-informed decisions.

The role also supports and trains stakeholders and cross-functional colleagues.

Key responsibilities

  • Develop, compose, and maintain Excel and Power Query reports from varied data sources.
  • Develop, maintain, and publish Power BI dashboards to visualize data from varied sources.
  • Gather business requirements and translate them into actionable reports and dashboards.
  • Integrate Power BI dashboards and Excel/M-Query reports with SharePoint and other systems.
  • Train and support colleagues in using and modifying reports and dashboards for analysis and data-driven decisions.
  • Use Python and other tools to extract, parse, clean, normalize, and transform data into reporting datasets.
  • Monitor and optimize reporting tools for performance, accuracy, reliability, and responsiveness.
  • Share best practices and industry trends in reporting, visualization, Power BI, SharePoint integration, and database management.
  • Collaborate to identify and refine entity relationship diagrams for data sources.

Requirements

  • Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.
  • At least 5 years developing Excel, Power Query, and Power BI reports and dashboards.
  • Proficiency in data extraction, parsing, normalization, cleaning, transformation, and loading.
  • Proficiency in Python programming for ETL and database SQL queries and management.
  • Proficiency with data visualization tools and techniques.
  • Working knowledge of data warehousing and SharePoint administration, customization, and optimization.
  • Demonstrated problem-solving ability, attention to detail, and active listening; self-motivated with a sense of urgency.
  • Power BI or related technology certification is an asset.

Compensation

  • Target starting salary is $71,000 per year; final salary depends on experience, qualifications, and internal equity.

Benefits

  • Benefits include health and dental coverage, four weeks’ vacation, casual dress, flexible schedule, paid time off, and vision care.

Work arrangement

  • Hybrid remote work in Toronto, Ontario.

Application

  • Applications were requested by October 9, 2026.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today