Reserves Data & Planning Analytics Lead

Flywheel Energy, LLC; Oklahoma City (OK); On-site; USD 95,000 - 150,000; Full time

Job summary

Flywheel Energy is seeking a Reserves & Planning Analyst to own reserves data QC and reporting workflows, integrate assets across Aries and planning systems, and lead third-party audits. You will build Power BI, Spotfire and Excel tools to turn reserves data into actionable insights for development and planning decisions.

The role collaborates with asset development, operations, finance, accounting and external auditors, with opportunities to expand into deeper technical, economic and

Qualifications

• Bachelor’s degree in a STEM field preferred; equivalent experience considered.
• 5+ years of upstream oil and gas experience in reserves, planning, or asset development analysis.
• Hands-on experience with Aries (or a comparable reserves and economics platform).
• Working SQL skills for querying and reconciling large datasets.
• Experience building dashboards and analysis in Power BI or Spotfire, plus advanced Excel.
• Experience supporting third-party reserves audits and SEC reserves reporting.
• Scripting or automation experience (for example Python).

Responsibilities

• Manage reserves data integrity, QC and reporting workflows across Aries and other source systems
• Lead and support third-party reserves audits and prepare technical documentation for auditors and leadership
• Maintain detailed audit trails, change logs and query documentation so every result is repeatable and auditable
• Review and reconcile auditor data to internal views, building analytical and visualization tools to assess accuracy and flag material variances
• Develop tools that pull actuals from accounting, finance, marketing and operations systems and transform them into Aries-ready formats
• Build and maintain Power BI, Spotfire and Excel tools for reserves tracking and variance analysis, clearly communicating the key drivers
• Apply advanced Aries and analytics skills to support deeper technical, economic and planning analysis
• Manage data integrity with emphasis on production accuracy, ownership completeness and audit readiness
• Serve as the data governance lead across reserves, planning and asset development by enforcing standards, validation checks and documentation
• Develop data automation, standardized templates and repeatable workflows for reserves reporting and audits
• Standardize reserves evaluation workflows across assets for consistency and transparency
• Work with Asset Development, Planning and Operations to assess the feasibility, risks and benefits of new tools, methods and industry best practices
• Continuously improve reserves and planning workflows through automation, system integration and better analytical tools
• Partner with other teams on modeling for capacity constraints, development timing, midstream and infrastructure as needed
• Track industry trends and evaluate their impact on asset performance and reserves methodologies

Skills

SQL

Power BI

Spotfire

Excel

Aries

Data visualization

Python

Education

Bachelor’s degree in a STEM field

Tools

Aries

Python

Job description

Flywheel Energy is seeking a Reserves & Planning Analyst to own reserves data QC and reporting workflows, integrate assets across Aries and planning systems, and lead third-party audits. You will build Power BI, Spotfire and Excel tools to turn reserves data into actionable insights for development and planning decisions.

The role collaborates with asset development, operations, finance, accounting and external auditors, with opportunities to expand into deeper technical, economic and