Budget Analyst III

MDW Associates; Edwards Air Force Base (CA); On-site; USD 110,000 - 135,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k)

Job summary

MDW Associates is seeking a Budget Analyst III to support NASA at the Armstrong Flight Research Center, Edwards AFB, California. The role focuses on budget analysis, formulation, and execution for various projects, with data analytics support from SAP and other financial systems.

This full-time on-site position emphasizes financial management and reporting to inform strategic decisions. The analyst will develop automated reporting solutions, deliver data-driven insights, and perform data

Qualifications

• Must possess strong analytical skills to accurately analyze financial data.
• Proficient MS Office Applications including advanced knowledge of Excel and PowerPoint.
• Knowledge of automated financial systems and budgetary report generation.

Responsibilities

• Develop, organize, analyze, and coordinate budget, schedule, and trend information for programs and projects.
• 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 procurements with spending plans.
• Track new commitments, obligations and costs; assess funds availability to cover labor, travel and procurement.

Skills

Analytical skills

MS Office (Excel)

PowerPoint

Education

BA/BS degree

Tools

SAP

SAP BW

Power BI

Power Apps

SQL

Job description

MDW Associates is seeking a Budget Analyst III in support of NASA at the Armstrong Flight Research Center (AFRC), located at Edwards Airforce Base, California. The analyst will provide comprehensive budget analysis, formulation, and execution support for Institutional, Direct, Reimbursable, and Interagency Agreement projects at AFRC, 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.

The Budget Analyst may perform a combination of some or all of the following duties:

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

Required Experience/Skills:

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

Preferred Experience/Skills:

• 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

Education Requirement(s):

• Candidates for this position must possess a BA/BS degree.

Clearance Requirement(s):

• Public Trust - Candidates for this position must be submitted for a background investigation in order to satisfy government requirements.

Company Description

Incorporated in 2012, MDW is a small business headquartered in McClean, VA with employees in various locations in the United States. We provide Federal government clients with consulting, management services, advisory and assistance services, decision support, strategic planning, process planning and improvement, task execution and metrics analysis. Our mission is to make our clients more successful by providing honest assessments, exceptional analysis, prudent advice, direct communication, and hard work.

Our core capabilities include:

• Strategic Planning
• Cost Estimating
• Budget Programming and Justification
• Budget Execution
• Acquisition Management
• Financial Systems Support & Integration

MDW Associates, LLC ("MDW") is an equal opportunity employer and does not discriminate in hiring or employment on the basis of race, religion, color, sex, sexual orientation, gender identity, national origin, age, marital status, covered veteran status, mental or physical disability, pregnancy or any other unlawful basis unrelated to the ability to do the job. MDW seeks to employ talented, ethical, and entrepreneurial-minded persons. Our applicants and employees are protected from discrimination as required by Federal law.

Additional Information

We offer a competitive and comprehensive benefits and compensation package for our employees, including but not limited to:

• Health
• Dental
• Vision
• Group Life Insurance/Long Term Disability/Short Term Disability
• Retirement/401(k)
• Flexible Leave Policy

All information will be kept confidential according to EEO guidelines.