Budget & Finance Systems Support - US Citizens

3 days ago

Richland, United States BTI Services Full time

Business Technology Integrators (BTI) in Upper Marlboro, MD is seeking a Budget & Finance Systems Support for Long Term Contract with Dept. of Energy in Richland WA.

SCOPE OF WORK The United States Department of Energy (DOE), Hanford Site, Budget (BUD) and Finance (FIN) Divisions, are in need of business systems support. It is anticipated that the candidate will spend approximately 60% of work hours supporting Budget and 40% supporting Finance.
The candidate shall provide business systems support including, but not limited to the following:
  • 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. o 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 o 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. o 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. o 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. o Assist in the creation of SharePoint sites for Finance
 
              DELIVERABLES  
Work products shall be thorough, accurate, appropriately documented, and comply with established criteria. The Candidate will perform duties in a competent and professional manner that meets milestones/delivery schedules as outlined below.
 
  • Daily Report (beginning of day). Extract and upload Standard Accounting & Reporting System (STARS) data into 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 official 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 official before releasing.
  • Monthly Execution Summary to HQ (within 3-business days of receipt from DOE).
Validate and reconcile information from HQ, submit correct data and narratives to HQ.
Secure approval from appropriate DOE official before releasing.
  • Quarterly Site Executive Summary to HQ (within 3-business days of receipt from DOE). Validate and reconcile draft information from HQ, submit correct data and narratives to HQ. Secure approval from appropriate DOE official 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 official before releasing.
  • . 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.
MINIMUM QUALIFICATIONS REQUIRED  The candidate shall demonstrate: 
  • 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,
 
PREFERRED EXPERIENCE
 
  • 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 
  • 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
  OTHER REQUIREMENTS  
  • Must be a U.S. Citizen.
  

  • US Tech Solutions | Technical Support Specialist III

    1 week ago

    richland, United States US Tech Solutions Full time

    Duration: 12 MonthsJob Description:Under minimal supervision, provide day-to-day administrative and technical support of a highly complex nature to the Accounting & Budgets Director, direct reports, and associated nuclear projects personnel. Perform advanced, diversified, and confidential technical duties and special projects. Act in a leadership role and...

  • Budget and Financial Systems Specialist

    3 weeks ago

    Richland, Washington, United States BTI Full time

    Job OverviewWe are seeking a highly skilled Budget and Financial Systems Support specialist to join our team at BTI in Upper Marlboro, MD. This is a long-term contract opportunity with the Department of Energy in Richland, WA.

  • US Tech Solutions | Earned Value Management System Analyst | richland, wa

    2 months ago

    richland, United States US Tech Solutions Full time

    Location: Richland, WA 99354(Hybrid: 50% Remote work)Duration: 06 MonthsDescription:Provide subject matter expertise in the areas of Earned Value Management (EVM) and Project controls best practices. Promote sound business decisions and best practices in the areas of planning, scheduling, budgeting, financial analysis, schedule/cost control, and effective...

  • Technical Support Specialist III

    1 week ago

    Richland, United States US Tech Solutions Full time

    Duration: 12 MonthsJob Description:Under minimal supervision, provide day-to-day administrative and technical support of a highly complex nature to the Accounting & Budgets Director, direct reports, and associated nuclear projects personnel. Perform advanced, diversified, and confidential technical duties and special projects. Act in a leadership role and...

  • Technical Support Specialist III

    7 days ago

    Richland, United States US Tech Solutions Full time

    Duration: 12 MonthsJob Description:Under minimal supervision, provide day-to-day administrative and technical support of a highly complex nature to the Accounting & Budgets Director, direct reports, and associated nuclear projects personnel. Perform advanced, diversified, and confidential technical duties and special projects. Act in a leadership role and...

  • Finance Technical Support Specialist

    12 hours ago

    Richland, United States ACS Professional Staffing Full time

    Overview: ACS Professional Staffing is looking for an employee to work on-site with our client. This Finance Technical Support Specialist role will provide day-to-day administrative and technical support of a highly complex nature to the Accounting & Budgets Director, their direct reports, and associated nuclear projects personnel. This position will perform...

  • Earned Value Management System Analyst

    2 months ago

    Richland, United States US Tech Solutions Full time

    Location: Richland, WA 99354(Hybrid: 50% Remote work)Duration: 06 MonthsDescription:Provide subject matter expertise in the areas of Earned Value Management (EVM) and Project controls best practices. Promote sound business decisions and best practices in the areas of planning, scheduling, budgeting, financial analysis, schedule/cost control, and effective...

  • Finance Technical Support Specialist

    12 hours ago

    Richland, United States ACS Professional Staffing Full time

    Overview: ACS Professional Staffing is looking for an employee to work on-site with our client. This Finance Technical Support Specialist position, under minimal supervision, will provide day-to-day administrative and technical support of a highly complex nature to the Nuclear Projects General Manager, direct reports, and associated nuclear projects...

  • Technical Support Specialist III

    6 days ago

    Richland, United States Volt Full time

    Volt is immediately hiring for Technical Support Specialist III - Finance in Richland, WA Position type: Full-time, ContractDuration :12+ Months Location: Richland, WA

  • EVM System Analyst

    12 hours ago

    Richland, United States ACS Professional Staffing Full time

    Overview: ACS Professional Staffing is looking for an employee to work hybrid with our client. This EVM System Analyst position will provide subject matter expertise in Earned Value Management (EVM) and Project Controls best practices. Responsibilities include supporting planning, scheduling, budgeting, financial analysis, cost control, and risk management....

  • Data Analyst and Reporting Expert

    3 weeks ago

    Richland, Washington, United States BTI Full time

    About the JobIn this role, you will provide business systems support for the Budget and Finance Divisions of the United States Department of Energy (DOE), Hanford Site. You will spend approximately 60% of your time supporting Budget and 40% supporting Finance.

  • EVM System Analyst

    2 weeks ago

    Richland, United States Automation and Control Strategies Group, INC. dba ACS Professional Staffing Full time

    Location: Richland, Washington Type: Contract Job #8000 Overview: ACS Professional Staffing is looking for an employee to work hybrid with our client. This EVM System Analyst position will provide subject matter expertise in Earned Value Management (EVM) and Project Controls best practices. Responsibilities include supporting planning, scheduling, budgeting,...

  • Administrative Finance Director for Complex Projects

    2 weeks ago

    Richland, Washington, United States Volt Full time

    Job DescriptionVolt is currently seeking an experienced Administrative Finance Director to join our team in Richland, WA. This is a full-time contract position that requires a minimum of 5 years of progressive administrative experience, including leadership responsibilities and independent decision-making authority.Salary and BenefitsThe salary for this...

  • IS Computer Support Technician

    1 month ago

    Richland, United States US Tech Solutions Full time

    Duration: 06 Months Job Description:Under general supervision from peers and management, this position is responsible for providing support to the workstation deployment project, performing inventory, imaging new machines for deployment to customers, supporting return of computers that have met lifecycles, including readying devices for e-waste disposal...

  • Administrative/Technical Support Specialist III

    4 days ago

    Richland, United States US Tech Solutions Full time

    Duration: 12 Months ContractDescription:Under minimal supervision, provide day-to-day administrative and technical support of a highly complex nature to the Nuclear Projects GM, direct reports, and associated nuclear projects personnel. Perform advanced, diversified, and confidential technical duties and special projects. Act in a leadership role and provide...

  • Administrative/Technical Support Specialist III

    4 days ago

    Richland, United States US Tech Solutions Full time

    Duration: 12 Months ContractDescription:Under minimal supervision, provide day-to-day administrative and technical support of a highly complex nature to the Nuclear Projects GM, direct reports, and associated nuclear projects personnel. Perform advanced, diversified, and confidential technical duties and special projects. Act in a leadership role and provide...

  • Senior Farm Finance Specialist

    3 weeks ago

    Richland, Washington, United States Rabobank Full time

    About the JobWe are looking for a skilled Senior Farm Finance Specialist to join our team at Rabobank. In this role, you will play a key part in developing and maintaining relationships with farmers and producers in the US.Responsibilities:Work closely with clients to understand their business needs and develop solutions that meet those needs.Collaborate...

  • Financial Management Specialist

    2 weeks ago

    Richland, Washington, United States US Tech Solutions Full time

    About the RoleUS Tech Solutions is seeking a skilled Financial Management Specialist to join our team. In this role, you will be responsible for providing subject matter expertise in Earned Value Management (EVM) and Project controls best practices.Key ResponsibilitiesLead the development, coordination, tracking, and execution of Capital and O&M projects...

  • Financial Project Manager with EVM Expertise

    1 month ago

    Richland, Washington, United States US Tech Solutions Full time

    About the RoleWe are seeking a skilled Financial Project Manager to join our team at US Tech Solutions. This individual will be responsible for providing subject matter expertise in Earned Value Management (EVM) and project controls best practices.Key Responsibilities:Lead the development, coordination, tracking, and execution of project controls...

  • Budgeting and Financial Reporting Professional

    1 week ago

    Richland, Washington, United States BTI Full time

    Key ResponsibilitiesThe Financial Systems Support Expert will be responsible for:Data Model Development: Building, optimizing, and maintaining multiple data models within Power BI to serve as the foundation for insightful reporting and analysis.Data Integration and Transformation: Extracting data from various sources, transforming and cleansing it, and...