Edgewater Technical Associates is seeking qualified candidates for a Budget and Finance Systems Support opportunity in Richland, WA to support DOE Hanford.

Organization: AMB

Work Location: Work shall be conducted at the Department of Energy government offices, The Hanford Site, and Richland, WA.

SCOPE OF WORK
The United States Department of Energy (DOE), Hanford Site, Budget (BUD), and Finance (FIN) Divisions, require general support services for approximately 60% supporting BUD and 40% supporting FIN.

May provide business systems support in the following areas:
Data Model Development and Optimization:
Build, optimize, and maintain multiple data models within Power BI. These models will serve as the foundation for insightful reporting and analysis.
Leverage best practices to ensure efficient data modeling, including schema design, relationships, and performance optimization.
Data Integration and Transformation:
Extract data from various sources, including department data warehouses, Excel spreadsheets, SharePoint, and Access databases.
Transform and cleanse the data to ensure consistency, accuracy, and relevance.
Integrate the transformed data seamlessly into our Power BI models.
Custom Measures for Complex Reporting:
Develop custom measures using DAX (Data Analysis Expressions) to address complex reporting requirements.
These measures will empower users to analyze data from different angles, uncover trends, and make informed decisions.
Documentation and Knowledge Transfer:
Regularly update a comprehensive desk guide that outlines step-by-step procedures for data modeling, report creation, and system maintenance.
Ensure that colleagues can follow these instructions independently, promoting self-sufficiency.
Collaboration with IT and User Permissions:
Coordinate with our Information Technology (IT) departments to streamline user permissions and access controls.
Coordinate with contractors’ IT departments to resolve issues with Power BI
Facilitate smooth interactions between business users and IT teams to ensure data security and compliance.
Customized Reports and Dashboards:
Create and maintain customized reports using Business Intelligence (BI) software, tailored to specific user needs.
Visualize data effectively through interactive dashboards, charts, and graphs.
Design visualizations in Power BI by incorporating external Microsoft Excel data into Power BI and transforming the data into Power BI data models
Forms and Apps for Data Entry:
Develop Microsoft Forms and Power Apps to simplify data entry processes.
Enhance user experience by providing intuitive interfaces for data collection.
Training and Capacity Building:
Train Finance and Budget division staff in data analytics tools, emphasizing best practices and efficient workflows.
Train Finance and Budget division staff on Power BI desktop and Power BI service capabilities
Provide short trainings during Finance and Budget division weekly staff meetings on Microsoft tools such as Power BI, SharePoint, Outlook, etc.
Foster a data-driven culture within our team.
Data Integrity and Collaboration:
Collaborate with other offices to improve data collection methods, reporting accuracy, and overall data integrity.
Identify opportunities for cross-functional collaboration and knowledge sharing.
Assist in the creation of SharePoint sites for Finance

Support Deliverables:
Daily Report (beginning of day). Extract and upload Standard Accounting & Reporting System (STARS) data into a master data file, check for new records, and update Business Intelligence (BI) analyses to ensure new records are coded correctly. Update Power Pivot lookup and fact tables. Notify users when finished.
Monthly Report (end of month). Populate various tables, charts, and dashboards.
Monthly Report (after all end-of-month STARS data is final). Populate various tables, charts, and dashboards.
Monthly Report (normally by the 10th calendar day). Report obligation and cost variances to HQ. Secure approval from appropriate DOE officials before releasing.
Monthly Report (by the last Wednesday of the month preceding the first Monday of the next month). Budget presentations in PowerPoint and SharePoint. Secure approval from appropriate DOE officials before releasing.
Monthly Execution Summary to HQ (within 3 business days of receipt from DOE). Validate and reconcile information from HQ, and submit correct data and narratives to HQ. Secure approval from appropriate DOE officials before releasing.
Quarterly Site Executive Summary to HQ (within 3 business days of receipt from DOE). Validate and reconcile draft information from HQ, and submit correct data and narratives to HQ. Secure approval from appropriate DOE officials before releasing.
Annual Report (by October 31). Budget Execution Review, in PowerPoint, to HQ DOE. Semiannual reports of a similar nature are occasionally required. Secure approval from appropriate DOE officials before releasing.
Semiannual Manual (within 6 months of contract award and every 6 months thereafter). Publish and update a user manual to help employees: (1) understand the Power Pivot data schema, (2) understand how to navigate and display data, (3) report using Power Query, Power Pivot, Power BI, SharePoint, and Teams, and (4) learn useful tips and tricks how to use Power Pivot, Power BI, SharePoint, and Teams more effectively.
Weekly Report. This report will address work accomplished, and deliverable progress to be provided to the technical point of contact.
Monthly Report. This report will be a combination of the weekly status reports and shall be submitted with the monthly invoice. The report shall also include;
Deliverable progress, and date(s) submitted if applicable, submitted within this invoice period.
Work schedule for Contractor employees, to include any leave taken.

MINIMUM QUALIFICATIONS REQUIRED
High school degree or higher education
Skill levels identified below are defined as:
Basic: Active involvement involving manipulation of data and presentation of information for at least 6-months
Intermediate: Active involvement involving manipulation of data and presentation of information for at least 12-months
Advanced: Professional involvement involving manipulation of data and presentation of information for at least 36-months
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
Intermediate skill level in SharePoint,
U.S. Citizenship

PREFERRED EXPERIENCE
Excellent reading, writing, and speaking communications skills
Ability to perform multiple tasks with dynamic priorities independently
Experience in maintaining databases in Microsoft Access or similar software
Experience with Teams
Knowledge of Federal Government and DOE budget execution principles and budget/financial systems
Knowledge of Hanford Site mission, activities, and priorities preferred

Compensation
Salary is commensurate with education and experience and may range between $24.38 to $50.00 per hour.

Edgewater is committed to recruiting and maintaining a staff of highly skilled professionals to support our customers. In keeping with this objective, we offer highly competitive salaries and employee benefit packages structured to best suit your needs. We offer multiple individual and family benefit options including paid time off, medical, dental, life, vision, and disability insurance, and a pre-tax 401 (k) retirement account with Company matching contributions and 100% vesting for eligible participants beginning DAY 1.

If you are interested in being considered for this position and your resume clearly outlines your relevant experience for this position, please follow the application steps via our website: www.edgewatertech.net/careers

Edgewater will not submit your resume without first having detailed discussions with you and obtaining your permission to do so. We look forward to hearing from you!

WORKING WITH EDGEWATER TECHNICAL ASSOCIATES
Founded in 2003, Edgewater Technical Associates (Edgewater) is a professional and technical services firm supporting the U.S. Department of Energy and the U.S., U.K., and Canadian Commercial Nuclear Industry, and private sector businesses involved in high-hazard or complex operations. Edgewater proudly offers expertise in numerous technical disciplines necessary to support operational environments where Integrated Safety Management and formal, disciplined operations are essential to ensure safety, quality, security, and regulatory compliance.

Edgewater is committed to recruiting and maintaining a staff of highly skilled professionals to support our customers. In keeping with this objective, we offer highly competitive salaries and employee benefit packages structured to best suit your needs. We offer multiple individual and family benefit options including paid time off, medical, dental, life, vision, and disability insurance, and a pre-tax 401 (k) retirement account with Company matching contributions and 100% vesting for eligible participants beginning DAY 1.

EQUAL OPPORTUNITY EMPLOYER
Edgewater is an equal opportunity employer and all qualified applicants will be considered for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, protected Veterans, or individuals with disabilities.

View all Edgewater opportunities at www.edgewatertech.net/careers