Budget Execution Reporting Support Specialist [PR0060]

Budget Execution Reporting Support Specialist

ProSidian seeks a Budget Execution Reporting Support Specialist (Full-Time) in the Hanford Eastern Washington (Tri-Cities - Kennewick | Pasco | Richland) Area to support an engagement for the US Dept. of Energy (DOE) Hanford.

ProSidian team members work to provide General Support Services Contractor (GSSC) assistance to support DOE Hanford [which consists of Richland Operations Office (RL), and Office of River Protection (ORP)] in support of the Govt's operations, personnel management, and general administration of regional operations at the Hanford Site in Richland, Washington.

ProSidian's work includes supporting requirements for consulting, acquisition support, program/project mgmt., operational/administrative business support, and environmental consulting support. It is also ProSidian's duty to adhere to regulations covering the responsibility to protect classified matter (including documents, material and special nuclear material) in connection with the performance of work under this contract.

BUD Budgetary Support 1572458979017 Candidates shall work to support requirements as a Budget Execution Reporting Support Specialist and provide Budget Execution Reporting Support on behalf of The United States Department of Energy (DOE), Richland Operations Office (RL), Budget Division (BUD).

The Budget Execution Reporting Support Specialist shall provide support to RL BUD, which supports RL and the Office of River Protection (ORP), in the following areas:

• Serve as the focal point for collecting and reporting budgetary data for monthly, quarterly, semiannual, annual, and ad hoc reporting to Hanford, HQ DOE, and other stakeholders. This includes information communicated via Microsoft PowerPoint, Excel, Power Query, Power Pivot, Power BI, SharePoint, Teams, Outlook, Word, and other DOE-approved systems. Secure approval from appropriate DOE officials before releasing.
• Retrieve data and information and prepare presentations in PowerPoint, Power BI, Word, or other identified software. Coordinate with others to provide inputs. Secure approval from appropriate DOE officials before releasing.
• Maintains a repository of budget historical data (e.g., monthly, quarterly, annual), simplifies uploading process and access to information
• Facilitate usage, and provide training, for Power Query, Power Pivot, Power BI, SharePoint, and Teams to business team members and other key individuals
• Coordinate with Information Technology (IT) departments to facilitate user permissions
• Retrieve data from various sources, including DOE's iManage Data Warehouse (IDW) thru iPortal and various Excel (or other) files from DOE employees and contractors
• Create and maintain customized reports using Business Intelligence (BI) software available on iPortal
• Use Excel, Power Query, Power Pivot and Power BI extensively to build and maintain dimension and fact tables, relationships between tables, and overall data schema. This includes tables external to data in IDW, such as spend plans and budget targets (also known as ceilings and allocations).
• Build and maintain queries to retrieve data and easily prepare it for use, otherwise known as extract, transform, and load (ETL)
• Create and maintain power pivot tables and charts, which sit on top of the entire data model rather than a single table or range.
• Create and maintain calculated columns and even more flexible measures using data analysis expressions (DAX)
• Create and maintain visually appealing analytical information, including pivot tables, pivot charts, and dashboards
• Coordinate with Information Technology (IT) departments to facilitate user permissions and streamlined services

The Budget Execution Reporting Support Specialist shall have consecutive employment in a position with comparable responsibilities within the past five (5) years, Must be able to use a computer to communicate via email; and proficient in Microsoft Office Products (Word/Excel/Power point) and related tools and technology required for the position. Work products shall be thorough, accurate, appropriately documented, and comply with established criteria. Work products shall be thorough, accurate, appropriately documented, and comply with established criteria.

The Budget Execution Reporting Support Specialist shall demonstrate:

• High school degree or higher education
• Advanced skill level in Excel
• Intermediate skill level with Power Query, Power Pivot, and Power BI, including the extensive use of DAX language
• Intermediate skill level PowerPoint
• Intermediate skill level with Word
• Intermediate experience in data mining from large data warehouse(s)
• Basic skill level in Outlook
• Basic skill level in SharePoint,
• Excellent reading, writing, and speaking communications skills
• Ability to perform multiple tasks with dynamic priorities independently
• Experience of maintaining databases in Microsoft Access or similar software preferred
• Experience with Teams preferred
• Knowledge of Federal Government and DOE budget execution principles and budget/financial systems preferred
• Knowledge of Hanford Site mission, activities and priorities preferred
• Must be a U.S. Citizen.

TRAVEL: Travel as coordinated with the technical point of contact and approved in writing by the Contracting Officer in advance, is allowed, in accordance with Federal Travel Regulations.

LOCATION: Work shall be conducted at the Department of Energy - Richland Operations Office, The Hanford Site, and Richland, WA.