Senior Data Engineer

Dynamics ATS
Snowflake, AZ

Senior Data Engineer 

 

JOB-10045767

 

Anticipated Start Date

2/2/2026

 

Location

Houston, TX

 

Type of Employment

Contract-to-Hire

 

Employer Info

Our client is an American natural gas and crude oil pipeline company with headquarters in Houston, Texas.

 

Job Summary

W e are seeking a Senior Data Engineer to design, build, and optimize large-scale, high-reliability data pipelines and lakehouse architectures. The ideal candidate combines deep data engineering expertise with strong software engineering fundamentals to deliver modular, scalable, and testable data systems. This role involves leading core architectural decisions and defining end-to-end patterns across ingestion, transformation, data modeling, and delivery, including partitioning strategies and partition key design for high-performance analytics.

Job Description

  • Design, build, and maintain ELT pipelines across ingestion, transformation, modeling, and delivery layers
  • Implement incremental loads, change-data-capture (CDC), merge/upsert, and idempotent pipeline patterns to ensure reliability and repeatability.
  • Define and apply data architectural patterns (e.g., layered lakehouse, domain-oriented datasets, and semantic models) aligned to business objectives.
  • Engineer physical data designs including partitioning strategies, partition key selection, clustering/micro-partitioning, and compaction for performance and cost efficiency.
  • Develop curated datasets and data marts that enable analytics and self-service BI.
  • Implement data quality, observability, and lineage (validations, profiling, SLAs, monitoring, and alerting).
  • Optimize performance on cloud data platforms (e.g., Snowflake tasks/streams, compute sizing, query optimization).
  • Design and manage Lakehouse table formats (e.g., Apache Iceberg or Delta) on object storage including schema evolution and maintenance.
  • Collaborate with Data Architects, Analytics Engineering, and business stakeholders to translate requirements into scalable data solutions.
  • Mentor junior engineers, lead design reviews, and contribute to engineering standards and reusable frameworks.
  • Automate and optimize the data lifecycle using CI/CD and infrastructure-as-code; apply DevOps principles to data pipelines.

 

Skills Required

  • 7–10+ years of experience in Data Engineering or closely related Software Engineering roles with a data focus.
  • Expert-level SQL development and data analysis skills, including advanced query optimization and debugging.
  • Strong Python engineering skills and familiarity with software design principles and patterns (e.g., SOLID), unit testing, refactoring, and version control.
  • Hands-on experience building ELT/ETL pipelines and orchestration with tools such as Astronomer/Airflow; proficiency with Git and CI/CD.
  • Deep understanding of core data engineering patterns: ingestion, transformation, modeling (dimensional/SCDs), and delivery.
  • Proven experience with database physical design including partitioning and effective partition key selection; exposure to clustering and micro-partitioning on MPP/cloud data platforms.
  • Experience implementing data quality frameworks, observability/monitoring, and robust operational SLAs.
  • Experience with Lakehouse table formats (Apache Iceberg/Delta/Hudi) and columnar storage (Parquet) on object storage (e.g., AWS S3).
  • Strong communication skills with the ability to present complex technical concepts to both technical and business stakeholders.
  • Experience optimizing Snowflake workloads (compute sizing, tasks/streams, clustering, micro-partitioning).
  • Experience with dbt, Data Build Tool, or similar for transformation and testing.
  • Experience with event streaming (Kafka/Kinesis/Flink) and API-based data integration.
  • Experience with data catalog, governance, and lineage platforms.
  • Domain experience in Oil & Gas midstream operations or industrial IoT/time-series data.
  • Core Competencies
    • Architectural thinking and systems design.
    • Structured problem-solving and analytical rigor.
    • Clear written and verbal communication; stakeholder engagement.
    • Bias for automation, reliability, and maintainability.
  • Tools & Technologies
    • Databases & Warehouses: Snowflake, MPP databases; dimensional modeling/SCDs.
    • Lakehouse & Storage: Apache Iceberg/Delta/Hudi, Parquet, AWS S3/Object Storage.
    • Orchestration & CI/CD: Astronomer/Airflow, git, CI/CD pipelines.
    • Programming: Python, SQL.
    • Observability & Quality: data validation frameworks, monitoring/alerting tools.

 

Education/Training/Certifications

  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field; advanced degree a plus.

GAS Global Services LLC is an Equal Opportunity Employer. Employment Decision are made without regard to race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity or any other factors protected by applicable federal, state or local laws.

Posted 2026-01-21

Recommended Jobs

Physical Therapist - Mobile Home Visits

Bonsai Rehab
Phoenix, AZ

We are now hiring a PRN Physical Therapist to provide home visits in the Central Phoenix, AZ area. The ideal candidate has some prior experience within the outpatient setting and 1 year of experience…

View Details
Posted 2025-12-30

Class A Side Dump Driver ,Nights Job

Oothoudt Brothers Trucking
New River, AZ

Class A Side Dump Driver ,Nights Job Side dump driver , Nights, Federal highway job, in New River ,Az Pay: $26 -$28 hr depending on experience Possible Per diem , How to apply for this Driving Job…

View Details
Posted 2026-01-28

INSURANCE AGENT TRAINEE

Farmers Insurance - Scottsdale
Scottsdale, AZ

We are looking for individuals that are looking to enter the financial lucrative world of insurance! Our producer program allows you to work and be mentored by one of our districts most successful ag…

View Details
Posted 2025-11-14

Recycle Center Truck Operator - Day Shift - Casa Grande, AZ

Abbott
Casa Grande, AZ

Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and …

View Details
Posted 2026-01-09

Air Interdiction Agent

US Customs and Border Protection
Green Valley, AZ

U.S. Customs and Border Protection (CBP) is seeking an experienced Air Interdiction Agent to enhance our law enforcement initiatives. As an integral part of the Department of Homeland Security, the ro…

View Details
Posted 2026-02-03

Assistant Store Manager

Sephora
Scottsdale, AZ

Sephora is seeking an Assistant Store Manager in Scottsdale, AZ to support store operations, lead and develop teams, and enhance client experiences. The role requires strong leadership skills, retail …

View Details
Posted 2025-12-15

TeleSales Representative

Joseph and Young
Chandler, AZ

Propel Your Career to New Heights with Us! Ready for an extraordinary career opportunity? Our rapidly growing company is featured in Forbes and has been on the Inc. 5000 list for six years. With nu…

View Details
Posted 2025-12-17

Bilingual Speech-Language Pathology Assistant

Therapy Tree
Phoenix, AZ

Company Overview Therapy Tree is currently accepting applications for a Speech Language Pathologist Assistant (SLPA)! Join a team of highly qualified and passionate therapists that seek to make a …

View Details
Posted 2026-01-28

Future Openings

Pool Troopers
Phoenix, AZ

Are you interested in joining Pool Troopers but don't see a current opening that aligns with your experience? Apply to our Future Openings-Talent Pool. When a suitable opportunity matching your ba…

View Details
Posted 2025-12-18

Business Process Analyst

Phoenix, AZ

A leading organization within the financial services and insurance industry is seeking a Business Process Services – Senior Analyst to join a growing transformation and process excellence team. This i…

View Details
Posted 2026-01-28