Business Intelligence Analyst

Remote (GTA-based) · Full-time · Remote · Permanent · $80,000 - $90,000 CAD

Techno-functional BI analyst on a national IT team for a material-handling and automation provider. You will sit between business users and the data — gathering requirements, writing SQL against an ERP, modelling data, and building and enhancing Power BI dashboards. Remote, but GTA-based to attend the Mississauga office as needed.

A techno-functional Business Intelligence Analyst role on the national IT team of a material-handling and warehouse-automation provider. This is deliberately not a data scientist or data engineer position — the emphasis is on someone who understands the business problem first, then builds the reporting solution.

Your day looks like talking to business users, writing SQL, extracting data from an ERP, building dashboards, and translating requirements into reports that people actually use.

Schedule & location

Monday to Friday, 8:00am-5:00pm. Remote, but you must be GTA-based and able to attend the Mississauga office from time to time as required.

What you'll be doing

- Work directly with business stakeholders to understand reporting requirements - Extract data from legacy systems and ERP platforms - Write SQL queries and develop data models - Build and enhance dashboards and reports in Power BI - Ensure data quality and troubleshoot reporting issues - Support integrations between the ERP and other applications - Train end users and document reporting solutions

What we're looking for

- 3-5 years with Power BI and very strong SQL (minimum 3 years in a similar capacity) - Data modelling, ETL, Power Query and DAX - Advanced Microsoft Excel and solid database fundamentals - ERP reporting experience — any major platform transfers (SAP, Oracle, Dynamics, Epicor, Infor, NetSuite, Sage, JD Edwards) - Requirements gathering, stakeholder management and business analysis - Comfortable running user training and writing documentation

Compensation & benefits

- $80,000 - $90,000 CAD - 2-3 weeks vacation - Benefits after 3 months - Pension plan after 24 months

What you'll be doing

  • Gather reporting requirements directly from business stakeholders
  • Write SQL and build data models against ERP and legacy systems
  • Build and enhance Power BI dashboards and reports
  • Ensure data quality and troubleshoot reporting issues
  • Support ERP integrations with other applications
  • Train end users and document reporting solutions

What we're looking for

  • 3-5 years of Power BI development and very strong SQL
  • Data modelling, ETL, Power Query and DAX
  • Advanced Excel and solid database fundamentals
  • ERP reporting experience on any major platform
  • Strong requirements gathering and stakeholder management
  • GTA-based and able to attend a Mississauga office as needed