Sr. Data Engineer - DBT / Snowflake / Python / Airflow - Multilple Locations Job at Cliff Services Inc, Oklahoma

czVLVk9HMGxkMTR2WDlFTnJvc3UvNFpYK3c9PQ==
  • Cliff Services Inc
  • Oklahoma

Job Description

Sr. Data Engineer DBT / Snowflake / Python / Airflow

Number of positions: Multiple

Location: Multiple Locations Across the USA Interview:

Video Work Type: Hybrid

ABOUT THE ROLE

We are seeking an experienced Senior Data Engineer with strong hands-on expertise in DBT and Snowflake to join a high-impact data engineering team. The ideal candidate will have a proven track record of building and managing scalable data pipelines, transforming large datasets, and enabling reliable data delivery across the enterprise. This role sits at the intersection of data infrastructure, analytics engineering, and pipeline automation.

KEY RESPONSIBILITIES

  • Design, develop, and maintain scalable data transformation pipelines using DBT (hands-on, production-level experience required)
  • Build and optimize data models, marts, and transformation logic within Snowflake
  • Develop and manage end-to-end data pipelines using Apache Airflow for orchestration and scheduling
  • Write clean, efficient, and reusable Python scripts for data ingestion, transformation, and automation tasks
  • Implement DBT best practices including modular model design, testing frameworks, documentation, and version control
  • Define and enforce data quality checks, testing, and monitoring within DBT pipelines
  • Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse sizing strategies
  • Collaborate with data analysts, data architects, and business stakeholders to understand data requirements and translate them into scalable engineering solutions
  • Manage and maintain DAGs in Airflow for pipeline scheduling, dependency management, and failure alerting
  • Support migration or integration efforts involving legacy systems such as Oracle databases and IBM DataStage pipelines
  • Participate in data architecture discussions and contribute to the evolution of the enterprise data platform
  • Document pipelines, data flows, transformation logic, and operational runbooks
  • Perform root cause analysis on data quality issues and pipeline failures and drive timely resolution
  • Contribute to CI/CD practices for data pipeline deployment using Git-based version control workflows

REQUIRED QUALIFICATIONS (Primary Skills)

  • 5+ years of overall experience in Data Engineering or related field
  • Hands-on production experience with DBT (dbt Core or dbt Cloud) this is a strict requirement; theoretical or tutorial-level exposure will not be considered
  • Proficiency in building and managing DBT models, tests, macros, seeds, snapshots, and documentation
  • Strong hands-on experience with Snowflake including data modeling, query optimization, role-based access control, and virtual warehouse management
  • Solid Python programming skills for data pipeline development, scripting, and automation
  • Hands-on experience building and managing workflows in Apache Airflow including DAG development, task dependencies, and error handling
  • Strong understanding of dimensional modeling, data vault, or similar data warehousing methodologies
  • Experience with Git and CI/CD practices for pipeline version control and deployment
  • Strong analytical and problem-solving skills with the ability to work across complex data environments

PREFERRED QUALIFICATIONS (Secondary Skills)

  • Experience working with Oracle databases including SQL querying, schema understanding, and data extraction
  • Hands-on or working knowledge of IBM DataStage for ETL pipeline development and migration
  • Familiarity with cloud platforms: AWS, Azure, or GCP
  • Experience with data lakehouse architectures or modern data stack tooling
  • Knowledge of data governance, lineage tracking, and metadata management
  • Exposure to tools such as Great Expectations, Monte Carlo, or similar data observability platforms
  • Experience in financial services, healthcare, or other regulated industry data environments

GOOD TO HAVE

  • Snowflake SnowPro certification
  • DBT certification (Analytics Engineering)
  • Familiarity with Spark, Kafka, or streaming data pipelines
  • Experience with Looker, Tableau, or Power BI for downstream analytics support

WORK ARRANGEMENT

This position is Hybrid with on-site presence expected on a regular basis. Fully remote work arrangement will be considered for candidates with exceptional experience and a demonstrated track record of delivering results in distributed team environments. All interviews will be conducted via video.

Job Tags

Remote work

Similar Jobs

Brookfield Global Recruitment Services

Project Manager - Physical Security System Installations Job at Brookfield Global Recruitment Services

Industry leader are looking to hire Project Managers (Mid - Senior level) to manage physical security system installations. Key responsibilities will include:Manage enterprise security installation projects. .Confer with senior management, supervisory personnel, owners... 

24 Seven Talent

Social Media Manager Job at 24 Seven Talent

 ...consumer lifestyle and design space is seeking a a Social Media Manager to lead content creation and execution. This is a Los Angeles...  ...production, and publishing, with additional responsibility for community engagement, performance tracking, and platform optimization. We... 

Budget Rent A Car

Car Detailer/Washer Job at Budget Rent A Car

 ...Budget has openings for a Car Detailer for our airport team. The position will be responsible for cleaning and washing rental vehicles. Duties include vacuuming, wiping down, sanitizing, pulling out trash, and fueling. Applicants should have a valid driver's license and... 

Ema Unlimited

Social Media & Community Manager Job at Ema Unlimited

 ...Social Media & Community Manager Location: US Remote Experience: 5+ relevant years About Ema Ema is redefining enterprise automation with a new category: Agentic Business Transformation. Our AI employees dont just assistthey reason, collaborate, and drive... 

Marcus Corp

Marketing Studio Relations Intern, Part Time Job at Marcus Corp

 ...Marketing Studio Relations Intern Marcus Theatres is seeking a dynamic, part time Marketing Studio Relations Intern eager to dive into the fast-paced world of business and...  ...with multiple departments, including Sales, Food & Beverage, Operations, and Film, to help coordinate...