Upstream Analyst Jobs (NOW HIRING)

Upstream Data Analyst

Denver, Colorado

Petro-Hunt, L.L.C., a Dallas, Texas mid-sized independent Oil and Gas Exploration Company, is seeking an Upstream Data Analyst for its Denver, Colorado office.

About Petro-Hunt, L.L.C.

Petro-Hunt, L.L.C. is a privately held independent oil and gas company headquartered in Dallas, Texas. Owned and operated by the William Herbert Hunt family, Petro-Hunt and its affiliates are actively engaged in various industries with a primary focus in the oil and gas industry.

Our company traces its roots to the 1920s, when the legendary H.L. Hunt entered the oil and gas business in El Dorado, Arkansas, and later played an active role in developing the East Texas Oil Field from the drill test of the Daisy Bradford #3.

Today, Petro-Hunt is a Top 10 Private Liquids Producer in the U.S. with operations in six states. We are more than just an oil and gas company — Petro-Hunt actively purchases minerals and royalties, owns and operates a gas processing facility, is part owner of an oil refinery, actively invests in real estate development, and operates a private equity alternative investment division.

Job Summary

Our Denver office generates and consumes a large amount of data — well logs and subsurface interpretations, daily drilling and completion reports, and production and operations history — and much of it lives in separate systems that do not talk to each other. The Upstream Data Analyst exists to close that gap.

This is a hands-on, analyst-leaning role for someone who is equally comfortable writing a query, wiring two databases together, and presenting a chart that changes a decision. You will pull data from across the drilling, completions, production, and geoscience domains, reconcile it into something trustworthy, and turn it into analysis that geologists, engineers, and management actually use. Just as importantly, you will look for the parts of that work that should not be done by hand twice and automate them — increasingly with the help of AI tooling.

We are looking for curiosity and technical range for this position. If you want to avoid doing repetitive tasks and look forward to digging into the data and databases and creating workflows to answer complex questions, we would like to talk to you.

Key Responsibilities

Data Integration

• Connect and reconcile data across disparate upstream systems — drilling and completions reporting (e.g., WellView, Corva), production and operations databases (e.g., P2 Carte), geoscience projects (e.g., Kingdom Suite, GeoGraphix), commercial data vendors (e.g., Enverus, S&P), state regulatory databases, and internal accounting and land systems.
• Build and maintain repeatable pipelines that move data between these systems so analysis starts from one trusted source rather than a fresh export.
• Migrate and synchronize data between geoscience platforms, corporate databases, and vendor exports, preserving data integrity and auditability along the way.
• Resolve the identity problems that make upstream data hard: API number formats, well and completion naming conventions, wellbore vs. producing-entity relationships, and unit and datum inconsistencies.

Analysis and Reporting

• Answer real business questions with data — well performance benchmarking, decline behavior as related to geologic variations, and offset operator activity.
• Build dashboards, recurring reports, and one-off analyses for geoscience and management audiences.
• Present findings clearly to technical and non-technical staff, including the assumptions and data limitations behind them.

Automation and AI

• Identify manual, repetitive workflows across the office and replace them with scripted or automated processes.
• Apply AI tools — large language models, coding assistants, and data analysis assistants — to accelerate development and deal evaluation, extract information from unstructured sources such as scanned reports and PDFs, and shorten the path from question to answer.
• Evaluate new tooling pragmatically and help the office adopt what actually works.

Geoscience Platform and Data Stewardship

• Administer geoscience interpretation projects and databases (GeoGraphix strongly preferred; Kingdom Suite or Petra experience considered) — project creation and maintenance, well and log data loading, formation tops, directional surveys, and backup/recovery.
• Maintain the health of the geoscience database environment, including direct database-level access for querying, QC, and bulk updates.

Data Quality and Governance

• Own the QC of the datasets you build: validate spatial and attribute data, including coordinate reference systems, well headers, directional surveys, and allocation logic.
• Document data sources, definitions, and transformations so results are reproducible and auditable.
• Help develop and enforce practical data standards and naming conventions across the Denver office.

Cross-Functional Support

• Work directly with geologists to support daily workflows and project work.
• Serve as the go-to technical resource for geologists’ day-to-day software and data issues.
• Serve as a liaison between technical staff and the IT and corporate data groups in Dallas.
• Support the preparation of exhibits and data packages for regulatory hearings and internal reviews.

Qualifications

Education

• Bachelor's degree in Data Science, Statistics, Computer Science, Engineering, Geology, GIS, Earth Sciences, Mathematics, or a related quantitative field.

Experience

• 3+ years of relevant technical experience. Candidates with upstream oil and gas experience will be considered at a commensurate level; exceptional early-career candidates who can demonstrate substantial self-directed technical work may also be considered.

Technical Skills

• Strong SQL and hands-on experience querying and joining data across relational databases; experience querying vendor application databases directly (e.g., SAP SQL Anywhere/Sybase, SQL Server) is a strong plus.
• Proficiency in Python for data work (pandas, or equivalent), including reading and writing common industry formats such as LAS, CSV, and vendor exports.
• Experience building visualizations and dashboards (e.g., Power BI, Spotfire, Tableau, or Python-based tools).
• Comfort with GIS concepts and tools (e.g., ArcGIS, QGIS), including coordinate reference systems and spatial joins.
• Version control (Git) and general software hygiene are a plus.

AI Proficiency

• Demonstrated ability to leverage AI tools — large language models, coding assistants, and data analysis assistants — to streamline complex tasks, automate workflows, and enhance productivity. We use these tools daily and expect this person to help us use them better.

Preferred Skills

• Working knowledge of upstream oil and gas data: well logs, drilling and completion reporting, production allocation, 2D/3D seismic, and other subsurface data types.
• Hands-on administration of a geoscience interpretation platform — GeoGraphix strongly preferred — including its underlying data model and import/export formats.
• Experience with commercial data products (Enverus, IHS/S&P, TGS) and state regulatory data sources (NDIC, COGCC/ECMC, RRC).
• Exposure to cloud data platforms or modern data stack tooling.
• Strong attention to detail and organizational skills.
• Excellent written and verbal communication; able to explain a result and defend the method behind it.
• A bias toward automating the boring parts and a low tolerance for doing the same thing twice.

What We Offer

• Fast-paced, well-funded, aggressive work environment in a stable, private company
• Direct exposure to decision-makers and real influence over how the office works with data
• Competitive salary
• Highly competitive benefit programs
• 8% 401K match
• Parking provided