Budget Systems & Automation Analyst

Kaiva Tech•North Bethesda, MD

8d•Hybrid

About The Position

The Budget Systems & Automation Analyst serves as a technical and analytical specialist within the Division of Budget Execution and Control (DBEC). The incumbent supports budget execution operations by developing automated solutions, enhancing financial systems workflows, maintaining reporting tools, and administering collaboration platforms. This role blends federal financial management knowledge with modern automation technologies to strengthen operational efficiency, data accuracy, and reporting capabilities across the Office of Budget.

Requirements

Hands-on experience with PowerApps, Power Automate, Power BI, and SharePoint.
Understanding of federal financial workflows, budget execution processes, and government financial systems.
Ability to interpret and apply technical documentation.
Proficiency in Excel modeling and analytics.
Strong problem-solving skills and ability to troubleshoot technical issues.
Excellent communication skills and ability to collaborate with technical and non-technical stakeholders.
Ability to manage multiple priorities in a fast-paced environment.
Direct hands-on experience creating and building Canvas PowerApps.
Must know and understand modern controls, galleries, containers, and PowerFx.
Must be able to troubleshoot Power Platform issues.
Direct hands-on experience creating and building Power Automate workflows.
Must know and understand expressions and connectors/actions.
Must be able to troubleshoot Power Automate issues.
Direct hands-on experience creating and building Power BI dashboards.
Must be familiar with DAX, M Code, paginated reports, subscriptions, data modeling, and Row-Level Security (RLS).
Data analytics skills including Pivot Tables, building robust and complex formulas, creating charts, and other visuals in Excel.
Direct hands-on experience managing SharePoint sites.
Experience creating and updating Lists, Libraries, Site Pages, Calendars, and Microsoft Forms.
Must understand SharePoint permissions.
Must possess the ability to interpret technical documents, including Process Design Documents (PDDs), Technical Design Documents (TDDs), and Technical User Guides.

Nice To Haves

Prior FDA experience or experience supporting financial operations within HHS components.
Experience with federal financial systems such as UFMS, SMART, or other agency-specific execution tools.
Experience with RPA tools (UiPath, Power Automate Desktop, etc.).
Experience with SQL, APIs, or enterprise data integration.
HTML/CSS experience is a plus.
RPA experience is a bonus.

Responsibilities

Design, build, and maintain Canvas PowerApps supporting budget execution workflows, data collection, and operational processes.
Implement modern controls, galleries, containers, and PowerFx logic for scalable, user-friendly applications.
Develop and manage Power Automate workflows to streamline approvals, notifications, data movement, and cross-system integration.
Troubleshoot Power Platform issues and enhance existing solutions based on evolving mission needs.
Build and maintain Power BI dashboards, paginated reports, and data models for budget execution monitoring and leadership reporting.
Write and optimize DAX and M code for complex calculations and transformations.
Implement Row-Level Security (RLS) and manage subscriptions to ensure secure report distribution.
Perform advanced Excel analytics, including pivot tables, modeling, and visualization.
Administer SharePoint sites supporting DBEC operations, ensuring proper structure, permissions, and content governance.
Create and update Lists, Libraries, Site Pages, Calendars, and Microsoft Forms.
Ensure SharePoint permissions are configured to maintain data integrity and access control.
Review and interpret Process Design Documents (PDDs), Technical Design Documents (TDDs), and User Guides.
Support integration between budget execution tools, SharePoint, Power Platform, and enterprise financial systems.
Provide subject matter expertise on financial automation and digital modernization initiatives.
Collaborate with DBEC analysts to understand operational needs and translate them into technical requirements.
Support data validation, reconciliation, and quality assurance activities related to budget execution systems.
Apply knowledge of federal financial systems such as: UFMS (Unified Financial Management System), SMART, FACTS II, OMB MAX, HHS Financial Systems.
Support workflows that interface with federal budget execution processes, apportionments, allotments, commitments, obligations, and financial reporting.