Project Controls Reporting Analyst, Pacific Link

Select how often (in days) to receive an alert: Project Controls Reporting Analyst, Pacific Link (Contract)

Trans Mountain Corporation operates Canada’s only pipeline system transporting oil products to the West Coast. We deliver approximately 890,000 barrels of petroleum products each day through a dual pipeline system of more than 1,150 kilometres of pipeline in Alberta, British Columbia and Washington state. Trans Mountain also operates a state-of-the-art loading facility, Westridge Marine Terminal, with three berths providing tidewater access to global markets. As a federal Crown corporation, Trans Mountain continues to build on more than 70 years of experience delivering operational and safety excellence through our crude oil pipeline system. With our expanded pipeline system now in place, Trans Mountain provides enhanced direct access for Canadian crude oil to world markets. The expansion realizes a world-class system for oil transport, developed to Canada’s high standards within one of the most stringent regulatory regimes in the world, creating long-term economic benefits, enhanced marine protection, enhanced safety and emergency management capabilities, and enhanced skilled-worker capacity building in communities and Indigenous groups. Our Core Values Trans Mountain’s core values – Safety, Integrity, Respect and Excellence – guide our every step. Each obstacle we’ve overcome or success we’ve experienced has been the result of a shared commitment to living these values every day. Together, we’re focused on doing the right thing for each other and our communities. If you are looking for an opportunity to apply your strengths in an environment that encourages Safety, Integrity, Respect, and Excellence, we invite you to explore this opportunity with us Location:

Calgary Head Office Department:

Pacific Link Reports to:

Manager, Reporting and Data Management Worker Type:

Contract Schedule Type:

Full-time Work Setting:

In-office Trans Mountain is seeking a collaborative, motivated, and values driven individual to join our dynamic team as a Project Controls Reporting Analyst, Pacific Link. In this position, you will play a key role in delivering accurate, timely, and decision-focused project performance, financial, and management reporting to support project leadership, governance, and organizational decision-making. The successful candidate will demonstrate expertise in reporting, data analysis, performance measurement, dashboard development, financial reporting, and data governance. This position offers the opportunity to contribute to a major infrastructure project while helping drive data integrity, reporting excellence, and informed business decisions. Key Responsibilities

Prepare and deliver recurring and ad hoc financial, performance, and management reports, including variance analysis, forecasts, reconciliations, and executive-level reporting. Analyze project performance data, identify trends and emerging issues, and provide insights to support leadership decision-making. Develop, maintain, and enhance Power BI dashboards, KPI scorecards, data models, and reporting solutions that translate complex project information into actionable insights. Consolidate and reconcile data from multiple projects, contractors, and corporate systems while ensuring accuracy, consistency, and data integrity. Maintain reporting standards, controls, documentation, and supporting records to ensure compliance with governance, audit, and information management requirements. Support audit and assurance activities by preparing supporting documentation, responding to information requests, and maintaining traceable reporting records. Collaborate with Project Controls, Finance, and business stakeholders to coordinate reporting requirements, resolve discrepancies, and improve reporting processes and data governance practices. Identify opportunities to enhance reporting efficiency through automation, process improvements, and continuous improvement initiatives. Qualifications and Professional Experience

Post-secondary education in Accounting, Finance, Economics, Business Administration, Data Analytics, or related discipline. 6 to 9 years of progressive experience in reporting, financial analysis, management reporting, data analytics, or related field. Experience supporting large capital projects within the energy, infrastructure, pipeline, industrial, construction, or related sectors is preferred. Demonstrated experience preparing financial and performance reports, dashboards, reconciliations, variance analysis, and management reporting packages. Strong analytical skills with the ability to interpret financial and operational data, identify trends, and communicate meaningful insights to stakeholders. Advanced proficiency with Microsoft Excel, Power BI, Power Query, and other reporting and data visualization tools. Experience using enterprise reportin