Market and Data Analyst (Contract)

Date: Jul 4, 2024

Location: Calgary, Alberta, Canada

Company: Trans Mountain

Trans Mountain operates Canada’s only pipeline system transporting oil products to the West Coast. We deliver approximately 300,000 barrels of petroleum products each day through 1,150 kilometres of pipeline in Alberta and British Columbia, and 111 kilometres of pipeline in Washington state.


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.


This position will be based at the Calgary Head Office location and will report to the Strategic Advisor, Fundamentals & Market Analysis.  This a contract position with a duration of 12-18 months.


Key Responsibilities

Responsibilities for the Market and Data Analyst can be grouped into the categories of: Data Procurement and Management, Model Development and Maintenance, Analytics and Market Monitoring, and Insights Delivery.


Data Procurement and Management:

  • Provide support in identifying and evaluating relevant sources of data/datasets required to support analytics initiatives;
  • Develop and implement the most effective and efficient methods for procuring, manipulating and managing datasets, with an eye to continual improvement;
  • Work collaboratively with internal colleagues to reduce/eliminate redundancies in data procurement and data management; and
  • Datasets could include: pricing data for oil and products, production/refining/demand data, inter and intra-regional commodity flow data, export/import data, storage data, shipping and cargo data, and transportation rates and tariffs.

Model Development and Maintenance:

  • Develop, maintain and continuously improve fit-for -purpose models to support and drive analytics initiatives;
  • Determine optimal model environment (initially) and progress model platforms and capabilities over time based on analytics needs;
  • Establish effective processes for maintaining models including automation of key inputs and outputs where appropriate; and
  • Ensure appropriate model documentation for continuity and contingency purposes.

Analytics and Market Monitoring:

  • Leveraging off of developed in-house models, perform various ad hoc and ongoing analysis to assess and identify key market trends, shifts, anomalies, relationships, market balancing mechanisms and leading indicators to enhance market insights;
  • Pro-actively monitor key market metrics and indicators to understand current market drivers and key watch-outs impacting future state of market;
  • Assist in development and assessment of various fundamental market scenarios that would meaningfully impact key market outcomes; and
  • Ensure analytics outcomes appropriately feed into the insights delivery to ensure key stakeholders are kept appropriately informed.

Insights Delivery:

  • Support and participate in an ongoing needs assessment of key stakeholders to ensure the team’s fundamentals and market analytics efforts and outputs appropriately evolves with the needs of the company;
  • Support the development and delivery of fit-for-purpose mediums to deliver market insights to key stakeholders on a timely basis;
  • Insights delivery could include combinations of recurring market reports and dashboards, presentations and other one-off topical research initiatives.

Qualifications and Professional Experience

  • Bachelor’s Degree in a relevant field of study including Finance, Economics, Statistics, Mathematics or Engineering.
  • One to Five years relevant industry experience.
  • Schooling, training and/or experience in certain data science disciplines would be an asset.
  • Demonstrated understanding of energy markets (crude oil and refined products in particular) would be an important asset.
  • Intermediate to advanced proficiency in Excel based analytics functions and intermediate proficiency in other MS  applications (PowerPoint, Word, Teams).
  • Working knowledge and experience with statistical modeling and relational database platforms also an important asset.
  • Strong desire and drive to understand the structural setup and functioning of energy markets (the “why” and not just the “what”)
  • Proven data management, model development and analytical capabilities.
  • Ability to work both independently and within a team environment.
  • Self-starter and strong ability to prioritize workflow.
  • Strong analytical mindset and problem-solving skills.
  • Strong oral, written, interpersonal and communication skills.

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 existing, and expansion, pipeline corridor.


In Alberta, the existing 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.