Oil & Gas Analyst

R2Q Operating LLC; Dallas (TX); Hybrid; USD 85,000 - 120,000; Full time

Job summary

R2Q Operating LLC in Dallas, TX is seeking an Oil & Gas Analyst to support reporting, analytics, and data initiatives across production, operations, accounting, land, and leadership. You will build BI solutions, analyze data, and ensure enterprise reporting integrity for informed decision-making.

The role consolidates data from multiple assets and systems into a modern reporting environment to drive strategic insights and growth in a rapidly expanding multi-operator platform.

Qualifications

• Bachelor's degree in Business, Finance, Analytics, Economics, Information Systems, Petroleum Engineering, Computer Science, or a related field.
• Minimum 2 years of experience in oil & gas analytics, business intelligence, production accounting, operations reporting, or related roles.
• Experience with upstream oil & gas data and reporting tools.

Responsibilities

• Develop, maintain, and enhance dashboards, reports, and KPIs using Power BI and SSRS.
• Analyze production, revenue, expense, drilling, completion, and land data to identify trends.
• Design and maintain data models and data integration across systems.
• Develop SQL queries and database reporting solutions in PostgreSQL.
• Collaborate with operations, accounting, land, engineering, and leadership to define reporting requirements.

Skills

SQL

Power BI

PostgreSQL

Excel

Data analysis

Communication

Education

Bachelor's degree in a relevant field

Tools

SSRS

Power BI

PostgreSQL

ETL

Python

Job description

EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.

Category Operations

Oil & Gas Analyst Job Summary

The Oil & Gas Analyst will support reporting, analytics, and data initiatives across production, operations, accounting, land, and executive leadership teams. This role is responsible for developing and maintaining business intelligence solutions, analyzing operational and financial data, and ensuring the integrity of enterprise reporting systems.

This is an opportunity to help build reporting and analytics capabilities for a rapidly growing multi-operator oil & gas platform, consolidating data from multiple assets and systems into a modern reporting environment that supports strategic decision-making across the organization.

Location

• Preferred: Dallas-Fort Worth, TX area.
• Hybrid schedule with a minimum of three (3) days per week in the office.
• Exceptional candidates located elsewhere in Texas may be considered.

Oil & Gas Analyst Job Responsibilities

• Develop, maintain, and enhance dashboards, reports, and KPIs using Power BI and SSRS.
• Analyze production, revenue, expense, drilling, completion, and land data to identify trends and support business decisions.
• Design and maintain data models and data integration processes across multiple systems.
• Develop and execute SQL queries, stored procedures, and database reporting solutions, primarily within PostgreSQL environments.
• Collaborate with and present findings to operations, accounting, land, engineering, and executive leadership to define reporting requirements and deliver actionable insights.
• Monitor, validate, and troubleshoot data quality across legacy and current systems, including historical data migrations, system integrations, and ongoing reporting processes.
• Document reporting processes, data definitions, and best practices to support scalability and long-term maintainability.

Oil & Gas Analyst Job Qualifications

• Bachelor's degree in Business, Finance, Analytics, Economics, Information Systems, Petroleum Engineering, Computer Science, or a related field.
• Minimum 2 years of experience in oil & gas analytics, business intelligence, production accounting, operations reporting, or related analytical roles.
• Experience working with upstream oil & gas production, operational, financial, or land data.
• Advanced proficiency in SQL (PostgreSQL preferred), including ETL and data integration work, plus proven experience building reports and dashboards in Power BI.
• Strong Microsoft Excel skills, including Power Query, Pivot Tables, and advanced data analysis functions.
• Experience with upstream oil & gas systems (e.g., Enverus, Peloton, PHDwin, OGSys, ComboCurve, or similar)
• Strong analytical, problem-solving, and critical-thinking skills with excellent verbal and written communication.

Preferred Qualifications

• Experience with Python for data analysis, automation, or reporting workflows.
• Experience supporting data migrations, acquisitions, or multi-system consolidations.
• Familiarity with upstream operations, production accounting, reserves reporting, and asset performance metrics.
• Experience working in high-growth or private equity-backed oil & gas organizations.

Employment Details

Rate Range

Position Oil & Gas Analyst

Number of Openings 1

Exempt/Non-Exempt Exempt

Open Date 11/5/2026

Location Dallas Office - R2Q

About the Organization The Company is a private equity company.

This position is currently accepting applications.