Budget & Data Analyst

Fp; United States; Remote; USD 105.000 - 130.000; Vollzeit

Benefits dieser Stelle

Health, Dental and Vision Insurance

Group Life Insurance

401K with company match

Paid Time Off and Holidays

Zusammenfassung

FP&C is seeking a Budget & Data Analyst to support the U.S. Department of Energy's Federal Energy Management Program (FEMP) with budget planning, financial management, and data analysis.

The role emphasizes tracking expenditures, developing forecasts, producing dashboards, and coordinating with stakeholders across IAAs, contracts, and travel budgets. A strong Excel and BI background is essential.

Qualifikationen

• Bachelor's degree in Finance, Accounting, Economics, Business Administration, Public Administration, or related field.
• Minimum of five (5) years of progressively responsible professional experience in budget analysis, financial management, financial reporting, or related program operations.
• Hands-on experience maintaining operating budgets, tracking expenditures, analyzing financial variances, and developing forecasts or spending scenarios.
• Experience preparing financial analyses, management reports, or performance metrics for 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.

Aufgaben

• Organize, maintain, and monitor IAAs, contract actions, funding actions, and AOP analyses; identify decisions, risks, and deadlines.
• Coordinate with budget and program teams to identify priorities, track dependencies, and support execution.
• Collect, validate, calculate, and align program impact and performance metrics; reconcile inputs and explain variances.
• Develop and maintain dashboards, spreadsheets, and briefing materials communicating KPIs and budget status.
• Prepare and analyze alternative budget scenarios, forecasts, and funding options; identify gaps and adjust execution plans.

Kenntnisse

Budget analysis

Forecasting

Data visualization

Excel proficiency

Stakeholder communication

Project coordination

Ausbildung

Bachelor's degree (Finance/Accounting/Economics/Business/Public Administration) or related field

Tools

Power BI

Excel

SharePoint

DOE tracking systems

Jobbeschreibung

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.

Work Schedule

Full‑time, Monday through Friday, with a standard 40‑hour workweek aligned with customer business hours. The position is primarily remote, with occasional travel or in‑person customer meetings as required to support program activities.

Americans with Disabilities Specifications

Physical Demands:

Work primarily involves prolonged use of a computer, reviewing documents and financial data, and participating in meetings or calls.

Work Environment:

Professional remote/home‑office environment with standard office equipment. Occasional work at customer or government facilities may be required.

FP&C offers a competitive benefits package including:

• Health, Dental and Vision Insurance
• Group Life, Short Term Disability and Long‑Term Disability Insurance
• 401K with company match
• Paid Time Off and Holidays

FP&C is an equal opportunity employer. Employment decisions are based on qualifications, merit, and business needs, consistent with applicable law.

Salary Description

$105K - $130K commensurate with experience