Senior HR Reporting Analyst (Contract)

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

Job summary

Trans Mountain is seeking a Senior HR Reporting Analyst (Contract) to support the Compensation team with recurring workforce reporting, position and recruiting analytics, and data integrity activities. The role will maintain workforce, position, compensation, and equity data, and prepare regular and ad hoc reports for HR, leadership, and executives.

You will contribute to projects that improve reporting efficiency, data quality, and decision-making, including Power BI dashboards and system

Qualifications

• Post-secondary education in HR, Business Administration, or related discipline.
• 5+ years progressive experience in HR reporting/analytics.
• Experience with SuccessFactors reporting is preferred.
• Advanced Excel and reporting tools; Power BI/dashboard experience is an asset.

Responsibilities

• Prepare and maintain recurring workforce reports (weekly updates, monthly charts, hires/terminations).
• Maintain data integrity across compensation templates, job structures, and pay equity data with HRIS collaboration.
• Support equity/pay transparency analytics and annual pay equity reporting.
• Provide compensation program support for merit, bonus, LTIP, and workforce planning.
• Respond to data requests and prepare executive presentations with accurate outputs.
• Contribute to reporting/process improvements including Power BI dashboards and automation.

Skills

Power BI

Excel

Data analysis

Attention to detail

Communication

Education

HR/Business Administration degree

Tools

Power BI

Excel

Job description

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:

Total Rewards

Reports to:

Manager, Compensation

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 Senior HR Reporting Analyst (Contract). In this position, you will play a key role in supporting the Compensation team through recurring workforce reporting, position and recruiting analytics, data integrity activities, compliance reporting, and program support. The successful candidate will maintain accurate workforce, position, compensation, and equity-related data; prepare regular and ad hoc reports for HR, leadership, and executive audiences; and contribute to projects that improve reporting efficiency, data quality, and decision-making.

Key Responsibilities

• Prepare and maintain recurring workforce reports, including weekly position and recruiting updates, master position tracking, monthly organizational chart updates, hires/terminations/promotions summaries, turnover reporting and quarterly HR dashboard updates for HRLT and executive audiences.
• Maintain data integrity across compensation templates, job pricing templates, internal job structure data, pay equity spreadsheets, and related compensation files by completing regular updates, audits, reconciliations, and issue resolution in partnership with Compensation and HRIS.
• Support compliance and equity analytics by preparing employment equity reporting, pay transparency analytics, pay equity calculations, equal average analysis, annual pay equity reporting, and ad hoc analysis for internal stakeholders and committees.
• Provide compensation program support for merit, bonus, LTIP, annual budget, permanent and contractor workforce planning, peer review data, presentations, and ad hoc reporting requirements.
• Respond to business requests for employee lists, data extracts, analytics, and executive-level presentation support, ensuring outputs are accurate, timely, appropriately formatted, and aligned to audience needs.
• Contribute to reporting and process improvement projects, including Power BI dashboards, automated position request forms, and system modernization initiatives that improve access to workforce data and reduce manual reporting.

Qualifications And Professional Experience

• Post-secondary education in Human Resources, Business Administration, or a related discipline.
• Minimum of 5 years of progressive experience.
• Experience in Success Factors reporting.
• Advanced proficiency with Excel and reporting tools; experience with Power BI or dashboard development is an asset.
• Strong analytical skills with the ability to interpret workforce, compensation, equity, and position data.
• Strong commitment to data accuracy, confidentiality, and audit readiness.
• Experience in Success Factors reporting would be considered an asset.
• Advanced proficiency with Excel and reporting tools; experience with Power BI or dashboard development is an asset.
• Ability to prepare clear, concise reporting and presentations for HR, leadership, and executive audiences.
• Strong collaboration skills with the ability to partner across HR, HRIS, Finance, Communications, and business teams.
• Working knowledge of compensation processes, job evaluation, job pricing, workforce planning, and pay equity or employment equity reporting.
• A track record of delivering high‑quality work, including ad hoc requests, managing competing priorities, and supporting key business processes or operational functions.
• Analytical thinker with strong problem-solving abilities and sound decision-making with exceptional attention to detail and accuracy.
• Maintains confidentiality, calm under pressure and demonstrates a high level of professionalism.
• Effective communication skills, including the ability to convey information clearly, respectfully, and professionally.
• Commitment to inclusive practices and a willingness to contribute positively to a collaborative and supportive workplace culture.

Working Conditions

• May need to provide support outside of regular business hours and/or on the weekend.

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.

A Rewarding Opportunity

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.