Business Analyst - Audit, Distribution and Reconciliation

---

Job description

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

Position: Audit, Distribution and Reporting [ADR] Business Process Analyst

DoS Manager: Olufunke Olusesi, Manager Audit, Distribution and Reporting

Task Purpose: The Bureau of the Comptroller and Global Financial Services (CGFS), Department of State (DoS), Charleston, SC requires the contractor to provide Business Process Analyst support services in the Office of Claims. The Office of Claims conducts the Department's Accounts Payable functions as the central domestic funded paying agent of the Department, and includes three financial divisions: Audit, Distribution and Reporting (ADR), Vendor Claims(VC) and Employee Claims(EC). This position is located in the Audit, Distribution, and Reconciliation Branch reporting to ADR Manager, Olufunke Olusesi.

Minimum/General Requirements:

• 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 Manger (CGFM) is highly desirable.
• Eight years of overall relevant professional experience and at least four years of management or technical leadership experience.
• Experience in 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).
• Experience managing and coordinating the implementation of systems applications through all phases of the system development life cycle, including planning, requirements analysis, design, development, testing, conversion, installation, and evaluation.
• Ensures conformance with work standards and quality. Serves as technical expert for the Government financial information management.

Functional Responsibility:
The dynamics have changed within ADR as we move away from manual processes which required entry-level knowledge to more efficient processes such as automation, form imports and the use of RPA bots. The business requirements now require a more in-depth knowledge of accounting and the ability to analyze data quickly and thoroughly down to the posting logic. We are starting to transition into a more analytical workforce that can analyze data on the reports, understand where the data comes from and how it is compiled. To better serve our client, the selected applicant will need to understand at its basic complicated level how the reports work, what their purpose is and how to best use them. As we go into an era where business intelligence software is starting to prevail, such as GBI, and Power BI; more technical positions are needed to run, understand the software and find ways to use it as a tool for ADR, GFO and DoS as a whole

The Business Process Analyst will be expected to run reports, keep up established metrics, and analyze data. They will also be expected to become the SME for all the reports, business intelligence software, financial management policies, practices, and operations so that they can incorporate the client's requirements more effectively and withing policy. They must have demonstrated ability to analyze complex financial systems requirements and problem-solving abilities. This consultant is expected to recommend, develop, present, and implement cost-effective solutions to the Department's requirements. The following are specific examples of expected tasks for this position.

• Generate regular and ADHOC 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.

To be successful in this position you will need:

• Acquired in-depth knowledge of Claims (ADR, VMT, EC and VC) Internal Business processes and ability to learn and apply new ones quickly into our proprietary databases and reports.
• Effective communication with all levels (Colleagues, shareholders, and upper Management); ability to create rapport and ask the right questions to gather Client's requirements; able to convey difficult terms and processes in an easy-to-understand language and terminology.
• Power BI: Design, develop and implement and maintain Power BI workspaces and reports to include securities and embedding.
• Power Bi Visualizations: Charts, Matrix, Cards and Key Performance Indicators.
• M and Transact-SQL languages, Data Analysis Expressions (DAX) functions and operators to build formulas and expressions in Power BI.
• Visual Basic for Applications.
• Access: Ability to gather requirements to properly design, create, implement and maintain Access Databases and Forms.
• Data Modeling.
• ETL process (Extract, Transformation and Loading).
• Prepare data sources, and update Power Reports and databases from feeder systems such as Global BI and our accounting system (GFMS)..
• Proficiency in Excel

Period of Performance:
The contractor employee will work an 8-hour shift between the hours of 6:30 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".

Haynes, Inc is an Equal Opportunity Employer. We do not discriminate against any employee or applicant for employment because of race, color, religion, gender, national origin, age, marital status, disability, veteran status, sexual orientation, or other protected status in any of the terms or conditions of employment.

This position is for support of a government contract, which requires that all employees are fully vaccinated for COVID before beginning work.