Cost Controls BI Analyst - SQL & Power BI

ExxonMobil; Spring (TX); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Pension Plan

Savings Plan

Workplace Flexibility

Medical/Dental/Vision

Culture of Health

Health Advisory Program

Disability Plan

Job summary

ExxonMobil is seeking a Cost Controls Analyst in Texas to establish and improve cost and project controls, delivering data-driven insights for EP&P and Post-Stim teams. You will build Excel models, write SQL queries, and create dashboards to track budgeting, forecasting, and performance.

The role requires 3–5 years in cost control or related analytics, with strong Excel, SQL, and BI tool skills. ExxonMobil offers comprehensive benefits and growth opportunities in a large energy organization.

Qualifications

• Bachelor’s Degree in Engineering, Business, Finance, Accounting, Data Analytics, or a related field (required).
• 3-5 years of experience in cost control, financial analysis, accounting, project controls, or a related analytical role.
• Advanced proficiency in Excel (complex formulas, pivot tables, Power Query, data modeling).
• Strong technical skills, including: SQL for querying, data extraction, and validation; Power BI, Spotfire, or similar BI tools; Data analysis, interpretation, and visualization.

Responsibilities

• Establish, implement, and continuously improve cost and project controls systems, tools, and methodologies.
• Conduct detailed cost, financial, and variance analysis to support Execution Planning & Performance (EP&P) and Post-Stim execution teams.
• Support Post-Stim execution teams with AFE creation/revisions, cost estimating, planning, contracting, scheduling, and performance tracking.
• Develop advanced Excel models and analytical frameworks to support budgeting, forecasting, KPI measurement, and cost reporting.
• Write, maintain, and optimize SQL queries to extract, validate, and analyze large datasets from enterprise systems.
• Create automated dashboards and reporting tools using Power BI, Spotfire, or similar platforms to provide real-time visibility into project and financial performance.
• Prepare weekly, monthly, quarterly, and annual cost and performance reports.
• Analyze KPIs and investigate cost deviations to identify trends, anomalies, and root causes.
• Serve as a subject matter expert for cost and financial data, ensuring accuracy, consistency, and data integrity across systems.
• Provide data-driven insights to identify business challenges, propose solutions, and support continuous improvement initiatives.
• Collaborate cross-functionally to maintain strong working relationships across all levels of the organization.
• Perform additional duties or analysis projects as assigned.

Skills

Advanced Excel

SQL

Power BI

Spotfire

Data analysis

Education

Bachelor’s Degree (Engineering/Business/Finance/Accounting/Data Analytics)

Tools

Power Query

Pivot Tables

Data Modeling

Job description

ExxonMobil is seeking a Cost Controls Analyst in Texas to establish and improve cost and project controls, delivering data-driven insights for EP&P and Post-Stim teams. You will build Excel models, write SQL queries, and create dashboards to track budgeting, forecasting, and performance.

The role requires 3–5 years in cost control or related analytics, with strong Excel, SQL, and BI tool skills. ExxonMobil offers comprehensive benefits and growth opportunities in a large energy organization.