Job Details

Financial Analyst

The Financial Planning and Analysis (FAF) organization is seeking a skilled Financial Analyst to play a key role in transforming financial data into actionable intelligence for the agency. This position will support FAF's analytical capabilities during a critical period of system and process evolution, including major initiatives such as the Integrated Program Review (IPR). The successful candidate will assist in the development of dashboards in Power BI, conduct financial analysis, and help prepare and maintain financial models. The key impact of this role will be to support BPA's strategic objective of maintaining cost management discipline. This will be achieved by providing accurate, efficient, and effective analytical support for BPA's key financial funding processes. Under the guidance of federal staff, this individual will provide subject matter expertise to support complex projects and validate data integrity across the organization, directly contributing to BPA's mission through sound financial stewardship.

The Financial Planning and Analysis (FAF) team is a small, tight-knit group that plays a central role in guiding BPA's strategic financial direction. The team is responsible for preparing both short-term and long-term financial forecasts, tracking results against budgets, and translating complex data into clear, forward-looking insights for agency leadership. The FAF team operates in a collaborative and focused environment, working directly with decision-makers to support key funding decisions, including cost controls and investments. A contract worker in this role will gain significant experience by building models to evaluate and recommend financial outcomes, designing reports that highlight key performance indicators, and preparing clear summaries for executive reviews. The position is a key contributor to supporting BPA's high-level strategic objectives, working alongside a team dedicated to providing a credible and insightful financial narrative for the entire agency.

Under the guidance of the BPA Manager or a lead federal analyst, perform the following:

• Budgeting, Forecasting, and Analysis: Actively support the annual budget and quarterly forecasting cycles by preparing templates, consolidating inputs, and analyzing financial data submitted by business partners. Conduct detailed variance analysis (e.g., Budget vs. Actual, Forecast vs. Actual) and collaborate with managers to develop insightful commentary on financial performance. Develop and maintain financial models in Microsoft Excel and other systems to support forecasting, long-range planning, and strategic business decisions.
• Management Reporting & Business Partnership: Develop, maintain, and enhance interactive dashboards and reports in Power BI to track Key Performance Indicators (KPIs) and support critical agency processes like the Integrated Program Review (IPR). Assist in the preparation of monthly and quarterly financial reporting packages and presentations for review by BPA leadership. Serve as a financial point of contact for assigned business units, providing ad-hoc analysis and decision support to help them achieve their financial and operational objectives.
• Data Management & Process Improvement: Perform data extraction, transformation, and loading (ETL) to enable timely and accurate data for analysis and reporting. Assist in establishing and enforcing quality control (QC) procedures to validate the accuracy and reliability of key financial datasets. Identify opportunities to improve the efficiency and effectiveness of financial planning and reporting processes.

Education & Corresponding Experience (required on matrix) A bachelor's degree in finance or a closely-related field is preferred. 5 years of progressively responsible experience in financial analysis, data analysis, or business intelligence is required. Experience should include proficiency in developing reports, performing financial modeling, and working with business partners.

Required Technical Skills & Experience (required on matrix) 3+ years of demonstrated experience developing dashboards and reports using Power BI, including working knowledge of DAX and data modeling. 3+ years of experience performing data extraction, transformation, and loading (ETL) from enterprise systems, including writing and interpreting SQL queries. 3+ years of experience developing and maintaining financial models in Microsoft Excel and conducting quantitative analysis to support budgeting and forecasting.

Preferred Skills & Experience (optional on matrix) Experience in government, utility, or finance organization. Experience with Oracle EPM (Enterprise Performance Management) Financial Planning software and PeopleSoft Financials. Familiarity with federal government or utility industry accounting, budgeting, and financial management practices. Experience working within an Agile or project management framework to Track and deliver analytical projects.

Additional Requirements (not required on matrix) Valid U.S. Driver's License is required.