Senior Data Engineer

Date: Feb 1, 2023

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.


As a Senior Data Engineer with Trans Mountain, you’ll have the opportunity to work with a progressive and fast-paced group of Experts in the Information Systems & Technology department. This position can be based in our Calgary or Burnaby Office working a hybrid schedule per week.

The Senior Data Engineer is responsible for governing, securing, and modelling data by analyzing, developing, implementing, and maintaining business intelligence and integration functionality, including translating business rules and requirements into data objects, and producing data models to ensure business units can operate effectively.


Key Responsibilities

  • Works collaboratively with the business to understand business requirements and determine, develop and implement data models to meet business requirements.
  • Business analysis planning, business requirements specification, business case development, functional and non-functional specification.
  • Provides support for the continuing operations of applications systems, including troubleshooting and resolving system issues, and managing the impact of infrastructure and system-related upgrades.
  • Understands the functions of business processes (ie. financial processes) to develop effective data models.
  • Effectively communicates with business partners and the IT team.
  • Running scrums, request status reporting, partner with business to deliver successful business process.
  • Ensures appropriate documentation for all development and modification and ensure integrity and security of institutional data, data governance, practice development and best practice implementations.
  • Understands and uses corporate standards, processes and procedures to ensure alignment with the business and adherence to policies and governance.
  • Clearly documents system solutions, system architecture and business processes to ensure continuity in business support.
  • Understands the company technology infrastructure and works within that infrastructure when deploying information systems.
  • Technical efficiency related to development lifecycle management, business intelligence, data governance, data management and business process management. 
  • Operate within an agile and ITIL (Information Technology Infrastructure Library) framework for project development lifecycle environment.



Qualifications and Professional Experience

  • 10+ years of experience in a relative field
  • Microsoft Certified: Azure Data Engineer Certificate
  • University degree or diploma in Computing Science or an equivalent discipline
  • TDWI’s (Transforming Data With Intelligence), Certified Business Intelligence Professional (CBIP) Certification, CCNP (Cisco Certified Network Professional) Data Center Certification, DAMA (Data Management) and/or Certified Data Management Professional Certification would be an asset
  • Experience working in erwin Data Modeler
  • Experience working in Sparx Systems Enterprise Architect
  • Experience with Collibra Data Governance.
  • Experience with Microsoft Purview.
  • Experience with Microsoft Azure Data Products/Services
  • Knowledge of business functions, processes and business terminology.
  • Strong understanding of integration and business intelligence capabilities.
  • Strong understanding of data governance.
  • Business analysis experience; understanding the business domain, drawing out requirements, communicating, managing expectations and documentation.



  • Hybrid working schedule; part time in the office, part time at home per week
  • This position requires someone to be located in or around Calgary, AB or Burnaby, BC

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 experience people in the business;
  • Competitive compensation;
  • Comprehensive benefits programs including flexible benefits, pension and savings plans
  • 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 heath, 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 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.