Junior Pipeline Integrity Data Analyst (term role)

Date: Jun 23, 2022

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.


As a Junior Pipeline Integrity Data Analyst with Trans Mountain, you’ll have the opportunity to develop your skillset alongside a progressive and fast-paced group of experts in the Pipeline Integrity department. This position is based in our Calgary Head office with the opportunity to work from home under a hybrid model. This is a one-year contract role with a possibility for renewal.  


The Pipeline Integrity Junior Data Analyst will aid the Pipeline Integrity data team in data capture, processing, and management of datasets. The candidate will assist in quality control assessments of GIS pipe integrity data, specifically, risk datasets and apply fixes where applicable. The candidate is expected to complete tasks with a focus on the highest standards of health, safety, and integrity. Liaison and collaboration with various technicians, field operations, and engineers demand a positive attitude and strong communication skills from prospective candidates.


Key Responsibilities

  • GIS data capture and digitization.
  • Provide support for internal and inter department data requests.
  • Create and maintain data documentation and metadata.
  • Manage GIS web content via ArcGIS Online (Portal).
  • Aid in GIS database maintenance including schema changes and data updates.
  • Aid in the development of data process workflows (FME).
  • Aid in the management of Linear Referenced datasets.


Qualifications and Professional Experience

  • College Diploma or University Degree completed (or requiring practicum hours to graduate) in GIS, Computer Sciences, or other related fields.
  • Two years of experience in a related position would be preferred.
  • Experience working with ArcGIS Pro is a requirement.
  • Knowledge of essential GIS best practices and data management.
  • Knowledge of data acquisition from digital imagery.
  • Knowledge of Extract, Transform, Load (ETL) data principles.
  • Basic Python and SQL knowledge for process automation.
  • Experience working with Enterprise level GIS software (Portal, ArcGIS Online and SDE) would be an asset.
  • Experience working with ETL software such as FME would be an asset.
  • Knowledge of linear referencing and or pipeline data models (UPDM/PODS) would be considered an asset.
  • Demonstrated ability to be successful in an agile environment
  • Strong attention to detail
  • Excellent oral and written interpersonal 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:

  • A place to share a sense of purpose and build relationships.
  • Meaningful work that makes a difference.
  • An opportunity within the Canadian energy industry.


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 Diversity and Inclusion

Trans Mountain is committed to supporting diversity and individual differences.  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.  Trans Mountain welcomes new team members from traditionally underrepresented groups, including women, Indigenous Peoples, members of visible minorities and persons with disabilities.