Find work in Canada.

526,396 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 2 mins ago
Track Protection Worker
North American Rail Solutions
Toronto, ON
UNIVERSAL RAIL IS CURRENTLY BEING ASSISTED BY OUR RECRUITING TEAM BASED IN USA. QUALIFIED APPLICANTS MAY RECEIVE A PHONE CALL FROM A NUMBER WITHIN THE UNITED STATES.**
Added 2 mins ago
Casual Residence Worker, Mental Health (Aspen House Supported Living)
Connective
Mission, BC
Reports and is accountable to the Program Manager of the facility or their designate
Added 2 mins ago
GC
Part-time Security Officer - Flamboro Casino
Great Canadian Entertainment
Hamilton, ON · Dundas, ON
- Part-time
Under the direct supervision of the Manager, Security, this position is responsible for the safety and protection of team members, guests, the facility (both internal and external) and the…
Added 2 mins ago
Project Safety Manager
Turner Construction
Toronto, ON
…plans to mitigate risks, and drive changes to improve project team safety awareness and…
Added 2 mins ago
TC
Health & Safety Manager
Trinity Consultants Canada
Terrace, BC
- Full-time
The Health & Safety Manager will be responsible for leading and advancing health and safety initiatives across a multidisciplinary environmental consulting organization in Canada. The role…
Added 2 mins ago
Site Superintendent (Construction) - Nights
PACT
ON · Mississauga, Ontario
PACT (Pearson Accelerator Construction Team) is a General Partnership of Alberici, Amico, Kenaidan, and Obayashi, supported by design partners Egis, Mott MacDonald, and Weston Williamson +…
Added 2 mins ago
SL
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Possibilités d'emploi -futures/Advisor Trainee- Advisor Development Program -Future Opportunities
Sun Life
Montreal, QC · Pointe-Claire, QC
- Full-time
Your time will be split between working within Prospr advisor team (reporting to an ADP Sales Manager) and gaining exposure to the role of a standalone advisor (working with the local Sun…
Added 2 mins ago
SL
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Possibilités d'emploi -futures/Advisor Trainee- Advisor Development Program -Future Opportunities
Sun Life
Brossard, QC · Montreal, QC · Saint-Jean-sur-Richelieu, QC
- Full-time
Your time will be split between working within Prospr advisor team (reporting to an ADP Sales Manager) and gaining exposure to the role of a standalone advisor (working with the local Sun…
Added 2 mins ago
SL
Student, Data Analyst (Winter-Summer-Fall 2027)
Sun Life
Toronto, ON · Waterloo, ON · Sun Life Toronto One York
- Full-time
Reporting to the Manager, Data and Analytics, the Data Analyst Co-op will be responsible for the maintenance analytical solutions for the Sunlife Private Wealth team. As a member of the…
Added 2 mins ago
SL
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Possibilités d'emploi -futures/Advisor Trainee- Advisor Development Program -Future Opportunities
Sun Life
Blainville, QC · Laval, QC · Rouyn-Noranda, QC
- Full-time
Your time will be split between working within Prospr advisor team (reporting to an ADP Sales Manager) and gaining exposure to the role of a standalone advisor (working with the local Sun…
Added 2 mins ago
JA
Chargé(e) de projet / Project Manager
JR Automation
Montreal, QC · Saint-Laurent, QC
- Full-time
As a Project Manager within Hitachi Energy’s High Voltage Product Group, you will manage high-voltage grid integration projects from hand-off through final delivery. You will develop and…
Added 2 mins ago
JA
Gestionnaire de contrats – Ententes clients et réclamations soustraitants/Contract Manager (Customer Agreements and Subcontractor Claims) - CA
JR Automation
Montreal, QC · Saint-Laurent, QC
- Full-time
Join a team that keeps the world’s energy systems moving forward. As a Contract Manager at Hitachi Energy, you’ll play a critical role in shaping the success of complex, high impact…
Added 2 mins ago
BG
Service Manager
Brandt Group of Companies
Kamloops, BC
- Full-time
The Service Manager is responsible for managing the sales and delivery of equipment after-market support services (component diagnostics, repair, and replacement). The Service Manager is…
Added 2 mins ago
MT
Manager, Office Services & Facilities
Miller Thomson LLP
Toronto, ON · Greater Toronto Area, Canada
- Full-time
We are looking for a Manager, Office Services & Facilities to join the team in our Toronto Office!
Added 2 mins ago
AG
Senior SAP S/4HANA Basis Consultant
Addmore Group
Oshawa, ON
- Full-time
The Basis consultant is responsible for the technical integrity, performance and security of the SAP landscape. This role drives the installation, configuration, upgrading, and maintenance…
Added 2 mins ago
MC
Facilities Coordination Project Manager
MatchBox Consulting Group
Surrey, BC
- Contract
…Accounting & Finance. We offer unrivaled expertise with our team's extensive experience in the recruitment and professional services industry. We are dedicated to building great connections…
Added 16 mins ago
C
Senior Consultant, Control Optimization & Analytics
CIBC
Toronto, ON
- Full-time
…contributor for developing and delivering on the Advanced Analytics team’s technical solution strategies and commitment to develop, support, and continuously improve analytics capabilities…
Added 17 mins ago
Client Service Assistant
The Canada Life Assurance Company
Toronto, ON
…Investment Only plans. Working closely with the Customer Service team, you will provide administrative and operational support to ensure a positive experience for plan sponsors and…
Added 17 mins ago
Registered Nurse (N2) - Surgery Resource Team
Winnipeg Regional Health Authority
Winnipeg, MB
Under the general supervision of the Manager Health Services, and while demonstrating a commitment to the Mission, Values and Management Philosophy of St. Boniface Hospital, the Registered…
Added 31 mins ago
R
Shift Manager
Ricoh
Toronto, ON
- Full-time
Ensures employee safety by educating the production team on proper safety procedures and programs.
Added 31 mins ago
R
Senior Field Representative, Technology Service
Ricoh
Victoria, BC
- Full-time
Ability to work independently, as part of a team and take initiative to improve the customer experience
Added 32 mins ago
JA
Spécialiste de l’appel d’offres / Quotation Tender Specialist
JR Automation
Montreal, QC · Saint-Laurent, QC
- Full-time
Are you ready to take your career to the next level? Join our innovative team as a Quotation Tender Specialist in the Transformer Service group! Reporting to the Tendering and Quotation…
Added 32 mins ago
JA
Spécialiste de l’appel d’offres - Services haute tension / Quotation Tender Specialist - High Voltage Services
JR Automation
Montreal, QC · Saint-Laurent, QC
- Full-time
Join our innovative team as a Quotation Tender Specialist in the High Voltage Service group! Reporting to the Tendering Manager, you'll lead and complete RFQs for Switchgear after sales…
Added 32 mins ago
JA
HSSE Manager - New construction
JR Automation
London, ON
- Full-time
At Hitachi Energy, you will support and enable Health, Safety, Security, and Environment (HSSE) efforts during the design, construction, installation, commissioning, and startup of a new…
Added 32 mins ago
JA
Spécialiste de l’appel d’offres / Quotation Tender Specialist
JR Automation
Richmond, BC
- Full-time
Are you ready to take your career to the next level? Join our innovative team as a Quotation Tender Specialist in the Transformer Service group! Reporting to the Tendering and Quotation…

PACT

BI Analyst

ON, Canada
Mississauga, ON, L4V 1A3, Canada

Apply About employer

Applications open in a new tab.

Job details

Posting language: English
Posted: Oct 29, 2026

Original job description

The BI Analyst builds and maintains the data pipelines, models, reports and applied AI capability that PACT (Pearson Accelerator Construction Team), a General Partnership of Alberici, Amico, Kenaidan and Obayashi, relies on to understand program status. Power BI is the primary delivery platform, but the role works across the wider Microsoft data estate - Microsoft Fabric pipelines and lakehouses, Power Platform automation and apps, and the integrations that connect source systems such as Autodesk Construction Cloud, BambooHR and geospatial platforms. The position delivers scheduled client and contractual reporting, keeps refreshes running without manual intervention, contributes to AI agent and Copilot work that lets stakeholders query program data directly, and works with business owners to translate requirements into working products. Delivery standards, platform capacity, licensing and workspace governance are set by the Manager, Data & Innovation; the BI Analyst builds to those standards and raises exceptions.

RESPONSIBILITIES

Data Engineering and Pipeline Delivery

Build and maintain data pipelines in Microsoft Fabric to the standards and architecture set by the Manager, Data & Innovation
Ingest and archive raw data from source systems, including Autodesk Construction Cloud and BambooHR, into the Bronze layer as a permanent, auditable record
Develop transformation logic in the Silver layer to clean, standardize and link data from disparate systems into a unified operational view
Aggregate data into optimized, business-ready Gold layer datasets that serve as the reporting foundation
Monitor pipeline runs, investigate failures through to root cause, and correct data quality issues before they reach published reports
Document pipeline logic, data lineage and source dependencies so work remains supportable beyond any single analyst
Use governed connection patterns for pipeline connections, including service accounts and approved secret storage, rather than individual credentials

BI Development and Visualization

Design and build interactive Power BI dashboards that let a user understand project status at a glance
Develop semantic models, measures and KPI definitions consistent with the definitions agreed across the Data & Innovation team
Build and maintain dashboards tailored to client monthly reporting obligations, including the automation of contractual reports such as Schedule J and Schedule B
Maintain automated refresh schedules so leadership has current data without manual intervention, and resolve refresh failures promptly
Apply consistent visual standards, naming and layout conventions across published reports
Publish reports into the governed Power BI workspaces and follow the promotion path from development through to production
Retire and consolidate duplicate or superseded reports as part of routine dashboard inventory maintenance
Deliver output in the form that fits the requirement - Power BI as the primary platform, with paginated reports, structured data extracts, Power Apps or direct feeds to other systems where those serve the user better
Build integrations to and from other platforms, including geospatial systems, so program data reaches the tools stakeholders actually use

Applied AI and Emerging Capability

Prepare and maintain governed datasets so they can be consumed safely by Microsoft Copilot and AI agents, including table and measure descriptions, relationships and permission scope
Contribute to the build and testing of AI agents that let stakeholders query program data directly, including agents connected to Autodesk Construction Cloud and other source systems
Build Power Automate flows and Power Apps where an automated process or a purpose-built app answers the requirement better than a report
Test AI-generated output against source data and flag where results are unreliable before they are relied on
Prototype and evaluate new Microsoft Fabric, Power Platform and AI capability at the direction of the Manager, Data & Innovation

Data Quality and Governance

Validate published figures against source systems so teams make decisions from the same verified numbers
Apply workspace, dataset and row-level security settings so report sharing stays within the approved access model
Escalate data ownership questions and unresolved source system discrepancies to the Manager, Data & Innovation
Produce access and sharing evidence for the Power BI estate in support of the quarterly access review cycle coordinated by the Manager, Security & Compliance
Keep dataset and report documentation current, including refresh dependencies and owner of record

Stakeholder Engagement and Support

Work directly with business owners and subject matter experts across the program to gather reporting requirements and confirm that delivered reports answer the question asked
Attend stakeholder and leadership sessions to demonstrate reports, gather feedback and agree changes
Explain data and methodology to non-technical audiences so the numbers are understood and trusted
Provide second-line support for report and dashboard issues raised through the IT helpdesk ticket intake
Deliver short user guidance sessions on reading and using published dashboards
Coordinate with the SharePoint Administrator and Azure 365 Administrator on data sources, connections and access hosted in SharePoint and the Microsoft 365 tenant

WORKING CONDITIONS

The position will be based at our office in Mississauga, Ontario, with visits to the Airport site as required. Your work schedule will be Monday to Friday during regular office or site hours. At times, operational needs may require work outside these hours, with reasonable notice provided. All schedule or on‑call adjustments will comply with applicable employment standards legislation. It is mandatory for all employees to complete a Criminal Background check and successfully attain a Restricted Access Identity Card (RAIC) upon joining the company.

DESIRED SKILLS, KNOWLEDGE, COMPETENCIES

Two to four years of hands-on business intelligence or data analyst experience delivering production reporting
Demonstrated Power BI development experience covering semantic modelling, DAX measures, report design and scheduled refresh
Working experience with Microsoft Fabric or an equivalent lakehouse or data warehouse platform, including layered pipeline patterns
SQL proficiency for data transformation, validation and troubleshooting, with Power Query and DAX practical experience
Experience integrating data from line-of-business systems through APIs, connectors or scheduled extracts
Data quality discipline, including reconciliation of published figures against source systems
Clear written and verbal communication, with the ability to present data to non-technical stakeholders
Documentation discipline covering data lineage, measure definitions and report ownership kept current
Post-secondary education in information technology, data analytics, engineering or a related discipline, or equivalent practical experience
Construction, engineering or major capital program experience preferred, with exposure to Autodesk Construction Cloud, Primavera P6 or Oracle data an asset
Microsoft certifications such as PL-300 or DP-600 preferred
Power Automate or Power Apps build experience, and exposure to ISO 27001 or SOC 2 control environments, considered an asset
Exposure to AI agent, Copilot or large language model tooling applied to business data, including preparing datasets for agent consumption, considered an asset
GIS or geospatial data experience, such as ArcGIS, Esri or site sensor and camera feeds, considered an asset
Data integration and API experience, including REST APIs, authentication patterns and handling of API keys and secrets, considered an asset

Key Deliverables

Bronze, Silver and Gold pipeline layers built and running on schedule for the assigned data domains
Published Power BI dashboards in the governed workspaces, refreshing on schedule without manual intervention
Client monthly reporting obligations, including Schedule J and Schedule B, produced from automated reports rather than manual assembly
Documented data lineage, measure definitions and refresh dependencies for every report the role owns
Reconciliation evidence showing published figures agree with source systems
Power BI access and sharing evidence available on request for the quarterly access review cycle
Report and dashboard requests routed and tracked consistently through the IT helpdesk ticket intake
Governed datasets prepared and documented so Copilot and AI agents return reliable answers within the approved permission scope
Working integrations between PACT data sources and the downstream platforms that consume them, built on governed connections rather than individual credentials

PACT is an equal opportunity employer and is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. We are committed to providing an inclusive and barrier free candidate experience and work environment. If you require accommodation to apply or if selected to participate in an assessment process, please advise Human Resources.

Apply About employer

More about this job

Responsibilities

The BI Analyst is responsible for building and maintaining data pipelines, models, and reports within the Microsoft Fabric ecosystem to support program status visibility. They will also contribute to AI agent development and ensure data quality and governance standards are met across all reporting products.

Requirements

Candidates should have two to four years of hands-on experience in business intelligence or data analysis, with proficiency in Power BI, SQL, and data pipeline architecture. A post-secondary education in a relevant field is required, and experience in construction or major capital programs is preferred.

Skills

Power BI
Microsoft Fabric
Data Engineering
SQL
DAX
Power Query
Data Visualization
Data Modeling
Power Automate
Power Apps
API Integration
Data Governance
Data Quality
Applied AI
Microsoft Copilot

Visa sponsorship

Not detected in the job text

Keywords

BI Analyst
Microsoft Fabric
Power BI
Data Pipelines
Data Engineering
SQL
DAX
Power Query
Power Automate
Power Apps
Autodesk Construction Cloud
BambooHR
Data Governance
Data Quality
AI Agents
Microsoft Copilot
API
Geospatial
Data Lineage
Semantic Modeling
KPI
Reporting
Data Analytics
Information Technology
Construction
Engineering
Primavera P6
Oracle
ISO 27001
SOC 2

Report this job