Data 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 Data 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 Data Engineer, you will be responsible for building and maintaining reliable, high-performance data pipelines that support analytics, reporting, and digital workflows across the upstream oil and gas value chain. This role combines technical expertise, problem-solving, and optimization skills to ensure data is accurate, reliable, and readily available across environments. This role is ideal for someone with a strong foundation in SQL, Python, and AWS data services, along with a deep understanding of data modeling and ETL processes.

If this sounds like you – let’s talk!

• Understand complex data structures and analyze datasets to identify trends, patterns, and anomalies that inform business decisions.
• Diagnose and resolve issues within data pipelines, infrastructure, and workflows to ensure reliability and data integrity.
• Improve query performance, workflow efficiency, and system scalability across multiple environments and platforms.
• Develop and maintain data pipelines and automation scripts using SQL and Python.
• Define and implement facts and dimensions to support enterprise reporting, analytics, and business intelligence use cases.
• Design, build, and maintain ETL (Extract, Transform, Load) processes using modern data engineering tools and frameworks.
• Create, maintain, and leverage DEV/TEST/PROD environments to manage and promote data pipelines, processes, and data products.
• Utilize AWS services such as Athena, Dynamo
  
  DB, S3, Glue, and Lambda to build scalable, cloud-native data solutions.
• Ensure data accuracy, consistency, and compliance with corporate standards and best practices.
• Partner with analysts, developers, and business stakeholders to understand data needs and deliver effective, scalable solutions.

• Bachelor’s degree in Information Technology, Computer Science, or relevant work experience
• 5+ years of experience in data engineering
• Strong proficiency in SQL and Python for data manipulation and automation
• Hands-on experience with ETL tools and frameworks
• Practical understanding of data modeling concepts
• Experience working with cloud platforms, preferably AWS
• 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
• 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 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.