Budget & Data Analyst

Description
FP&C is seeking a Budget & Data Analyst to support the U.S. Department of Energy (DOE) with budget planning, financial management, data analysis, and business operations for the Federal Energy Management Program (FEMP) and related activities.

This position is responsible for tracking program expenditures, coordinating funding and contract actions, developing budget forecasts and scenarios, and producing financial reports and performance dashboards. The Analyst will also support travel and conference approvals, information management requests, and improvements to program processes and tracking systems.

The ideal candidate combines strong analytical capabilities with practical budget management experience, exceptional attention to detail, and the ability to independently coordinate multiple priorities in a federal program environment.

Key Responsibilities

Organize, maintain, and monitor multiple FEMP interagency agreements (IAAs), contract actions, funding actions, and annual operating plan (AOP) analyses; identify outstanding decisions, risks, and deadlines.
Coordinate with federal budget and program teams to identify priorities, define strategic action items, track dependencies, and support timely execution of planned activities.
Collect, validate, calculate, and align program impact and performance metrics; reconcile inputs across sources and explain material variances or inconsistencies.
Develop and maintain data visualizations, dashboards, spreadsheets, and briefing materials that communicate key performance indicators, budget status, and program results.
Prepare and analyze alternative budget scenarios, spending assumptions, forecasts, and funding options; identify gaps and recommend practical adjustments to execution plans.
Maintain accurate Program Direction spending trackers, including planned versus actual expenditures, available balances, commitments, and other program-specific financial information; verify transactions against spend plans.
Track travel requests, approval status, anticipated costs, and actual travel expenditures; maintain organized records and communicate upcoming actions or exceptions.
Draft, revise, and communicate program travel guidance and procedures in coordination with appropriate government stakeholders and applicable requirements.
Serve as a coordination point of contact for IACC, SCEP, and FEMP conference activities; assemble and track approval packages, participant and cost data, registration status, and post-event actuals as required.
Coordinate with CMEI budget, financial oversight, conference management, and procurement personnel on conference funding and approvals, registration payments, procurement paperwork, and associated spend-plan updates.
Prepare conference activity status reports, identifying pending approvals, near-term deadlines, unresolved questions, risks, and corrective actions; follow packages through the appropriate approval processes.
Support information management requests, data calls, budget inquiries, integrated reporting, and information consolidation, including assistance with responses to Congressional and Freedom of Information Act (FOIA) requests.
Enter, review, and reconcile financial and project information in designated program systems; maintain program tracking tools and update SharePoint resources, procedures, and standard operating procedures (SOPs).
Produce, proofread, edit, and format budget summaries, management reports, correspondence, operating plans, presentations, and time-sensitive executive briefing materials.
Coordinate planning meetings and multiyear planning activities; assess existing business management processes and recommend or implement practical improvements to systems, workflows, and reporting quality.
Requirements
Education & Experience:

Required

Bachelor's degree from an accredited institution in Finance, Accounting, Economics, Business Administration, Public Administration, or a related field.
Minimum of five (5) years of progressively responsible professional experience in budget analysis, financial management, financial reporting, or related program operations.
Demonstrated hands-on experience maintaining operating budgets, tracking expenditures, analyzing financial variances, and developing financial forecasts or spending scenarios.
Experience preparing financial analyses, management reports, or performance metrics to support operational and strategic decision-making.
Experience coordinating financial or operational activities involving multiple stakeholders, priorities, and deadlines.
Advanced proficiency in Microsoft Excel, including financial analysis, formulas, pivot tables, and reporting.
Preferred

Eight (8) or more years of relevant professional experience in budget analysis, financial management, or related program operations.
Experience supporting federal agency budget formulation, execution, and financial management activities.
Familiarity with interagency agreements (IAAs), annual operating plans (AOPs), contract funding actions, and federal expenditure tracking.
Experience supporting DOE or other federal government programs.
Experience developing financial dashboards and performance metrics using Power BI or comparable business intelligence tools.

Knowledge, Skills & Abilities:

Strong quantitative and analytical skills, including budget modeling, variance analysis, scenario development, forecasting, and interpretation of performance data.
Ability to independently maintain precise financial and administrative records, reconcile information across tracking systems, and identify incomplete or inconsistent data.
Ability to coordinate competing actions and deadlines, follow approval workflows, and communicate effectively with program, budget, financial oversight, and procurement stakeholders.
Strong critical thinking and problem-solving skills, with the ability to identify financial risks, evaluate alternatives, and recommend actionable solutions.
Clear and professional written communication skills, including drafting policies, standard procedures, correspondence, presentations, and executive-level summaries.
Excellent organizational skills, attention to detail, sound judgment, discretion, and follow-through in a deadline-driven program environment.
Ability to manage multiple assignments independently while maintaining accuracy and meeting established deadlines.
Ability to learn and apply agency-specific processes and information systems while recommending practical improvements to reporting and operations.

Technical Skills

Advanced proficiency with Microsoft Excel for financial tracking, analysis, modeling, and reporting.
Proficiency with Microsoft Word, PowerPoint, Outlook, and collaboration tools.
Ability to develop clear charts, dashboards, and key performance indicator (KPI) visualizations using Power BI, Excel, or comparable reporting tools.
Experience maintaining financial tracking spreadsheets, reconciling data from multiple sources, and preparing financial reports.
Ability to work in SharePoint and other program, budget, conference, and financial tracking applications; ability to learn designated DOE applications and tracking systems.