Budget Execution Reporting Support Specialist

Budget Execution Reporting Support SpecialistProSidian 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 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 informationFacilitate usage, and provide training, for Power Query, Power Pivot, Power BI, SharePoint, and Teams to business team members and other key individualsCoordinate with Information Technology (IT) departments to facilitate user permissionsRetrieve data from various sources, including DOE's iManage Data Warehouse (IDW) thru iPortal and various Excel (or other) files from DOE employees and contractorsCreate and maintain customized reports using Business Intelligence (BI) software available on iPortalUse 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 dashboardsCoordinate with Information Technology (IT) departments to facilitate user permissions and streamlined servicesThe 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.The Budget Execution Reporting Support Specialist shall demonstrate:High school degree or higher educationAdvanced skill level in ExcelIntermediate skill level with Power Query, Power Pivot, and Power BI, including the extensive use of DAX languageIntermediate skill level PowerPointIntermediate skill level with WordIntermediate experience in data mining from large data warehouse(s)Basic skill level in OutlookBasic skill level in SharePoint,Excellent reading, writing, and speaking communications skillsAbility to perform multiple tasks with dynamic priorities independentlyExperience of maintaining databases in Microsoft Access or similar software preferredExperience with Teams preferredKnowledge of Federal Government and DOE budget execution principles and budget/financial systems preferredKnowledge of Hanford Site mission, activities and priorities preferredMust 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.