Budget Systems & Automation Analyst

Kaiva Tech, LLC is seeking a Budget Systems & Automation Analyst in
North Bethesda, MD

Hybrid. 2 weeks out of the month require 2 in-office workdays, and the remaining 2 weeks of the month require 3 in-office workdays

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.

• Design, build, and maintain Canvas Power Apps supporting budget execution workflows, data collection, and operational processes.
• Implement modern controls, galleries, containers, and Power Fx 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.
• RPA experience is a plus and may support robotic process automation design or testing.

• 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:

o UFMS (Unified Financial Management System)

o SMART

o FACTS II

o OMB MAX

o HHS Financial Systems

• Support workflows that interface with federal budget execution processes, apportionments, allotments, commitments, obligations, and financial reporting.

• Hands-on experience with Power Apps, 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.

• Prior FDA experience or experience supporting financial operations within HHS components (preferred but not required).
• 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.

• Direct hands-on experience creating and building Canvas Power Apps.
• Must know and understand modern controls, galleries, containers, and Power Fx.
• Must be able to troubleshoot issues.

• Direct hands-on experience creating and building Power Automate workflows.
• Must know and understand expressions and connectors/actions.
• HTML/CSS experience is a plus.
• Must be able to troubleshoot 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.

• Direct hands-on experience managing SharePoint sites.
• Experience creating and updating Lists, Libraries, Site Pages, Calendars, and Microsoft Forms.
• Must understand SharePoint permissions.