Bi Analyst
PACT - Pearson Accelerator Construction Team
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 & InnovationIngest and archive raw data from source systems, including Autodesk Construction Cloud and BambooHR, into the Bronze layer as a permanent, auditable recordDevelop transformation logic in the Silver layer to clean, standardize and link data from disparate systems into a unified operational viewAggregate data into optimized, business-ready Gold layer datasets that serve as the reporting foundationMonitor pipeline runs, investigate failures through to root cause, and correct data quality issues before they reach published reportsDocument pipeline logic, data lineage and source dependencies so work remains supportable beyond any single analystUse governed connection patterns for pipeline connections, including service accounts and approved secret storage, rather than individual credentialsBI Development and Visualization
Design and build interactive Power BI dashboards that let a user understand project status at a glanceDevelop semantic models, measures and KPI definitions consistent with the definitions agreed across the Data & Innovation teamBuild and maintain dashboards tailored to client monthly reporting obligations, including the automation of contractual reports such as Schedule J and Schedule BMaintain automated refresh schedules so leadership has current data without manual intervention, and resolve refresh failures promptlyApply consistent visual standards, naming and layout conventions across published reportsPublish reports into the governed Power BI workspaces and follow the promotion path from development through to productionRetire and consolidate duplicate or superseded reports as part of routine dashboard inventory maintenanceDeliver 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 betterBuild integrations to and from other platforms, including geospatial systems, so program data reaches the tools stakeholders actually useApplied 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 scopeContribute 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 systemsBuild Power Automate flows and Power Apps where an automated process or a purpose-built app answers the requirement better than a reportTest AI-generated output against source data and flag where results are unreliable before they are relied onPrototype and evaluate new Microsoft Fabric, Power Platform and AI capability at the direction of the Manager, Data & InnovationData Quality and Governance
Validate published figures against source systems so teams make decisions from the same verified numbersApply workspace, dataset and row-level security settings so report sharing stays within the approved access modelEscalate data ownership questions and unresolved source system discrepancies to the Manager, Data & InnovationProduce access and sharing evidence for the Power BI estate in support of the quarterly access review cycle coordinated by the Manager, Security & ComplianceKeep dataset and report documentation current, including refresh dependencies and owner of recordStakeholder 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 askedAttend stakeholder and leadership sessions to demonstrate reports, gather feedback and agree changesExplain data and methodology to non-technical audiences so the numbers are understood and trustedProvide second-line support for report and dashboard issues raised through the IT helpdesk ticket intakeDeliver short user guidance sessions on reading and using published dashboardsCoordinate with the SharePoint Administrator and Azure 365 Administrator on data sources, connections and access hosted in SharePoint and the Microsoft 365 tenantWORKING 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 reportingDemonstrated Power BI development experience covering semantic modelling, DAX measures, report design and scheduled refreshWorking experience with Microsoft Fabric or an equivalent lakehouse or data warehouse platform, including layered pipeline patternsSQL proficiency for data transformation, validation and troubleshooting, with Power Query and DAX practical experienceExperience integrating data from line-of-business systems through APIs, connectors or scheduled extractsData quality discipline, including reconciliation of published figures against source systemsClear written and verbal communication, with the ability to present data to non-technical stakeholdersDocumentation discipline covering data lineage, measure definitions and report ownership kept currentPost-secondary education in information technology, data analytics, engineering or a related discipline, or equivalent practical experienceConstruction, engineering or major capital program experience preferred, with exposure to Autodesk Construction Cloud, Primavera P6 or Oracle data an assetMicrosoft certifications such as PL-300 or DP-600 preferredPower Automate or Power Apps build experience, and exposure to ISO 27001 or SOC 2 control environments, considered an assetExposure to AI agent, Copilot or large language model tooling applied to business data, including preparing datasets for agent consumption, considered an assetGIS or geospatial data experience, such as ArcGIS, Esri or site sensor and camera feeds, considered an assetData integration and API experience, including REST APIs, authentication patterns and handling of API keys and secrets, considered an assetKey Deliverables
Bronze, Silver and Gold pipeline layers built and running on schedule for the assigned data domainsPublished Power BI dashboards in the governed workspaces, refreshing on schedule without manual interventionClient monthly reporting obligations, including Schedule J and Schedule B, produced from automated reports rather than manual assemblyDocumented data lineage, measure definitions and refresh dependencies for every report the role ownsReconciliation evidence showing published figures agree with source systemsPower BI access and sharing evidence available on request for the quarterly access review cycleReport and dashboard requests routed and tracked consistently through the IT helpdesk ticket intakeGoverned datasets prepared and documented so Copilot and AI agents return reliable answers within the approved permission scopeWorking integrations between PACT data sources and the downstream platforms that consume them, built on governed connections rather than individual credentialsPACT 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.
#J-18808-Ljbffr
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 & InnovationIngest and archive raw data from source systems, including Autodesk Construction Cloud and BambooHR, into the Bronze layer as a permanent, auditable recordDevelop transformation logic in the Silver layer to clean, standardize and link data from disparate systems into a unified operational viewAggregate data into optimized, business-ready Gold layer datasets that serve as the reporting foundationMonitor pipeline runs, investigate failures through to root cause, and correct data quality issues before they reach published reportsDocument pipeline logic, data lineage and source dependencies so work remains supportable beyond any single analystUse governed connection patterns for pipeline connections, including service accounts and approved secret storage, rather than individual credentialsBI Development and Visualization
Design and build interactive Power BI dashboards that let a user understand project status at a glanceDevelop semantic models, measures and KPI definitions consistent with the definitions agreed across the Data & Innovation teamBuild and maintain dashboards tailored to client monthly reporting obligations, including the automation of contractual reports such as Schedule J and Schedule BMaintain automated refresh schedules so leadership has current data without manual intervention, and resolve refresh failures promptlyApply consistent visual standards, naming and layout conventions across published reportsPublish reports into the governed Power BI workspaces and follow the promotion path from development through to productionRetire and consolidate duplicate or superseded reports as part of routine dashboard inventory maintenanceDeliver 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 betterBuild integrations to and from other platforms, including geospatial systems, so program data reaches the tools stakeholders actually useApplied 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 scopeContribute 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 systemsBuild Power Automate flows and Power Apps where an automated process or a purpose-built app answers the requirement better than a reportTest AI-generated output against source data and flag where results are unreliable before they are relied onPrototype and evaluate new Microsoft Fabric, Power Platform and AI capability at the direction of the Manager, Data & InnovationData Quality and Governance
Validate published figures against source systems so teams make decisions from the same verified numbersApply workspace, dataset and row-level security settings so report sharing stays within the approved access modelEscalate data ownership questions and unresolved source system discrepancies to the Manager, Data & InnovationProduce access and sharing evidence for the Power BI estate in support of the quarterly access review cycle coordinated by the Manager, Security & ComplianceKeep dataset and report documentation current, including refresh dependencies and owner of recordStakeholder 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 askedAttend stakeholder and leadership sessions to demonstrate reports, gather feedback and agree changesExplain data and methodology to non-technical audiences so the numbers are understood and trustedProvide second-line support for report and dashboard issues raised through the IT helpdesk ticket intakeDeliver short user guidance sessions on reading and using published dashboardsCoordinate with the SharePoint Administrator and Azure 365 Administrator on data sources, connections and access hosted in SharePoint and the Microsoft 365 tenantWORKING 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 reportingDemonstrated Power BI development experience covering semantic modelling, DAX measures, report design and scheduled refreshWorking experience with Microsoft Fabric or an equivalent lakehouse or data warehouse platform, including layered pipeline patternsSQL proficiency for data transformation, validation and troubleshooting, with Power Query and DAX practical experienceExperience integrating data from line-of-business systems through APIs, connectors or scheduled extractsData quality discipline, including reconciliation of published figures against source systemsClear written and verbal communication, with the ability to present data to non-technical stakeholdersDocumentation discipline covering data lineage, measure definitions and report ownership kept currentPost-secondary education in information technology, data analytics, engineering or a related discipline, or equivalent practical experienceConstruction, engineering or major capital program experience preferred, with exposure to Autodesk Construction Cloud, Primavera P6 or Oracle data an assetMicrosoft certifications such as PL-300 or DP-600 preferredPower Automate or Power Apps build experience, and exposure to ISO 27001 or SOC 2 control environments, considered an assetExposure to AI agent, Copilot or large language model tooling applied to business data, including preparing datasets for agent consumption, considered an assetGIS or geospatial data experience, such as ArcGIS, Esri or site sensor and camera feeds, considered an assetData integration and API experience, including REST APIs, authentication patterns and handling of API keys and secrets, considered an assetKey Deliverables
Bronze, Silver and Gold pipeline layers built and running on schedule for the assigned data domainsPublished Power BI dashboards in the governed workspaces, refreshing on schedule without manual interventionClient monthly reporting obligations, including Schedule J and Schedule B, produced from automated reports rather than manual assemblyDocumented data lineage, measure definitions and refresh dependencies for every report the role ownsReconciliation evidence showing published figures agree with source systemsPower BI access and sharing evidence available on request for the quarterly access review cycleReport and dashboard requests routed and tracked consistently through the IT helpdesk ticket intakeGoverned datasets prepared and documented so Copilot and AI agents return reliable answers within the approved permission scopeWorking integrations between PACT data sources and the downstream platforms that consume them, built on governed connections rather than individual credentialsPACT 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.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Bi Analyst in Winnipeg, MB vacancy
- BI Analyst - Civil ProductsDescriptionAs a key member of the Civil Products Business Intelligence team, the Business Intelligence Analyst designs, develops, and maintains analytical solutions that support strategic and operational decision-making across the organization. This...Business intelligenceWorldwideFlexible hours
- ...le milieu événementiel. Votre mandatLa division Événements, Projets et Musique du groupe Multicolore est à la recherche d’un.E Analyste BI pour venir compléter l’équipe des Finances. Le poste est à temps plein et permanent. Relevant du Directeur des Finances, vous êtes...Business intelligenceDaily paidPermanent employmentFull timeContract workFlexible hours
- Type de poste: PermanenteTitre du poste: Analyste fonctionnel·le BINuméro de la demande: 50222Catégorie d'emploi: AdministrationDivision... ...Votre mission dans l’équipe :L’analyste fonctionnel·le BI est chargé·e de fournir un soutien continu aux opérations, d’aider...Business intelligencePermanent employmentWork at officeRemote workFlexible hours
- ...Fujitsu. Grandissons ensemble et créons un avenir meilleur. Tâches Contribuer à l’implantation et l’évolution de l’environnement Power BI avec les parties prenantes selon le cadre d’architecture en vigueur. Extraire, nettoyer, analyser et organiser des données provenant...Suggested
- ...qui favorisent la création de valeur et la croissance des entreprises. Le rôle :Ingénieur(e) / Analyste de données BINous recherchons un(e) Ingénieur(e) / Analyste de données BI expérimenté(e) pour contribuer à la conception, au développement et à l’optimisation de...Business intelligenceApprenticeshipWork at officeFlexible hoursDay shift
- Idexia recherche pour l'un de ses clients un(e) analyste fonctionnel BIMandat en mode hybride à Québec.Responsabilités:Analyser et documenter les besoins d'affairesConcevoir des solutions d'intelligence d'affaires adaptées aux besoins des utilisateursProduire des maquettes...Business intelligence
- # BI & Data AnalystMontreal, QC (Hybrid)Full-timeAt Flex Travel Solutions, we foster an environment of passion, innovation and collaboration... ...technology first company, we're currently looking for a BI & Data Analyst to join our team.The Role: As a BI & Data Analyst at FTS, you will...Business intelligenceWork at office
- Contrat et modalités Notre client recherche un ou une Analyste programmeur BI. CV en français.Contrat consultant :6 mois renouvelables (possibilité d'être salarié aussi sur payroll, lié au contrat).Taux horaire estimé par notre cabinet : 80-85 $/h pour 35 h/semaine....Business intelligenceHourly payContract workWork at office2 days per week
- ...La dynamique de votre équipe: Nous recherchons un(e) analyste de données en intelligence d’affaires hautement qualifié(e) pour rejoindre... ...données dans le nuage Azure, ainsi que Microsoft Fabric et Power BI. Tandis que des ingénieurs de données spécialisés se chargeront du...Business intelligenceFlexible hoursDay shift
- ...Terrebonne, soutenez l’intelligence d’affaires de METRO grâce à votre expertise en SQL et en modélisation, en mode hybride.L’analyste fonctionnel·le BI assure le soutien continu des opérations et accompagne les projets, de la conception à la mise en œuvre. Vous établissez le...Business intelligence
- Appuyez un comptoir de données Azure reliant des systèmes patrimoniaux à l’assurance collective avec modélisation, ETL et Power BI.Ce mandat d’analyste d’affaires et fonctionnel relie plusieurs systèmes au nouveau système d’assurance collective. Vous examinez les flux de...Business intelligence
- We are looking for a Senior Data and BI Analyst who will report to the team lead of the Data Quality to Insights team, and who’ll be tasked with turning complex Snowflake data assets into reliable reporting, AI tools, and actionable insights that directly drive top-line revenue...Business intelligenceSummer workFlexible hours
- IPEX recrute un Analyste Financier Principal, expert en BI, pour piloter les projets financiers. Apportez votre leadership pour le reporting et la transformation des processus. En tant qu'Analyste Financier Principal chez IPEX, vous soutiendrez les entités nord-américaines...Business intelligence
- ...renseignements fiables grâce à l’analytique et aux tableaux de bord opérationnels. Ce rôle soutient un projet spécifique.Comme analyste d’affaires et BI intermédiaire, vous contribuerez à l’habilitation et à la gouvernance de l’approvisionnement. Vous recueillerez, nettoierez,...Business intelligence
- Job TitleSAP BI Reporting Analyst Location: Calgary, AlbertaWork Environment: In officePrecision Drilling is a leading land drilling contractor providing High Performance, High Value services across North America and select international markets. Guided by our Core Values...Business intelligenceFor contractorsWork at officeFlexible hours
- Nous recrutons un ou une analyste d'affaires et fonctionnel pour accompagner jusqu'à sa livraison finale, le comptoir de données de l'assurance... ...dans un environnement Azure, avec une restitution sous Power BI. Le rôle se situe à l'interface entre les secteurs d'affaires et...Business intelligence
- À Québec, analysez des données avec Power BI et SQL pour produire des rapports fiables. Le poste s’exerce uniquement sur le lieu principal.Chez Fujitsu, l’Analyste Power BI contribue à l’évolution de l’environnement analytique avec les parties prenantes. Vous extrayez, nettoyez...
- Possibilités de carrière: Analyste développeur·se BI (50218) ID de demande 50218 -Affiché 2026-11-02 - Pays (1) - Province (1) - Ville (1) - Administration - Permanent - Technologie de l'informationTitre du poste: Analyste développeur·se BINuméro de la demande: 50218Catégorie...Business intelligencePermanent employmentFlexible hoursNight shiftAfternoon shift
- ...ecosystem to improve efficiency and data quality.Build and maintain dashboards, visualizations, dataflows, and semantic models in Power BI and Microsoft Fabric to monitor performance and generate insights.Work with stakeholders to define reporting needs, deliver effective solutions...Business intelligence
- Business Analyst – Business Intelligence (BI) Business Analyst – Business Intelligence (BI) DetailInformationContract Duration 12 MonthsLocation Remote – Canada (must reside within Canada)Province New BrunswickClient Department of Health (DoH) – Symbio Program...Business intelligenceRemote work
- ...de données sont au cœur de ce poste senior chez TEHORA. Le travail s’effectue en télétravail ou chez le client selon le mandat.Comme analyste fonctionnel senior en intelligence d’affaires, vous conseillez le responsable de produit et collaborez avec les équipes projet. Vous...Business intelligenceRemote work
- ...Indicators (KPIs) using Business Intelligence tools (e.G., Power BI).Identify trends, gaps, risks, and opportunities through data analysis... ...applicable legally protected characteristics to apply.Job Analyst, Business Intelligence (BI)Primary Location Marcel-Laurin Plant...Business intelligenceFlexible hours
- ...deliver client‑centric services and solutions that better serve our customers and, ultimately, improve patients’ lives.As a Senior BI & Data Analyst, you’ll be a key driver of insight and innovation within our Enterprise Data and Analytics team. We’re looking for a curious,...Business intelligenceInternship
- Use SQL and Power BI to turn complex datasets into clear business insights. This Data Analyst role focuses on accurate reporting and actionable analysis.The Data Analyst collects, processes, and analyzes data from databases, spreadsheets, and APIs. You will create dashboards...
- Description : La personne titulaire du poste contribue aux activités d’habilitation et de gouvernance de l’approvisionnement en assurant la collecte, le nettoyage, la catégorisation, la validation et la gouvernance des données d’approvisionnement. Elle veille à l’exactitude,...Business intelligence
- À Québec, analysez les besoins d’affaires et concevez des solutions BI avec Power BI dans un mandat hybride. Créez des outils utiles aux utilisateurs.Idexia recherche un(e) analyste fonctionnel BI pour l’un de ses clients. Vous analyserez et documenterez les besoins d’affaires...Business intelligence
- Become a Power BI Analyst at BRP in Québec, part of an innovative team transforming data analytics. Your role will focus on delivering business insights and optimizing reporting tools. As a pivotal member of the team, you will identify reporting requirements alongside business...Business intelligence
- ...services professionnels en Ingénieire et en Sciences de la Vie par le biais de ses consultants. Nous couvrons des segments de marché tel que... ...Description Du Poste FOP CONSULTANTS est à la recherche d’un Analystes BI motivé à la réalisation de mandats. Les principales missions...Business intelligenceRemote work
- Transformez les données financières en tableaux de bord Power BI chez ALTEN Canada, avec Oracle NetSuite comme atout majeur.Ce poste d’Analyste financier·e combine reporting, contrôle des données et analyse des marges dans un groupe d’ingénierie et de conseil TI. Vous produirez...
- Analysez des données avec Power BI, SQL et Excel avancé chez Bombardier, selon des politiques de travail flexibles et hybrides.Comme Analyste, Intelligence d'Affaires, vous collecterez, structurerez et analyserez des données issues de sources multiples. Vous développerez des...Flexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Bi Analyst. Be the first to apply!
Related searches
- healthcare analyst Winnipeg, MB
- IT analyst Winnipeg, MB
- investigative analyst Winnipeg, MB
- records analyst Winnipeg, MB
- sustainability analyst Winnipeg, MB
- disability analyst Winnipeg, MB
- documentation analyst Winnipeg, MB
- sap analyst Winnipeg, MB
- health and safety analyst Winnipeg, MB
- construction analyst Winnipeg, MB

