Bi Analyst (Winnipeg)

Bi Analyst (Winnipeg)

18 Nov
|
PACT (Pearson Accelerator Construction Team)
|
Winnipeg

18 Nov

PACT (Pearson Accelerator Construction Team)

Winnipeg

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 current 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 demonstra

📌 Bi Analyst (Winnipeg)
🏢 PACT (Pearson Accelerator Construction Team)
📍 Winnipeg

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: bi analyst (winnipeg) / winnipeg

Subscribe to this job alert:

Get the latest job offers by email for: bi analyst (winnipeg) / winnipeg