DESCRIPTION: JMA Solutions has an opportunity available for a full-time Financial Analyst supporting the FAA (Federal Aviation Administration). The person in this position will provide financial management support to the ATO Payroll Analysis Team. Provide budget analysis, financial system and data management support, using advanced budgeting tools, financial software, and data analytics platforms relevant to FAA and government budgeting. This position is located in Washington, D.C.

Duties include, but not limited to:

• Classifies, monitors and summarizes financial data for the preparation and submission of reports on a recurring basis
• Provides cost/benefit studies, financial analysis, analysis of alternatives, return on investment, cost estimation, present value, and other analyses in support of capital planning and investment control.
• Using the FAA’s current official financial integrated tool suite, review, monitor, track and analyze payroll financial obligations to identify data irregularities and payroll trends to support budget execution for the current and future fiscal years (FY). Results and methodology of analysis must be documented and delivered in a format agreeable to the FAA
•  Project out-year payroll and staffing impacts for budgetary and fiscal planning, when requested by ATO executive leadership 
•  Develop and maintain predictive financial models and analyses to support pay and staffing strategic and tactical initiatives
• Review and analyze financial reports – payroll projections and staffing levels
• Develop, analyze, and monitor financial metrics/ratios, trend analysis and key performance indicators, forecasting current FY and up to three FY projections, as required by ATO executive leadership and FAA Financial Services 
•  Provide information to requests from FAA-approved users regarding historical payroll reporting and analysis, staffing details, and Human Resources (HR)/legal pay settlement analysis
• Maintain payroll and staffing data to support predictive analysis modeling on pay and staffing projections. The analysis would include the following elements such as data in FAA bargaining unit agreements, voluntary Early Retirement Authority (VERA)/Voluntary Separation Incentive Payment (VSIP), ATO business rules, special payroll and staffing impacts, and normal operational changes on a regular pay period basis
• Analyze pay projections and associated staffing reports on a pay period basis for data issues, trend projections, meeting staffing hiring goals and associated payroll cost and staffing impacts should those fall short
• Provide information to data call requests from FAA payroll and staffing regarding Congress, HR, legal, ATO management, and SUs.
•  Provide information to inquiries/questions in support of payroll and staffing reports and special analysis by customers/FAA-approved users. 
•  Ensure the Historical/Predictive Budget Analyses are accurate and complete, and monthly results are analyzed and compared to benchmarks such as targets, forecasts, and prior year or month. Determine and document variance drivers and explanations. 
•  Using FAA official databases and toolsets, prepare biweekly staffing and monthly pay projection reports that monitor, track, and map staff movements and provide pay and staffing variance analyses. 
• Analyze historical trends and prepare artifacts and financial reports to respond to budget inquiries from the agency’s internal and external stakeholders, as needed. 
• Develop monthly SU briefings for the pay advisors. 
•  Develop and assist in ad hoc briefings and other artifacts in support of the pay advisors. 
•  Extract and query data from various agency systems (e.g., Delphi, Regional Information System (REGIS), Federal Personnel Payroll System (FPPS), Enterprise Data Repository (EDR), and FAA financial tool suite) to provide required data for recurring and ad hoc reports. 

Required Skills • Possess an understanding of the US Congressional, FAA and ATO budgeting processes, including intricacies, key stakeholders, and associated timelines
• Use advanced excel features, including transformation and Power Pivot, predictive analysis tools, Oracle, and SQL
• Proficient in MS Office (Word, Power Point, Excel)
• Strong organization and communication skills 
• Knowledge of FAA Accounting practices, Government appropriation process, or Office of Management and Budgets 300 development support 

EDUCATION: Bachelor's Degree in a business-related subject area such as accounting, finance, or economics. Minimum 3 years work experience is required.

SALARY: $80,000-131,000 depending on experience and education level. JMA offers a full benefits package including vision, health, dental, life insurance, as well as a 401k match. 

JMA Solutions is an equal opportunity/affirmative action employer and does not discriminate against any applicant for employment on the basis of race, color, religion, sex, age, national origin, veteran status or physical impairment