Subsurface Data Analyst / Power BI Analyst - Oil & Gas

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.

• 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