Senior Data Platform Architect

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 Platform Architect 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 is based in our Calgary Office and will be working a hybrid schedule.   

As a Senior Data Platform Architect, your responsibilities may include:

• Designing and implementing data storage solutions: You will need to design and implement storage solutions that meet the organization's data storage needs, ensuring that they are scalable, efficient, and secure.
• Creating and maintaining data pipelines: You will be responsible for building and maintaining data pipelines that move data between different systems, such as databases, data lakes, and data warehouses.
• Building data models: You will create data models that are optimized for efficient querying and analysis. This includes understanding the data and the business requirements, as well as designing tables, views, and other database objects.
• Developing and deploying data integration solutions: You will need to build and deploy data integration solutions that enable data to be transferred between various systems in real-time, ensuring that data is up-to-date and accurate.
• Monitoring and optimizing data performance: You will need to continuously monitor the performance of data solutions, identify, and troubleshoot issues, and optimize data processing and storage to ensure that data is processed and retrieved quickly and efficiently.
• Ensuring data security and compliance: You will be responsible for implementing data security measures and ensuring that data solutions comply with relevant regulations, such as GDPR and CCPA.
• Collaborating with other teams: You will work closely with other teams, such as software engineers, data scientists, and business analysts, to ensure that data solutions meet the needs of the organization and its stakeholders.

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

Must have:

• 2+ year hand-on 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.

Bonus:

• 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 with Profisee Data Governance.
• Experience with Microsoft Purview.

Other:

• The successful candidate will be required in office on a hybrid basis.

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.