Project Controls Reporting Analyst, Pacific Link (Contract)

Trans Mountain Corporation; Calgary; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

Trans Mountain Corporation seeks a Project Controls Reporting Analyst for the Pacific Link to deliver accurate, timely project performance, financial, and management reporting to support leadership decisions. The role focuses on dashboards, data governance, IFRS considerations, and collaboration with Project Controls, Finance, and stakeholders to improve reporting processes.

This in-office, full-time contract position offers exposure to a major infrastructure program and opportunities for

Qualifications

• 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, or related field.
• Experience supporting large capital projects within energy, infrastructure, pipeline, construction, or related sectors preferred.
• Demonstrated experience preparing financial and performance reports, dashboards, variances, and management reporting packages.
• Strong analytical skills with the ability to interpret data, identify trends, and communicate insights.

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 provide insights to support leadership decision-making.
• Develop, maintain, and enhance Power BI dashboards, KPI scorecards, data models, and reporting solutions.
• Consolidate and reconcile data from multiple projects, contractors, and corporate systems with data integrity.
• Maintain reporting standards, controls, documentation, and records for governance and audits.
• Support audits and assurance activities with documentation and traceability.
• Collaborate with Project Controls, Finance, and stakeholders to coordinate reporting requirements and improve processes.
• Identify opportunities to increase reporting efficiency through automation and continuous improvement.

Skills

Power BI

Excel

Data analysis

Dashboard development

Data governance

Communication

IFRS knowledge

Education

Accounting/Finance/Economics/Business Administration/Data Analytics degree

Tools

Power Query

Power Platform

Enterprise reporting systems

Job description

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 reporting systems, reporting databases, and data management platforms; familiarity with Microsoft Power Platform is an asset.
• Strong understanding of reporting controls, data governance, data quality practices, and internal control principles; knowledge of IFRS or U.S. GAAP is considered an asset.
• Experience supporting audits, assurance reviews, governance reporting, and maintaining accurate supporting documentation is preferred.
• Proven ability to integrate data from multiple sources, manage competing priorities, and meet recurring reporting deadlines while maintaining accuracy and attention to detail.
• A track record of delivering high-quality work, managing competing priorities, and supporting key business processes or operational functions.
• Demonstrated ability to work effectively with colleagues and stakeholders from a variety of backgrounds and levels across the organization.
• Effective communication skills, including the ability to convey information clearly, respectfully, and professionally.
• Proven organizational skills with the ability to manage priorities, meet deadlines, and maintain attention to detail in a fast-paced environment.
• Commitment to inclusive practices and a willingness to contribute positively to a collaborative and supportive workplace culture.

Working Conditions

• May be required to provide support outside regular business hours during period-end, audit, or critical reporting cycles.

We Build Careers and Pipelines That Last

Our story is about determination, resourcefulness and resilience. It’s about charting our own course, finding innovative solutions to challenging problems and doing the right thing. It was true when Trans Mountain became a company in 1951 and it’s just as true today. We welcome new members to our team that embrace the qualities in our story, that thrive on the new path and directions we take. Our culture is one of care and taking our responsibilities seriously. If you would like to contribute to our culture, then join our journey.

We offer:

• Valuable experience providing opportunity for professional development and career advancement;
• An opportunity to engage with and learn from some of the most talented and experienced people in the business;
• Competitive compensation;
• A place to share a sense of purpose and build relationships;
• Meaningful work that makes a difference;
• An opportunity within the Canadian energy industry.

We value:

• The health, safety and wellness of everyone working in our company;
• Meaningful participation from Indigenous and local communities;
• The commitment and resilience of our people;
• Collaboration and achieving success together.

In keeping with Trans Mountain’s commitment to maximize benefits for communities, priority will be given to qualified candidates from Indigenous, local and regional communities along the Trans Mountain pipeline corridor.

In Alberta, the pipeline system spans the traditional territories of Treaty 6, 7 and 8, and the Métis Nation of Alberta (Zone 4).

In British Columbia, the system crosses the traditional territories of numerous First Nations that are affiliated with the Secwepemc, Dakelh (Carrier), Nlaka'pamux, Syilx/Okanagan, Interior and Coast Salish, Stó:lo, as well as the Métis.

Trans Mountain also operates through 15 First Nation Reserves located within the region spanning the BC interior through Fraser Valley.

Our Commitment to Inclusion, Diversity, Equity and Accessibility (IDEA)

Trans Mountain is committed to fostering inclusion, diversity, equity and accessibility. The diverse viewpoints and cultural knowledge that our employees bring to work enrich our organization’s collective cultural understanding, which is reflected in the work we do every day. We strive to create an environment that is free of barriers to promote full participation in the workplace. Trans Mountain welcomes new team members from traditionally underrepresented groups, including but not limited to women, Indigenous Peoples, members of racialized groups, persons with disabilities and members of the 2SLGBTQI+ community.