Senior Data Engineer/Data Warehouse Engineer

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

Senior Data Engineer/Data Warehouse Engineer
About Novus

Founded in 2020, Novus Consulting is a high caliber energy consulting firm established on the principle that our clients need a trusted partner who can navigate the complexities of the energy sector while providing solutions that drive results. Headquartered in Oklahoma City, with consultants sitting in Oklahoma, Texas, Colorado, Arkansas and Pennsylvania, we advise a range of clients from independent E&Ps to Fortune500s. Focused on serving both our clients and our employees, we pride ourselves on providing our clients with top-tier service while offering our employees the flexibility required to excel both personally and professionally. Committed to continued excellence, we are actively seeking a highly skilled Senior Data Engineer/Data Warehouse Engineer with upstream oil and gas industry experienceto join our growing team. This position will be hybrid with some travel to client sites.

Grow with Novus

As a Senior Data Engineer / Data Warehouse Engineer, you will design, build, and evolve an enterprise data warehouse on Snowflake. You will own Snowflake pipelines and data models, manage data ingestion through Azure Data Factory, and deliver automated deployments through Azure DevOps using Snowflake CLI and DCM. Deep, Hands-on Snowflake expertise is the foundation of this role, and you will be the go-to resource for building secure, performant, and cost-efficient solutions on the platform. Understanding the unique operations workflows of exploration, drilling, production, and other functional areas in the oil and gas industry - you can translate those needs into scalable digital solutions. If this sounds like you - let’s talk!

Key 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
Qualifications
  • Bachelor’s degree in Information Technology, Computer Science, or relevant work experience
  • 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
  • Solid understanding of data architecture principles, version control, and environment management (DEV/TEST/PROD)
  • 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 multiple projects (splitting time) while meeting deadlines
  • Ability to travel to client sites on an as-needed basis
What We Provide (W2 Employees)
  • Collaborate with a team of smart, driven professionals
  • Excellent benefits including healthcare and a 401K matching program
  • Semi-annual discretionary bonus
  • Continuous commitment to employee satisfaction provides our team with the flexibility needed to thrive professionally and personally including options for hybrid/remote work and a progressive PTO policy

Novus Consulting LLC is committed to providing a work environment free from discrimination and harassment. It is our policy to comply with all applicable federal, state, and local laws prohibiting employment discrimination. All employment decisions are based on business needs, job requirements, and individual qualifications without regard for race, color, religion, sex, sexual orientation (including gender identity and/or expression), pregnancy, national origin, age, disability, veteran status or any other factors protected by the laws or regulations in the states where we operate. We are committed to supporting a variety of recruiting initiatives to continue building a diverse and inclusive organization.

We bring deep functional expertise to solve the energy sector's most critical issues: acquisitions, digital transformation, and sustainability.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - Snowflake/Azure Data Factory
Senior Data Engineer - Snowflake/Azure Data Factory

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)
Senior Data Engineer (Snowflake)

Continuum Solutions • Houston (TX)

On-site
USD 120,000 - 150,000
Senior Data Engineer (Snowflake)
Senior Data Engineer (Snowflake)

Continuum Solutions • Houston (TX)

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

Continuum Solutions • Houston (TX)

On-site
USD 100,000 - 130,000
Senior Data Engineer
Senior Data Engineer

Addison Group • Houston (TX)

On-site
USD 120,000 - 160,000
Sr. Data Engineer (Snowflake)
Sr. Data Engineer (Snowflake)

Data Ideology • Pittsburgh

Remote
USD 120,000 - 180,000
Flexible Time Off Policy
Health Benefits
Retirement Plan
+5
Senior Data Platform Engineer
Senior Data Platform Engineer

WorkTrust Solutions • United States

Remote
USD 140,000 - 190,000
Sr. Data Engineer
Sr. Data Engineer

Addison Group • Dallas (TX)

On-site
USD 100,000 - 122,000
Medical
Dental
Vision
+1
Information Technology - Senior Data Engineer (USA)
Information Technology - Senior Data Engineer (USA)

DiversiTech Corporation • Duluth (GA)

On-site
USD 120,000 - 180,000
Snowflake Data Engineer
Snowflake Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 124,000