Production & Operations Advisor

Strategic Staffing Solutions; Midland (TX); On-site; USD 90,000 - 130,000; Part time

Job summary

Strategic Staffing Solutions seeks a Subsurface Data Analyst / Power BI Analyst to support upstream oil and gas production and subsurface operations in Midland, Texas. The role focuses on turning complex operational data into dashboards, automated reporting, and actionable business insights.

The candidate will work with subsurface, production, operations, and leadership teams, applying Power BI, SQL, Python, and Excel to drive data quality, regulatory reporting, and P&A program support in a

Qualifications

• Hands-on experience building and maintaining Power BI dashboards and data visualizations.
• Experience using Power Query, DAX, and data modeling.
• Proficiency with SQL and Python for data analysis, reporting, or automation.
• Advanced Microsoft Excel skills and data validation capabilities.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards, reports, and data visualizations.
• Use SQL and Python to automate reporting, data validation, and recurring workflows.
• Analyze production, allocation, regulatory, and subsurface datasets.
• Validate data sources and coordinate corrections with stakeholders.
• Improve data quality and reporting accuracy through data stewardship.

Skills

Power BI

SQL

Python

Excel

Power Query

DAX

Data Visualization

Job description

Subsurface Data Analyst / Power BI Analyst - Oil & Gas

Location: Midland, TX
Contract: 12 Months, on-site
Industry: Oil & Gas / Upstream Energy

Job Overview

We are seeking a Subsurface Data Analyst / Power BI Analyst to support upstream oil and gas production and subsurface operations in Midland, Texas.

This role is ideal for a data and analytics professional with strong Power BI, SQL, Python, and Excel skills who can transform complex operational data into dashboards, automated reporting, and actionable business insights.

The position will work closely with subsurface, production, operations, and leadership teams. In addition to analytics and reporting, the role will support data quality, New Mexico regulatory reporting, and Plug & Abandonment (P&A) activities.

Candidates with experience working with production data, well tests, allocation data, regulatory reporting, P&A programs, or other upstream oil and gas datasets are strongly preferred.

Key Responsibilities

• Develop, maintain, and enhance Power BI dashboards, reports, and data visualizations.
• Use SQL and Python to automate reporting, data validation, data preparation, and recurring workflows.
• Analyze production, well test, allocation, regulatory, and subsurface datasets.
• Transform complex operational data into clear reporting and decision-support tools.
• Validate data sources, identify discrepancies, and coordinate corrections with stakeholders.
• Improve data quality, reporting accuracy, and data stewardship processes.
• Support dashboard migrations, data-source transitions, and reporting enhancements.
• Identify opportunities to automate and streamline manual processes.
• Support New Mexico regulatory reporting and NMOCD compliance requirements.
• Prepare and validate regulatory reports, supporting documentation, trackers, and audit-ready records.
• Support Plug & Abandonment (P&A) programs by preparing technical packages and documentation.
• Prepare wellbore diagrams, technical summaries, and supporting case documentation.
• Generate and maintain AFEs supporting P&A activities.
• Maintain reporting and tracking tools for inactive wells and P&A programs.

Required Qualifications

• Hands-on experience developing and maintaining Power BI dashboards and data visualizations.
• Experience with Power Query, DAX, and data modeling.
• Working knowledge of SQL and Python for data analysis, reporting, or workflow automation.
• Advanced Microsoft Excel skills.
• Experience with data validation, data quality, reporting, and/or data stewardship.
• Ability to analyze complex datasets and translate information into meaningful business insights.
• Strong communication, organization, and stakeholder-management skills.

Preferred Qualifications

• Experience in upstream oil and gas, energy, production operations, or subsurface environments.
• Experience working with production, well test, allocation, or well data.
• Experience with New Mexico Oil Conservation Division (NMOCD) reporting or regulatory compliance.
• Experience supporting Plug & Abandonment (P&A) programs.
• Experience preparing wellbore diagrams, technical well documentation, and AFEs.
• Experience with Energy Components, particularly production allocation corrections or production data/network errors.

Technical Skills

Power BI | Power Query | DAX | SQL | Python | Microsoft Excel | Data Analytics | Data Visualization | Data Modeling | Workflow Automation | Production Data | Data Quality | Regulatory Reporting | NMOCD | P&A | AFE

Who Is a Good Fit?

You may be a strong fit if your current or previous title includes:

Data Analyst, Power BI Analyst, BI Analyst, Production Data Analyst, Subsurface Data Analyst, Production Technologist, Subsurface Technologist, Production Reporting Analyst, Production Operations Analyst, or Oil & Gas Data Analyst.