Project Controls Reporting Analyst, Pacific Link

About Trans Mountain

Role overview

Key responsibilities

• Prepare recurring and ad hoc financial, performance, and management reports, including variance analysis, forecasts, reconciliations, and executive-level reporting.
• Analyze performance data, identify trends and emerging issues, and provide decision-making insights.
• Develop and enhance Power BI dashboards, KPI scorecards, data models, and reporting solutions.
• Consolidate and reconcile data from projects, contractors, and corporate systems while ensuring accuracy and integrity.
• Maintain reporting standards, controls, documentation, and records for governance, audit, and information management.
• Support audit and assurance requests with documentation and traceable reporting records.
• Coordinate requirements with Project Controls, Finance, and business stakeholders; resolve discrepancies and improve data governance.
• Identify automation, process improvement, and continuous improvement opportunities.

Qualifications and experience

• Post-secondary education in Accounting, Finance, Economics, Business Administration, Data Analytics, or a related discipline.
• Six to nine years of progressive experience in reporting, financial analysis, management reporting, data analytics, or a related field.
• Experience supporting large capital projects in energy, infrastructure, pipeline, industrial, or construction sectors is preferred.
• Experience preparing financial and performance reports, dashboards, reconciliations, variance analysis, and management reporting packages.
• Advanced proficiency with Excel, Power BI, Power Query, and reporting and visualization tools.
• Experience with enterprise reporting systems, databases, and data management platforms; Microsoft Power Platform familiarity is an asset.
• Knowledge of reporting controls, data governance, data quality, and internal controls; IFRS or U.S. GAAP knowledge is an asset.
• Audit and assurance experience is preferred; ability to integrate multiple data sources, manage priorities, and meet deadlines.

Work setting

• The position is based at the Calgary Head Office and the work setting is in-office.
• Support outside regular business hours may be needed during period-end, audit, or critical reporting cycles.

Work arrangement

Opportunity

• The posting describes professional development, career advancement, competitive compensation, and meaningful work in the Canadian energy industry.