Financial Analyst 2

This Financial Analyst 2 position is located in the Transmission Engineering Business Intelligence and Integrity Organization (TEBI), supporting the Transmission Business Line for Bonneville Power Administration (BPA). This position will serve as a Financial Analyst for the Transmission capital and expense programs designated by the TEBI manager, Internal Operations Manager, Executive Manager or BFTE Project Manager. In addition, this position conducts financial analysis and forecasting of capital, expense and reimbursable programs to validate compliance with BPA capitalization and expense policies. The Financial Analyst works with a variety of individuals and organizations across BPA, to include Executives, Management, Finance, Project Managers, Account Executives, Customer Service Engineers and other Federal Agency Officials.

Perform financial analysis and provide recommendations based on Federal Energy Regulatory Commission (FERC), Generally Accepted Accounting Principles (GAAP) and A-123 guidelines.

Maintain/adhere to internal project analysis policies, processes (update standards, desk procedures) and procedures.

Perform work order completion analysis based on the interpretation of FERC, GAAP, internal audit and A-123 guidelines.

With approval from the applicable Project Manager (PM), place capital assets into plant in-service upon project completion, initiating the start of financial depreciation reported and monitored on BPA's balance sheet. This requires close collaboration and coordination with the PM to properly assign FERC codes to major and minor assets and to accurately retire assets, ending depreciation.

Provide clear, presentable financial reporting data to a variety of stakeholders, such as finance, internal/external auditors, project managers and management, based on target dates set for monthly and yearly financial closing activities.

Research, identify, track and process monthly accruals, reversals and re-accruals for Transmission following accounting guidelines.

Recommend appropriate financial action, based on defined Office of Management Budget (OMB) A-123 policies, financial rules, regulations, policies and procedures.

Perform analysis of past and present financial expenditures to estimate and support financial forecasts, and other ad hoc analysis monthly.

Evaluate and analyze program costs, identify errors, and recommend the appropriate corrective action, monitor until corrections have been completed. Alert the BPA Manager of any errors encountered.

Work closely with Project/Program Manager(s) responsible for capital and expense programs by researching, forecasting, analyzing, extracting, tracking, reviewing, completing and consolidating costs vs. estimates for major projects.

Conduct data analysis and reporting for one or more of the following End of Year and Start of Year Reporting, Quarterly Business Review, Integrated Program Review, Lease Finance Program, Finance Committee Executive Management, Finance, Management Assertion, Target Tracking, Capital Investment Acquisition. (Note: Accuracy and quality of data and reporting produced is of high importance as it is used by decision makers for budget priorities and finalization.)

Conduct ongoing financial training to update Project Managers and/or Performance Managers regarding process workflow, methodologies and technologies related to agency and Transmission financial responsibilities.

Identify gaps and process improvements for various financial activities and subjects.

Create spreadsheets, graphs and PowerPoint presentations used to illustrate financial data when requested.

Maintain repository of financial records. Mark documents and maintain filing system(s), files, emails, and records in accordance with compliance requirements. Share and disperse documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Mark and maintain all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validate official records are accurately maintained for auditing purposes.

Bachelor of Science Degree in Finance, Economics, Statistics, Accounting, Business Mathematics or a closely-related technical field is preferred.

Level 2 position: 5 years of direct work experience in a financial analysis capacity, including all aspects of project support/analysis is required.

3 years of financial forecasting experience.

3 years of working knowledge of automated data systems.

3 years of experience running queries, generating reports to support management, troubleshooting, and resolving issues in an automated environment.

3 years of experience researching data anomalies, evaluating information gathered (sometimes from multiple sources) and reconciling data conflicts.

3 years of experience applying a diversified knowledge of analysis principles and practices.

Must have excellent verbal and written skills sufficient to provide ongoing training and updates to managers, stakeholders and other customers.

Valid U.S. Driver's License is required.