Senior Data Engineer​/Data Warehouse Engineer

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 Fortune
500s. 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 experience to join our growing team. This position will be hybrid with some travel to client sites.

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 Dev Ops 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!

• 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 Dev Ops 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

• 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 Dev Ops 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 Pack Accounting 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

• 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…