Budget Analyst III

MDW Associates•Edwards AFB, CA

12d•$72,000 - $87,000•Onsite

About The Position

MDW Associates is seeking a Budget Analyst III to provide comprehensive budget analysis, formulation, and execution support for NASA at the Armstrong Flight Research Center (AFRC), located at Edwards Airforce Base, California. This role will support Institutional, Direct, Reimbursable, and Interagency Agreement projects, including associated financial activities. The analyst will deliver data analytics support by analyzing financial data from SAP, the Core Financial System, and other financial tools, as well as developing automated reporting solutions. The analyst will generate data-driven insights to inform financial management and strategic decision-making while performing data transformation across multiple budgetary resources. This position is fully on-site at Edwards Airforce Base.

Requirements

Must possess strong analytical skills to accurately analyze financial data using advanced tools and processes.
Proficient MS Office Applications including advanced knowledge of Excel and PowerPoint.
A knowledge & understanding of automated financial systems and budgetary report generation.
BA/BS degree.
Public Trust - Candidates for this position must be submitted for a background investigation in order to satisfy government requirements.

Nice To Haves

Budget Formulation Process (PPBE)
Budget Execution and Analysis
Appropriation Law
SAP and Business Warehouse Software
Advanced Microsoft Excel (e.g. pivot table)
Federal Acquisition Regulation (FAR) knowledge and procurement lead-times
Advanced Business Analytics Tools
Advanced skills in Data Transformation
Experience with Government accounting systems and policies to manage automated systems and financial information
Experience with Data Analytic tools and software such as Power Apps, Power BI, SQL, etc.
Excellent mentoring and strategic thinking skills
Strong writing and oral communication skills

Responsibilities

Develop, organize, analyze, and coordinate budget, WBS, schedule, trend analysis and milestone information for programs and projects and/or performing organizations/cost centers.
Reimbursable Agreement Processing through the Inter Agency Agreements process using PAM, AERP, and G-Invoicing.
Develop and maintain budget/workforce activity sheets, including change explanations.
Maintain and monitor contract funding and contract costing within programmatic areas.
Gather information to track and submit PRs and SRs. Review and reconcile procurements with spending plans.
Track new commitments, obligations and costs on a regular basis, assess funds availability to cover anticipated labor, travel and procurement and address any shortfalls.
Independently monitor and perform maintenance of budget and guideline information, workforce levels and insure reconciliation in the financial systems (SAP, BOBJ, etc.).
Provide project status and variance explanations for Program, Projects, and Center reviews, including but not limited to the monthly CFO Review, project reviews, and ad hoc requests.
Prepare and present variance explanation data during CFO programmatic review as required.
Review FTE utilization and address discrepancies & update FTE labor plan versus actuals and review FTE charging compared to the plan.
Respond to quarterly data calls & ad hoc requests.
Funds certify travel authorizations and vouchers in the Concur.gov e-travel system.
Develop, analyze, and report against monthly phasing plans (e.g., commitment, obligations, costs, and potentially disbursements) as well as comparative analysis against agency metrics.
Prepare Center, Program and Project reports and information for reconciliation and justification of project budget and workforce requirements.
Formulate as required, consolidated 5-year budget plans in support of the Agency PPBE Cycle.
Regularly report project status to Lead and/or Senior Analysts, Program Managers, Project Management teams as required, and the CFO.
Create and maintain work breakdown structure (WBS), consistent with Agency policy.
Determine yearly fiscal budget and workforce requirement, consistent with project schedule and technical requirements.
Serves as a mentor and resource for other contract support to assist with their development.
Serves as mentor and resource for analysts when working with data analytic tools.
May leverage expertise to support multiple Organizations and/or Centers.
Proficient in the accounting systems and processes of the Centers supported.
Provide business analytic capability to track major mission and technical milestones.
Utilizes a wide range of subject matter practices, laws, regulations, policies, and precedents and uses a range of analytical methods to identify, evaluate, and recommend appropriate solutions.
Data visualization of budget plan versus actuals.
Provides written and oral communication techniques sufficient to develop and deliver briefings, project papers, status reports, training documentation and correspondence to managers to foster understanding.
Conduct financial forecasting and modeling.
Create custom SAP business analytics and reporting solutions.
Research and apply a wide range of qualitative and/or quantitative methods to identify, assess, analyze, and improve products and services.
Analyze financial workflows and system utilization patterns.
Identify opportunities for process improvement based on systems' data.
Develop interfaces between SAP, Core Financial Systems, iBOT, and other OCFO financial tools.
Collaborate with OCFO staff, budget analysts, and financial managers.
Provide technical guidance on financial business analytics methodologies.
Document analytical processes.
Support continuous improvement of financial analyses.
Participate in working groups and group meetings.
Establish goals and plans that meet objectives.