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
#RichlandWAJobs #HanfordWAJobs #TriCitiesJobs #TriCitiesWAJobs #KennewickWAJobs #YakimaWAJobs #PascoWAJobs #BentonCountyWAJobs #FranklinCountyWAJobs #BudgetReporting