Data Engineer

Trans Mountain Corporation operates Canadas only pipeline system transporting oil products to the West Coast. We deliver approximately 890000 barrels of petroleum products each day through a dual pipeline system of more than 1150 kilometres of pipeline in Alberta British Columbia and Washington state.

Trans Mountain also operates a state-of-the-art loading facility Westridge Marine Terminal with three berths providing tidewater access to global markets.

As a federal Crown corporation Trans Mountain continues to build on more than 70 years of experience delivering operational and safety excellence through our crude oil pipeline system.

With our expanded pipeline system now in place Trans Mountain provides enhanced direct access for Canadian crude oil to world markets. The expansion realizes a world-class system for oil transport developed to Canadas high standards within one of the most stringent regulatory regimes in the world creating long-term economic benefits enhanced marine protection enhanced safety and emergency management capabilities and enhanced skilled-worker capacity building in communities and Indigenous groups.

Our Core Values

Trans Mountains core values Safety Integrity Respect and Excellence guide our every step. Each obstacle weve overcome or success weve experienced has been the result of a shared commitment to living these values every day. Together were 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: IT Enablement & Innovation

Reports to: Manager Enterprise Architecture

Worker Type: Employee

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 Data Engineer. In this position you will play a key role in supporting the development and maintenance of data pipelines and data systems that help the business use information effectively while ensuring data is accurate available and secure. This position offers the opportunity to support the delivery of reliable data for operational financial and regulatory reporting.

Key Responsibilities

• Lead the building and maintaining of data pipelines that move transform and deliver data between systems in the correct format for reporting and analysis.
• Learn and apply best practices for data integration processing and pipeline development.
• Monitor data jobs and pipelines to ensure they run as expected and escalate failures delays or incorrect data outputs as needed.
• Support basic troubleshooting and issue resolution with guidance from more experienced team members.
• Work with analysts and business users to provide clean usable data for reports dashboards and business decision-making.
• Prepare datasets and complete simple data transformations as required.
• Adhere to company standards for data access privacy and security to ensure sensitive data is handled appropriately and shared only with authorized users.
• Support compliance with internal policies and regulatory requirements related to data management.
• Work closely with IT staff including developers and analysts by asking questions sharing updates and contributing to team discussions and projects.
• Build an understanding of company systems data processes and team practices.
• Create and update basic documentation for data pipelines processes workflows changes and technical steps in alignment with team standards.
• Help ensure knowledge is documented and shared across the team.
• Continuously build skills in data engineering tools coding and data platforms through training mentoring and hands-on project work.
• Take initiative to improve technical knowledge and contribute more independently over time.
• Perform data validation and basic quality checks to ensure accuracy consistency reliability and integrity.
• Identify data issues and report findings to managers or system owners.

Qualifications and Professional Experience

• Post-secondary education in Computer Science Information Technology or related discipline.
• Microsoft Certified: Azure Data Engineer certification is an asset.
• A minimum of 1 year of progressive experience.
• Preferred certifications include CBIP Microsoft Azure Data Fundamentals or Azure Data Engineer Associate and AWS Cloud Practitioner.
• Experience working in an Agile SCRUM team and with data engineering tools such as Spark Azure Data Factory Fabric Databricks Snowflake and Microsoft Purview.
• Knowledge of business functions processes and business terminology.
• Strong understanding of integration business intelligence and data governance concepts.
• Business analysis experience; understanding the business domain drawing out requirements communicating managing expectations and documentation.
• Basic knowledge of SQL and working with data in databases.
• Familiarity with data pipelines ETL/ELT concepts or data processing tools.
• Understanding of basic programming concepts (e.g. Python or similar language).
• A track record of delivering highquality work managing competing priorities and supporting key business processes or operational functions.
• Demonstrated ability to work effectively with colleagues and stakeholders from a variety of backgrounds and levels across the organization.
• Effective communication skills including the ability to convey information clearly respectfully and professionally.
• Proven organizational skills with the ability to manage priorities meet deadlines and maintain attention to detail in a fastpaced environment.
• 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.

Application

Candidates may submit their application in English or French. To apply in French please use our French careers site: Careers (French)

At Trans Mountain we believe in an inclusive accessible and barrier free recruitment and selection process for all applicants. If you require an accommodation at any point in the process please contact us at: or the designated Talent Acquisition Advisor. Accommodation requests will not affect the assessment of your application or candidacy or the designated Talent Acquisition Advisor. Accommodation requests will not affect the assessment of your application or candidacy.

We Build Careers and Pipelines That Last

Our story is about determination resourcefulness and resilience. Its 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 its 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;
• 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 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 Mountains 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) Nlakapamux 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 organizations 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.