Project Controls Reporting Analyst, Pacific Link (Contract)

Role overview

Responsibilities

• Prepare recurring and ad hoc financial, performance, and management reports, including variance analysis, forecasts, reconciliations, and executive reporting.
• Analyze project performance data, identify trends and emerging issues, and provide leadership with insights.
• Develop and maintain 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 activities with documentation, information responses, and traceable reporting records.
• Coordinate reporting requirements with Project Controls, Finance, and business stakeholders; resolve discrepancies and improve processes and data governance.
• Identify reporting automation and continuous-improvement opportunities.

Qualifications and experience

• Post-secondary education in Accounting, Finance, Economics, Business Administration, Data Analytics, or a related discipline.
• 6 to 9 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, construction, or related sectors is preferred.
• Experience preparing financial and performance reports, dashboards, reconciliations, variance analysis, and management reporting packages.
• Advanced proficiency with Microsoft Excel, Power BI, Power Query, and other reporting and data visualization tools.
• Experience with enterprise reporting systems, reporting databases, and data management platforms; Microsoft Power Platform familiarity is an asset.
• Understanding of reporting controls, data governance, data quality, and internal controls; IFRS or U.S. GAAP knowledge is an asset.
• Audit, assurance, governance-reporting, and documentation experience is preferred.
• Ability to integrate data from multiple sources, manage competing priorities, meet deadlines, and maintain accuracy.
• Effective communication, organization, and collaboration with colleagues and stakeholders across the organization.

Working conditions

• Support outside regular business hours may be required during period-end, audit, or critical reporting cycles.

Opportunity

• The employer describes professional development and career advancement opportunities, learning from experienced colleagues, competitive compensation, and meaningful work in the Canadian energy industry.

About Trans Mountain