ETL Architect
Trident Staff
ETL Architect – Oil & Gas / Energy (Onsite – Calgary, AB)
We are seeking a highly experienced ETL Architect with mandatory Oil & Gas, Energy, or Utilities domain experienc e to lead enterprise data integration initiatives.
This is a 100% onsite role in Calgary, Alberta (5 days/wee k). The ideal candidate will bring deep expertise in designing scalable ETL/ELT architectures within complex industrial environments, including upstream, midstream, downstream, or energy trading systems.
- Location: Calgary,AB
- Work Model : Onsite – 5 days/week (mandator y)
- Contract duration: 2 years
Mandatory Requirement (Non-Negotiable)
- Proven experience working in Oil & Gas, Energy, or Utilities indus try
- Hands-on involvement with: Production, drilling, reservoir, or pipeline data SCADA, IoT, or operational systems
- Energy trading, asset management, or regulatory reporting
Candidat es without domain experience will not be considered
Key Responsibilities
- Design and implement enterprise ETL/ELT architecture for large-scale energy data platforms
- Integrate data from operational systems (SCADA, sensors, field systems) and enterprise systems (ERP, finance, trading)
- Build scalable pipelines for high-volume, time-series, and real-time data
- Define data models aligned with Oil & Gas business processes (upstream/downstream)
- Establish ETL standards, governance, and data quality frameworks
- Optimize performance for large datasets (production, drilling, telemetry data)
- Collaborate with business stakeholders, engineers, and data teams
- Lead architecture reviews and provide technical mentorship
Required Qualifications
- 10+ years in ETL / Data Engineering
- 5+ years in architecture or technical leadership roles
- Strong experience with ETL tools:Informatica, Talend, SSIS, AWS Glue, Matillion, or dbt
- Advanced SQL and data modeling (dimensional /3NF)
- Experience with cloud platforms:AWS, Azure, or GCPHands-on experiencewith:Snowflake, Redshift, Synapse, or Big Query
- Strong understanding of:Data warehousing ,Data governance and lineage
- Experience handling large-scale industrial / operational datasets
Domain-Specific Experience (Required)
- Oil & Gas systems such as:Production data (well, drilling, completions)Pipeline and transportation systemsAsset and maintenance systems
- Familiarity with:SCADA systems and time-series dataIndustry data standards (e.g., PPDM – preferred)
- Understanding of regulatory and reporting requirements in energy sector
Nice to Have
- Experienc e with real-time streaming (Kafka, Spark Str eaming)
- Expos ure to data platforms in energy trading envir onments
- Cloud certifications (AWS, Azure, Snowflake)
- Experience in large enterprise or consulting environments
Vacancy posted 4 hours ago
Similar jobs that could be interesting for youBased on the ETL Architect in Alberta vacancy
$90k - $120k per year
...A boutique architectural practice specializing in residential, hospitality and commercial projects is looking for a Project Architect to join their team. They take great pride in their work and are focused on an approach that is long-lasting, sustainable, and most importantly...SuggestedContract workFor contractorsFlexible hours- ...Scope: The SAP SCM Solution Architect is the strategic leader responsible for designing and governing the organization’s end-to-end digital supply chain, procurement, and finance ecosystem. This role ensures that processes across Plan–Source–Make–Deliver–Return , as well...SuggestedLong term contractContract work
- ...experience with modern cloud data warehousing, particularly Snowflake, alongside practical knowledge of DBT, dimensional modeling, and ELT/ETL best practices. ~ Proven ability to deliver BI solutions using tools like AWS QuickSight, Power BI, or Tableau, and a strong track...SuggestedWork at officeFlexible hours
$125k - $160k per year
...Collaboration & Client Engagement – Participate in client meetings, project interviews, and team discussions. Work closely with engineers, architects, and owners to refine cost estimates and recommendation s.Training & Development – Mentor junior staff, assist in team training,...SuggestedFor contractorsFor subcontractor- ...translating complex technical issues into actionable solutions. Collaboration: Work closely with project managers, engineers, and architects to resolve complex building envelope challenges efficiently. Qualifications Education: Diploma in Architectural Technologies,...SuggestedLong term contractFor contractorsWork at officeFlexible hours
$80k - $95k per year
...Collaborate closely with clients, contractors, and consultants throughout the project lifecycle Work alongside senior design architects and small, collaborative project teams Contribute to delivering projects on time and within budget Independently execute full...Contract workFor contractorsWork at officeLocal areaFlexible hours- ...Hiring: Microsoft Fabric Architect Location: Edmonton, Alberta, Onsite (5 days per week in office) Duration: August 10, 2026 – August... ...Ingestion & Transformation: Utilizing Pipelines and Dataflows for robust ETL/ELT processes. Storage Strategy: Implementing a Medallion...Hourly payWork at officeImmediate startRemote work
- ...ETL Architect – Oil & Gas / Energy (Onsite – Calgary, AB) We are seeking a highly experienced ETL Architect with mandatory Oil & Gas, Energy, or Utilities domain experience to lead enterprise data integration initiatives. This is a 100% onsite role in Calgary, Alberta...Contract work
$165k - $183k per year
...currently hiring: ~ Ads Measurement & Data: Our cutting-edge data team is responsible for building scalable, reliable, and maintainable ETLs and its underlying architecture and platform. We directly support critical internal and external systems and metrics such as billing,...Remote jobLong term contractPermanent employmentTemporary workWork at officeWork from homeFlexible hours- ...We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation. Job Role: ETL Developer Job Type: Full -Time/Contract Location: Toronto (Onsite) This is an on-site role located in Toronto, requiring...Full timeContract workWork at office
$80k per year
...fundraising strategy aligned with Prospect's mission. As Prospect's only dedicated fundraising professional, you'll serve as both architect and builder, designing systems, growing donor pipelines, and executing daily activities to drive revenue. With a solid foundation in...Long term contractFull timePart timeWork at officeWork from home- ...with KQL, SPL, PowerShell, or Python. ~ Strong understanding of security monitoring best practices. ~ BFSI experience required. Preferred Certifications Splunk Certified Architect Microsoft SC-200 CISSP For more details reach at ****@*****.***...
$128k - $180k per year
...transcend the ordinary and achieve extraordinary results. Data Architect We are seeking an experienced Data Architect to join our team... ...BI / Analysis Services semantic models. • Optimizing existing ETL process and data transformations. • Create technical...- ...Position: Senior Fabric Architect Duration: 12 Months assignment (contract) Client Location: Edmonton, AB ( Remote Role) : 7.25 hours/... ...Ingestion & Transformation: Utilizing Pipelines and Dataflows for robust ETL/ELT processes. Storage Strategy: Implementing a Medallion...Contract workRemote workMonday to friday
- ...and projects across North America and beyond, exciting opportunities are waiting for you in dozens of cities. As a Knowledge Architect for our Edmonton NAHQ office, you will be a trusted steward of corporate knowledge, enabling teams across the organization to access...Work at officeLocal area
- ...to make a lasting impact in the arctic and sub-arctic communities of the Canadian Territories. Reporting To: VP of Design The Architect will lead and oversee all phases of architectural projects, including schematic design, design development, construction documents,...Contract workLocal areaImmediate startRemote work
- ...Overview We are seeking a highly experienced Operational Technology (OT) Architect to lead the design, security, and evolution of OT network environments supporting critical infrastructure operations. This role is responsible for establishing secure, scalable, and resilient...Long term contractFull timeTemporary workRemote work
- ...Senior Microsoft Fabric & Power BI Architect 1 year initial Contract term (with extension options) HYBRID Role We are seeking an elite... ...: Ingestion & Transformation: Build robust, automated ETL/ELT processes utilizing Fabric Pipelines and Dataflows. Storage...Full timeContract work
$110k - $130k per year
...Hays has partnered with an established firm with offices in Calgary, Edmonton and Vancouver who are looking for a Senior Project Architect to join their growing Calgary studio. This award-winning firm are pioneers in the field of sustainability and the power of collaborative...Permanent employmentWork at officeFlexible hours- ...About Role We at Coforge are seeking an experienced SAP Test Architect to lead the testing strategy for our SAP ECC to S/4HANA migration program. The ideal candidate will bring strong hands-on expertise in defining test architecture, managing test sprints, and establishing...
- ...Stantec’s Buildings team is on a mission to become the world’s leading integrated design practice. Our architects, engineers, interior designers, consultants, sustainability specialists, and technologists are passionate about the power of design. Our collaborative culture and...Long term contractFull timeContract workTemporary workPart timeCasual workInternshipWork at office
- ...incident. ~Participate in disaster recovery testing and business continuity planning exercises. ~Collaborate with infrastructure architects and vendors to implement and refine system configurations, ensuring scalability and reliability. Also, support project execution and...Full timeRemote workWorldwideMonday to fridayFlexible hours
- ...Senior OT Specialist / OT Architect Location: Onsite (5 Days/Week) Duration: 12 Months (Possible Extension) Role Overview Seeking an experienced OT Specialist/Architect with strong expertise in PLC, SCADA, DCS, Historian, and PI Systems to assess, modernize...
- ...Job Summary The ServiceNow Solutions Architect is a key member of the ServiceNow Practice, responsible for designing and leading delivery of end-to-end ServiceNow solutions with a primary specialization in IT Asset Management (ITAM), including Software Asset Management...
- ...technology trends and approaches Ideally has experience or understanding of the benefits of low-code platforms While the Solution Architect is not expected to build the solutions experience of multiple development languages & various DB engines will be advantageous...Remote work
- ...services to help other product teams "go faster". It supports alignment across digital services and enables digital at scale. The Digital Architect works full time (7.25-hour day) across approximately four projects. Services and deliverables evolve as work progresses in response...Full timeMonday to friday
$103 - $119 per hour
Our Alberta client is looking for a Network Architect with experience designing modern branch connectivity patterns including local internet egress, planning, and guiding the implementation of a resilient, secure, and scalable network architecture that supports modern infrastructure...Long term contractLocal areaImmediate startRemote work- Are you a skilled data professional looking for your next high-impact contract? Our Edmonton client is seeking a Senior Fabric Architect for an exciting 1-year engagement with potential for extension. This remote-first role allows you to shape a modern data ecosystem from the...Contract workImmediate startRemote workHome officeFlexible hours
$39.86 - $62.29 per hour
...We are seeking an experienced Data Privacy Technical Architect with deep expertise in BigID , data governance, and privacy architecture. In this role, you will lead the design and implementation of scalable data privacy solutions, ensuring compliance with global data protection...- ...combination modern & traditional technology stacks crafted by some of the most amazing people you will ever work with. The Solution Architect has end-to-end responsibility for ensuring the completeness of solution architecture in the Commercial Technology business unit...InternshipFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Architect. Be the first to apply!
