Provide cradle to grave (e.g., pre-award to post-award) financial management support for federal client including contract administrative support, spend plan processes, financial management and contract financial execution reporting. Additional work includes analyzing Earned Value Reports from vendors providing services and products to the Government.
Education: BA/BS degree in Business Administration, Math, Accounting, or similar discipline
Duties to include:
Provides financial management expertise supporting large Government procurement programs
Updates, and maintains detailed Excelbased spreadsheets using complex formulas and Visual Basics macros.
Develops measures to ensure planned obligations and expenditures meet targeted objectives, develops and monitors financial or spend plans against actual expenditures, prepares financial reports.
Monitors schedule, obligations, and expenditures in detail by equipment, system, and fiscal year.
Updates and develops financial status reports as required.
Monitors and tracks financial, project, and cost data for incorporation into teamwork plans, data calls, financial addendum, budgetary support documentation, and other financial sheets.
Provides support on fiscal year out-year budget planning, program execution to include development and preparation of funds execution documentation.
Designing and developing spreadsheet type of analysis in a short timeframe
Ability to present multiple funding views of a situation in order to assist the government leads in making a better educated decision/ or way ahead.
3-10 years' experience providing financial management support to DoD procurement programs.
Understand Filtering capabilities within excel
Understand and the ability to write"=If statements"
Understanding and ability to write "=vlookup statements"
Understanding and ability to convert data quickly within the Microsoft Suite
Data loads from external systems.
Ability to filter on needed data within a spreadsheet.
Ability to create and edit existing pivot tables
Ability to create and edit existing line, bar, and pie type charts.
Ability to write and edit "IF" statements.
Ability to write overall equations in excel ( i.e. function calculations like: "sum", ifsum).
Understanding and ability to utilize most Icon tabs within the excel software.
Ability to map back to specific cell references.
Ability to put "checks" into the spreadsheet to validate errors or inconsistences prior to giving files to end users.
Integrity is an Equal Opportunity Employer who is dedicated to hiring and retaining a diverse workforce. We will not discriminate against any applicant or employee for employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender/gender identity, national origin, age, veteran status, disability, or any other protected class.
Integrity Management Consulting