FP&A Financial Systems Lead — Power BI, SQL & SAP

Wilks Brothers, LLC; Houston (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

CARBO Ceramics in Houston, TX seeks a hands-on FP&A professional to own budgeting, forecasting, and executive reporting. You will model data in Power BI, write SQL and Python queries, and partner with CFO, Sales, and Production to drive informed decisions.

The role emphasizes building automated pipelines and maintaining financial systems. Five+ years of experience in FP&A or related fields is expected, with on-site work at the Houston headquarters.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Systems, Economics, Data Analytics, Statistics, Computer Science, or a closely related field.
• Five or more years of experience in financial planning and analysis, corporate finance, financial systems, or a business analyst role supporting a finance function.
• Demonstrated ownership of budgeting, forecasting, and variance analysis for a business unit or a company, not solely support of another analyst's model.
• Working knowledge of United States generally accepted accounting principles and fluency with the income statement, balance sheet, and statement of cash flows.
• Advanced Microsoft Excel, including complex and nested formulas, INDEX/MATCH or XLOOKUP, pivot tables, and sound financial model structure.
• Proficiency writing SQL, including multi-table joins, aggregations, common table expressions, and window functions.
• Experience building production reports and data models in Power BI and Power Query, including writing DAX measures.
• Ability to read and write Python for data work, including the NumPy and Pandas libraries.
• Experience working in SAP ECC or another enterprise resource planning system in a financial reporting or data extraction capacity.
• Ability to present financial results clearly to non-financial managers, in writing and in person.
• Ability to work on site at CARBO's Houston, Texas corporate headquarters.
• Experience with a cloud data platform such as Azure Data Lake, Databricks, Delta Lake, or PySpark preferred.
• Experience in manufacturing, industrial products, or another multi-plant operating environment preferred.
• Working knowledge of standard costing, contribution margin, or plant-level cost accounting preferred. Microsoft PL-300 Power BI Data Analyst Associate or DP-600 Fabric Analytics Engineer Associate certification preferred.
• Certified Corporate FP&A Professional (FPAC) credential preferred.
• Experience using AI-assisted development tools within an analytics or reporting workflow preferred.

Responsibilities

• Owns the annual budget, long-range plan, and rolling forecast models, including the scenario and sensitivity modeling presented for executive review.
• Builds and maintains the monthly variance analysis comparing actual results against budget and forecast, and writes the commentary identifying the specific drivers behind each variance.
• Develops and maintains executive dashboards in Power BI, including the underlying data models, DAX measures, and refresh reliability.
• Extracts and transforms financial and operational data from SAP ECC and the company's SQL Server and cloud data platform using SQL, Power Query, and Python.
• Prepares monthly financial statements and executive reporting packages.
• Analyzes revenue, cost, and plant operational performance to identify margin drivers, inefficiencies, and cost optimization opportunities.
• Partners with Sales and plant Production leadership to source, validate, and integrate operational data into financial planning and reporting processes.
• Evaluates key performance indicators and operational metrics across the business and reports on trends affecting forecast accuracy.
• Replaces manual reporting processes with automated pipelines, and documents financial systems logic and a data dictionary for the FP&A layer so that models and reports remain auditable and transferable.

Skills

Power BI

SQL

Python

Excel (advanced)

Data analytics

Education

Bachelor's degree in Finance or related field

Tools

SAP ECC

Power Query

DAX measures

Job description

CARBO Ceramics in Houston, TX seeks a hands-on FP&A professional to own budgeting, forecasting, and executive reporting. You will model data in Power BI, write SQL and Python queries, and partner with CFO, Sales, and Production to drive informed decisions.

The role emphasizes building automated pipelines and maintaining financial systems. Five+ years of experience in FP&A or related fields is expected, with on-site work at the Houston headquarters.