Project Controls Specialist – Power BI (Markham)

Project Controls Specialist – Power BI (Markham)

07 Nov
|
Worley
|
Markham

07 Nov

Worley

Markham

Job Description
- Project Controls Specialist – Power BI & Cost Control (MAR00XU) Project Controls Specialist – Power BI & Cost Control
- MAR00XU Company : Worley Primary Location CAN-ON-Markham Job Project Controls Schedule Full-time Employment Type : Employee Job Posting Unposting Date

About us
Worley is a global company of energy, chemicals and resources experts headquartered in Australia. We partner with our customers to deliver projects and create value across the life of their assets. We specialize in consulting, engineering, procurement and construction across the project lifecycle, with services extending through to operations and decommissioning. Leveraging extensive experience and AI-enabled delivery, we support customers in navigating complexity as they meet today's needs and transition to more sustainable solutions. Purpose We are currently recruiting for a Project Controls Specialist – Power BI & Cost Control. Our team includes world class experts and dynamic go-getters. This is a full-time position based in Markham, Ontario. We are currently recruiting for a Project Controls Specialist – Power BI & Cost Control. This is a full-time position based in Markham, Ontario, Canada. Responsibilities Power BI Development and Reporting
- Develop, maintain and enhance interactive Power BI dashboards, reports and visualizations for project and portfolio reporting.
- Translate Project Controls and stakeholder requirements into practical reporting solutions, semantic models, calculations and visualizations.
- Create and maintain Power BI semantic models, relationships, measures and calculations using DAX.
- Use Power Query to connect, transform, cleanse and combine data from multiple sources.
- Integrate project information from relevant systems, which may include EcoSys, Primavera P6, Excel,



SharePoint and other structured data sources.
- Develop reporting solutions that provide explicit visibility into project cost, schedule, progress, forecasting, productivity, change, risk and overall performance.
- Design executive-level and operational dashboards that make complex project information easy to understand and allow users to move from high-level indicators to supporting detail.
- Validate source data, calculations and dashboard outputs and reconcile results with approved project reports and source systems.
- Identify data/quality gaps and reporting inconsistencies and work with appropriate data owners to resolve them.
- Optimize data models, DAX calculations, queries and refresh processes to improve report performance, reliability and usability.
- Support Power BI Service requirements including scheduled refreshes, data connections, gateways, workspace controls and role-based access.
- Develop reusable reporting templates, common measures and standardized visualization approaches to promote consistent reporting across projects. Project Cost Control
- Perform project cost control activities for EPC/EPCM projects, including budget control, commitments, actual costs, forecasting, progress measurement, variance analysis, change management and performance reporting.
- Develop, implement and maintain project Work Breakdown Structures (WBS), Cost Breakdown Structures (CBS),



control accounts and project coding structures.
- Support the establishment and maintenance of project budgets, control budgets and cost baselines within applicable project systems.
- Monitor project expenditures, commitments and forecasts and identify emerging cost trends, variances and areas requiring corrective action.
- Prepare and maintain forecasts, including Estimate to Complete (ETC) and Estimate at Completion (EAC), working with project and functional stakeholders to validate forecast assumptions.
- Support project progress measurement and integration of progress, cost and schedule information into project performance reporting.
- Support project change-management processes to ensure approved and pending changes are appropriately identified, evaluated, tracked and incorporated into project cost and reporting systems.
- Maintain project cost systems and coding structures, including the appropriate funding, de-funding and closure of cost codes.
- Review and validate project transactions, including timesheet coding, procurement commitments, requisitions, purchase orders, subcontractor costs and other project expenditures as applicable.
- Prepare project cost reports, forecasts, variance analysis and other periodic or ad hoc Project Controls reporting.
- Reconcile project cost information between source systems, approved project reports and management reporting and investigate discrepancies.
- Maintain reporting calendars and support the timely completion and issue of required Project Controls deliverables.
- Identify emerging cost, forecast, progress and reporting issues and communicate concerns to Project Controls leadership and project management.
- Integrated Project Controls and Continuous I

📌 Project Controls Specialist – Power BI (Markham)
🏢 Worley
📍 Markham

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: project controls specialist – power bi (markham) / markham

Subscribe to this job alert:

Get the latest job offers by email for: project controls specialist – power bi (markham) / markham