Power BI Developer: Data Visualization & Automation in Oil & Gas

Compunnel Inc.; Midland (TX); On-site; USD 90,000 - 135,000; Full time

Job summary

Compunnel, Inc. in Midland is seeking a Power BI Developer to turn operational and subsurface data into actionable insights. You will design dashboards, automate reporting with Python and SQL, and ensure data quality for asset lifecycle regulatory submissions.

The role prioritizes data governance, standardization, and scalable visuals to support Operations and leadership. Strong communication with stakeholders is essential.

Qualifications

• Experience developing and maintaining Power BI dashboards and visuals.
• Proficiency with Python and SQL for data prep and automation.
• Advanced Excel for data analysis and automation.
• Experience with regulatory reporting in oil and gas preferred.
• Strong communication and stakeholder engagement.

Responsibilities

• Develop and maintain Power BI dashboards for operations and leadership.
• Create Python- and SQL-based solutions to automate reporting.
• Transform complex data into scalable visualizations and decision tools.
• Support data-source transitions and dashboard migrations.
• Document data definitions and reporting methodologies.
• Coordinate regulatory reporting and supporting documentation.

Skills

Power BI dashboards

Data visualization

Data analysis

Stakeholder engagement

Excel advanced

Education

Bachelor's degree in a related field

Tools

Power BI Desktop

Power Query

DAX

Python

SQL

Excel

Job description

Seeking a Power BI Developer to provide data analytics, visualization, regulatory reporting, and technical workflow support for the Asset Lifecycle Management team. The role focuses on developing and maintaining automated reporting solutions, improving data quality, and transforming complex operational and subsurface datasets into actionable business insights. The ideal candidate will have strong Power BI development skills supported by Python and SQL for data preparation, validation, reporting automation, and recurring business workflows.

Key Responsibilities:

• Develop, maintain, and enhance Power BI dashboards that provide actionable insights for 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 to maintain confidence in reporting and visualization products.

• Manage assigned regulatory reporting requirements, including IP testing, SWD reporting, and associated compliance submissions.

• Prepare, validate, and submit required regulatory 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 that improve compliance visibility and reporting accuracy.

• Develop and maintain Plug and Abandonment (P&A) 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.

Required Qualifications:

• Demonstrated experience developing and maintaining Power BI dashboards and data visualizations.

• Strong working knowledge of Power BI, Power Query, DAX, and data modeling.

• Working knowledge of Python and SQL for data analysis, reporting, workflow automation, data validation, and data manipulation.

• Advanced Excel skills for data analysis, reporting, 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.

• Experience with data modeling, visualization, and workflow automation.

• Strong communication, organizational, and stakeholder engagement skills.

Preferred Qualifications:

• Experience developing Python-based automation and analytical workflows.

• Experience working with upstream production, well test, allocation, or subsurface datasets.

• Experience with regulatory reporting and compliance requirements.

• Experience supporting Plug and Abandonment workflows, wellbore documentation, and AFE generation.

• Experience with Energy Components, particularly for supporting allocation corrections and resolving production data or network errors.