Budget Execution Reporting Support Specialist [PR0060]
Core
Focal point for collecting, reporting, and analyzing budgetary data for the US Department of Energy (DOE) Hanford Site, serving the Richland Operations Office (RL) and Office of River Protection (ORP).
Role type
Budget Execution Reporting Support Specialist
Builds
Monthly, quarterly, semiannual, and annual budget reports and dashboards for DOE stakeholders
Domain
Federal Government / Energy / Budget & Financial Reporting
Deliverable
dashboards & analysis
Required skills
Advanced Excel, Power Query, Power Pivot, Power BI, DAX, Data Warehouse querying, ETL processes, Data visualization
Preferred skills
Microsoft Access, Microsoft Teams, Federal budget execution principles, Hanford Site mission knowledge
Technologies
Microsoft Office (Excel, PowerPoint, Word, Outlook), Power BI, SharePoint, Teams, iPortal, iManage Data Warehouse (IDW)
Responsibilities
Collect and report budgetary data; Retrieve data from various sources including data warehouses; Create and maintain customized BI reports and dashboards; Build and maintain ETL queries and data models; Facilitate training for business team members on BI tools; Coordinate with IT for user permissions
Seniority
Mid-level, hands-on IC