Project Controls & Reporting Analyst - Power BI & Analytics

Trans Mountain; Calgary; On-site; CAD 90,000 - 120,000; Part time

Job summary

Trans Mountain Corporation is seeking a collaborative Project Controls Reporting Analyst for the Pacific Link department in Calgary. The role focuses on delivering accurate project performance, financial, and management reporting to support leadership and governance.

You will develop dashboards, perform variance analyses, and ensure data integrity across multiple projects. The ideal candidate has 6–9 years in reporting or financial analysis, strong Excel and Power BI skills, and experience with

Qualifications

• Strong analytical skills interpreting financial and operational data.
• Demonstrated experience with financial and performance reports and dashboards.
• Experience supporting large capital projects in energy, infrastructure, or construction.
• Advanced proficiency with Excel, Power BI, Power Query, and related tools.

Responsibilities

• Prepare recurring and ad hoc financial, performance, and management reports including variance analysis.
• Develop and enhance Power BI dashboards, KPIs, data models and reporting solutions.
• Consolidate data from multiple projects and ensure data integrity and consistency.
• Coordinate with Project Controls, Finance and stakeholders to align reporting requirements.

Skills

Power BI

Power Query

Data analytics

Financial analysis

Excel

Education

Post-secondary education in Accounting, Finance, Economics, Business Administration, Data Analytics, or related discipline

Tools

Power Platform

Enterprise reporting systems

Job description

Trans Mountain Corporation is seeking a collaborative Project Controls Reporting Analyst for the Pacific Link department in Calgary. The role focuses on delivering accurate project performance, financial, and management reporting to support leadership and governance.

You will develop dashboards, perform variance analyses, and ensure data integrity across multiple projects. The ideal candidate has 6–9 years in reporting or financial analysis, strong Excel and Power BI skills, and experience with