Subsurface Data Analyst / Power BI Analyst – Oil & Gas

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

Job summary

Strategic Staffing Solutions, Inc. is seeking a Subsurface Data Analyst / Power BI Analyst – Oil & Gas in Midland, TX for a 12-month contract. The role emphasizes Power BI development, Python and SQL data prep, validation, and automated reporting to support ALM Subsurface and regulatory needs.

The position demands experience with data quality, data modeling, and regulatory reporting, plus strong communication with stakeholders. On-site work in Midland is required for this contract assignment.

Qualifications

• Demonstrated experience building and maintaining Power BI dashboards and data visualizations.
• Proficiency with Python, SQL, and advanced Excel for data analysis and automation.
• Experience in data validation, stewardship, and quality-control processes.
• Background supporting regulatory reporting in oil & gas operations preferred.
• Strong communication and stakeholder engagement skills.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards for ALM Subsurface, Operations, and leadership teams.
• Create Python- and SQL-based solutions to automate reporting and data validation.
• Transform complex subsurface data into scalable visualizations and decision-support tools.
• Support data-source transitions, dashboard migrations, and reporting enhancements.
• Document data definitions and reporting methodologies; serve as data steward.

Skills

Power BI dashboards

Python

SQL

Advanced Excel

Data validation

Regulatory reporting

Stakeholder engagement

Tools

Power BI

Python

SQL

Excel

Job description

STRATEGIC STAFFING SOLUTIONS HAS AN OPENING!

This is a Contract Opportunity with our company that MUST be worked on a W2 Only. No C2C eligibility for this position.

“Beware of scams. S3 never asks for money during its onboarding process.”

Job Title: Subsurface Data Analyst / Power BI Analyst – Oil & Gas

Location: Midland, TX 79706

Contract Length: 12 Months

On Site Work

Position Summary

Provides data, analytics, visualization, regulatory reporting, and technical workflow support to the New Mexico Asset Lifecycle Management Subsurface team. This role develops and maintains automated reporting solutions, improves data quality, and converts complex operational and subsurface datasets into actionable business insights.

A primary focus is Power BI development and sustainment, supported by Python and SQL-based data preparation, validation, and workflow automation. The role also supports New Mexico regulatory reporting and develops Plug and Abandonment (P&A) packages, including supporting documentation, wellbore diagrams, and AFE generation.

Required Qualifications

• Demonstrated experience developing and maintaining Power BI dashboards and data visualizations
• Working knowledge of Python, SQL, and advanced Excel for data analysis, reporting, workflow automation, data export manipulation, and automated spreadsheet refreshes
• Experience with data validation, data stewardship, and quality-control processes
• Experience supporting regulatory reporting, preferably within oil and gas operations
• Strong communication, organizational, and stakeholder engagement skills

Preferred Qualifications

• Advanced proficiency with Power BI, including Power Query, DAX, and data modeling
• Experience developing Python-based automation and analytical workflows
• Experience working with upstream production, well test, allocation, or subsurface datasets
• Experience with New Mexico regulatory reporting and NMOCD compliance requirements
• Experience supporting Plug and Abandonment workflows, wellbore documentation, and AFE generation
• Awareness of or proficiency with Energy Components, particularly for supporting allocation corrections and resolving production data/network errors

Technical Skills

• Power BI
• Power Query
• DAX
• Python
• SQL
• Advanced Microsoft Excel
• Data modeling and visualization
• Workflow automation
• Data validation and quality control
• Regulatory reporting
• P&A package development
• AFE generation

Responsibilities

• Develop, maintain, and enhance Power BI dashboards that provide actionable insights for ALM Subsurface, Operations, and leadership teams
• Develop Python- and SQL-based solutions to automate reporting, data validation, and recurring business workflows
• Transform complex operational and subsurface data into scalable visualizations and decision-support tools
• Support enterprise data-source transitions, dashboard migrations, and reporting enhancements
• Identify opportunities to simplify, standardize, and automate manual work processes
• Maintain data quality and integrity across production, well test, allocation, and regulatory datasets
• Validate data sources, troubleshoot discrepancies, and coordinate corrective actions with stakeholders
• Support well test validation workflows and continuous improvement of automated validation logic
• Document data definitions, business rules, and reporting methodologies
• Serve as a key data steward for reporting and visualization products
• Manage assigned New Mexico regulatory reporting requirements, including IP testing, SWD reporting, and associated compliance submissions
• Prepare, validate, and submit required NMOCD reporting and supporting documentation
• Maintain regulatory reporting databases, trackers, and audit-ready records
• Investigate and resolve data discrepancies impacting regulatory compliance
• Develop reporting and visualization tools to improve compliance visibility and reporting accuracy
• Develop and maintain Plug and Abandonment packages, supporting documentation, and workflow records
• Prepare wellbore diagrams, technical summaries, and required case documentation
• Generate and maintain AFEs supporting P&A execution activities
• Coordinate technical, operational, and financial inputs required for package approval
• Maintain reporting and tracking tools supporting inactive well and P&A program management
• Seniority LevelMid-Senior level
• Employment TypeContract