Data Base Analyst
Title:Data Base Analyst

Task Title: : Office of Claims – Accounts Payable, Commercial Claims, Transportation and Vendor Claims, Employee Claims, and Audits and Reconciliation


Position: Data Base Analyst


DoS Manager: Kevin Pickering, Acting Chief CGFS/F/C/ADR


Task Purpose:

Technical leader with the Department with regard to technical matters, serves as technical lead for reports and reconciliation activities, financial systems analysis and other functional requirements requiring the in-depth technical knowledge of financial operations, automated financial management systems and leadership experience to guide contractor staff. Manages and coordinates the implementation of systems applications within the Office of Claims, through all phases of the system development life cycle, including planning, requirements analysis, design, development and testing, conversion, installation and evaluation. Ensures conformance with work standards and quality. Serves as technical expert for Government financial management.


Minimum/General Requirements:

Ten years of overall relevant professional experience and at -least four years of management or technical leadership experience. Experience in staffing and resource allocation for developing, implementing, and supporting diverse tasks such as development and use of large complex systems. Demonstrated technical, task leadership and communications skills. Experience in analysis of automated financial management systems, in particular those systems supporting Department of State, (Central Financial Management System, Regional Financial Management System, and Treasury reporting systems). Must have a four-year degree from an accredited university or college in accounting or a related field such as computer science or business administration. A Masters degree is preferable. CPA certification or Certified Government Financial Manager (CGFM) is highly desirable.

Senior level, specialized experience (at least six years) supporting requirements, analysis, design, development, testing, and implementation of large Federal financial management/accounting systems similar in size, scope, and complexity to the DoS systems. Must have a four-year degree from an accredited university or college in Accounting or a related field such as computer science or business administration. CPA certification or Certified Government Financial Manager (CGFM) is highly desirable. Specialized, in-depth subject matter experience with Federal accounting and financial management policies, practices, reporting, and operations is desirable and may be substituted for technical experience; demonstrated capability to analyze complex financial systems requirements, problems and issues; and develop, communicate, and implement cost-effective solutions to the Department's requirements. The Department prefers candidates that have experience with DoS financial systems, both internal and external, DoS accounting practices and Treasury reporting processes and requirements.



Functional Responsibility:

  • Generate regular reports for Weekly Production, Daily Inventory Overview, Daily Inventory Breakdown, Daily Inventory Charts, Certification History, VC Voucher Examiner Production, Invoices against Expiring Funds, Invoices without Corresponding Payments, Unsubmitted Rejected Invoices, Vendor Claims Turnaround Time, ITCOM Inventory, Passport Refund Reconciliation and SPS Database/Treasury/GFMS reconciliation.


  • Support Access databases for VC & EC Workload Management, VC &EC Assignments, Claims Dashboard, Certification History, Improper Payments, Fax Server Production and Reporting, Collections, Check Cancellations, SPS Payments, Expiring Funds, Passport Refunds, SPS Reconciliation, ITCOM Invoices, Missing Invoices with System Errors, Mailbox Team Review.


  • Support users with GFMS and Access Database issues.


  • Ad hoc reports as requested from GS Personnel


    Software Systems Utilized:

    GFMS, RFMS, Data Warehouse, Microsoft Access, Microsoft Excel


    Period of Performance:

    The contractor employee will work an 8 hour shift between the hours of 6:15 am to 6:15 pm with a non-compensated 45-minute lunch (See your Project Manager for work schedule and department policies). Additional hours may be required and must be authorized by your Project Manager and DoS Management.


    Security Requirements:

    All personnel provided under this task order must be able to either possess or obtain a security clearance of “Secret” to be issued by Department of State, Diplomatic Security.


    Formal Job-Specific Training Requirements:

    1. Training, FSI GFS10 (Reading and Understanding Fiscal Data)


This opening is closed and is no longer accepting applications
Powered by ApplicantStack