Project Controls Specialist – Power BI & Cost Control

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. We are seeking a Project Controls professional with strong Power BI development capabilities to join our Project Controls team. This hybrid role combines Power BI development and analytics with hands-on project cost control responsibilities, providing an opportunity to both develop reporting solutions and directly support the projects and data those solutions serve. Approximately half of the role will focus on developing, maintaining and continuously improving Power BI dashboards, semantic models and reporting solutions. The remaining focus will be on cost control activities including budgeting, forecasting, commitments, actual costs, progress, change management, variance analysis and project performance reporting. Working closely with Project Controls, project management, engineering, procurement, construction, finance and data stakeholders, you will help ensure that project information is accurate, consistent, traceable and translated into clear, actionable insights. This is not a traditional software developer position. It is a specialized Project Controls role with significant Power BI development responsibilities, requiring both strong analytical and technical capabilities and practical knowledge of project cost control. 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 clear 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, va…

View the full posting and apply