Senior Data Engineer - Snowflake/Azure Data Factory

Novus Consulting

Oklahoma City (OK)

Hybrid

USD 120,000 - 150,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Healthcare benefits
401K matching program
Discretionary bonus (semi-annual)
Hybrid/remote work options

Job summary

Novus Consulting, an energy-focused firm based in Oklahoma City, seeks a Senior Data Engineer/Data Warehouse Engineer to design and evolve a Snowflake-based data warehouse. The role involves building pipelines, managing data ingestion with Azure Data Factory, and deploying through Azure DevOps using Snowflake CLI and DCM.

You will translate oil & gas operations needs into scalable data solutions, collaborate with stakeholders, and travel to client sites as needed.

Qualifications

  • Bachelor's degree in Information Technology, Computer Science, or related field.
  • 5+ years of experience in data engineering or data warehouse development.
  • Hands-on experience with ETL tools and frameworks.
  • Experience with Azure Data Factory, including CI/CD for data pipelines.
  • Experience with Azure DevOps for source control, build, and release pipelines.
  • Working knowledge of Azure storage and networking fundamentals.
  • Experience with Snowflake CLI and DCM is preferred.
  • Practical understanding of data modeling concepts.
  • Ability to optimize queries and workflows for performance and scalability.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Familiarity with upstream data is required; experience with Quorum or PackAccounting is a plus.
  • Excellent communication skills, with the ability to articulate complex technical concepts to non-technical stakeholders.
  • Experience working on multiple projects while meeting deadlines.
  • Ability to travel to client sites on an as-needed basis.

Responsibilities

  • Design, build, and maintain Snowflake data pipelines and data warehouse models.
  • Implement and manage tasks and streams for automated and incremental data processing.
  • Design and maintain role-based access control and security models within Snowflake.
  • Monitor and tune warehouse usage, query performance, and compute costs.
  • Build and maintain data ingestion pipelines using Azure Data Factory.
  • Integrate data from multiple source systems, including oil and gas operational and accounting systems.
  • Work with Azure storage and networking components to support secure and reliable data movement.
  • Manage source control and CI/CD pipelines in Azure DevOps for Snowflake and Azure Data Factory assets.
  • Automate Snowflake deployments using Snowflake CLI and DCM.
  • Establish and follow best practices for code quality, testing, and release management.
  • Partner with client stakeholders to translate business requirements into data models and solutions.
  • Provide technical guidance on data warehouse design, development standards, and best practices.
  • Document data flows, models, and processes to support ongoing operations and knowledge transfer.

Skills

Data warehousing
ETL development
SQL optimization
Stakeholder communication
Analytical thinking

Education

Bachelor's degree in Information Technology/Computer Science

Tools

Azure Data Factory
Azure DevOps
Snowflake CLI
DCM
Azure Storage

Job description

Novus Consulting, an energy-focused firm based in Oklahoma City, seeks a Senior Data Engineer/Data Warehouse Engineer to design and evolve a Snowflake-based data warehouse. The role involves building pipelines, managing data ingestion with Azure Data Factory, and deploying through Azure DevOps using Snowflake CLI and DCM.

You will translate oil & gas operations needs into scalable data solutions, collaborate with stakeholders, and travel to client sites as needed.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer/Data Warehouse Engineer
Senior Data Engineer/Data Warehouse Engineer

Novus Consulting • Oklahoma City (OK)

Hybrid
USD 120,000 - 150,000
Healthcare benefits
401K matching program
Discretionary bonus (semi-annual)
+1
Senior Data Engineer - Snowflake & Azure Expert
Senior Data Engineer - Snowflake & Azure Expert

Quantum Technologies LLC • Irving (TX)

On-site
USD 73,000 - 104,000
Senior Snowflake Data Engineer – Azure Data Factory
Senior Snowflake Data Engineer – Azure Data Factory

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000
Senior Data Engineer — Remote (Snowflake, dbt, Azure)
Senior Data Engineer — Remote (Snowflake, dbt, Azure)

Sedgwick • Phoenix (AZ)

Remote
USD 140,000 - 190,000
Senior Snowflake & Data Pipeline Architect — Remote
Senior Snowflake & Data Pipeline Architect — Remote

Experis-US • New Providence (NJ)

Remote
USD 96,000 - 103,000
Snowflake Data Engineer — Cloud ETL & Data Pipelines
Snowflake Data Engineer — Cloud ETL & Data Pipelines

LaneHelp • Eugene (OR)

On-site
USD 80,000 - 115,000
Competitive pay
Medical/Dental/Vision plans
Paid holidays & PTO
+7
Senior Data Platform Engineer: Snowflake & Azure (Remote)
Senior Data Platform Engineer: Snowflake & Azure (Remote)

WorkTrust Solutions • United States

Remote
USD 140,000 - 190,000
Senior Data Engineer - Snowflake & Data Quality (Remote)
Senior Data Engineer - Snowflake & Data Quality (Remote)

Nearshore Business Solutions • United States

Remote
USD 140,000 - 200,000
Snowflake Engineer
Snowflake Engineer

Experis-US • New Providence (NJ)

Remote
USD 96,000 - 103,000
Data Engineer: Snowflake, Azure & ELT Expert
Data Engineer: Snowflake, Azure & ELT Expert

Fuse3 Solutions • Edmond (OK)

On-site
USD 110,000 - 134,000
Comprehensive benefits package
Professional development & training
Collaborative culture & data-driven决策