Job Title: Analyst (Prepayment)
Department: Contract Compliance
Reports to: Manager or Director
FLSA Status: Non-Exempt
Pay Range: $27/hr

POSITION SUMMARY:

Using knowledge of contract structures, governing agreements and associated documents, the Contract Analyst reviews vendor invoices and takes exception to out of contract spend, erroneous charges, reviews for and identifies coding errors and assemble supporting documentation for resulting claims. The Contract Analyst works closely with the client’s Accounting Department and Supply Chain staff to aid in the understanding of the identified issues as well as to recommend solutions.

KNOWLEDGE COMPONENTS:

• Proficiency in Microsoft Excel required, knowledge of Microsoft Office Suite preferred
• Ability to demonstrate testing methodology and communicate the inherent/apparent risks.
• Working knowledge of SAP, Oracle or other ERP Software desired.
• Ability to learn Client software and applications as needed.
• Complete understanding of contract forms and complex testing structures
• Pass a proficiency test.

EDUCATION AND/OR EXPERIENCE:

• Bachelor’s degree in Accounting, Finance, Business or Mathematics preferred or;
• Minimum 7-years Contract Compliance, Audit and/or Accounting related experience.

Skills and Abilities:

• Fast paced, real-time transactional job with material effects on client’s Accounts Payable and Supply Chain

processes. Ability to prioritize, assess risks, and stay focused is essential

MINIMUM PRODUCTIVITY REQUIREMENTS

• 40-hour work week (approved overtime, as needed)
• At least minimum standard of established metrics for “invoices per week” must be tested and

dispositioned

• Work paper properly documented at end of each workday
• Rejection support uploaded by EOBD of transacting the rejection.
• Timely completion of periodic reporting as assigned.

KNOWLEDGE COMPONENTS:

Microsoft Word:

• Document Creation: Ability to create, format, and edit professional documents.
• Styles and Formatting: Proficient with using templates, setting up styles, and applying formatting (font, margins, alignment, etc.).
• Advanced Features: Working with features like tables, footnotes, references, track changes, comments, mail merge, and table of contents.
• Collaboration: Familiar with sharing documents, managing version control, and using review features.

Microsoft Excel:

• Basic Features: Familiarity with the user interface, formatting cells, using basic formulas (SUM, AVERAGE, MIN, MAX), and data entry.
• Formulas and Functions: Ability to use intermediate and advanced functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, IF, COUNTIF, SUMIF, and array formulas.
• Data Management: Proficient in sorting, filtering, and organizing large datasets, using tables, and managing data validation rules.
• Charts and Graphs: Able to create and modify charts, graphs, and pivot charts to visually represent data.
• Pivot Tables: Strong understanding of how to create and manipulate pivot tables for data analysis.
• Conditional Formatting: Knowledge of setting up conditional formatting to highlight or categorize data dynamically.
• Data Analysis Tools: Experience with data analysis tools like Solver, Goal Seek, Scenario Manager, and What-If analysis.
• Macros and Automation: Understanding of recording and editing simple macros for repetitive tasks, as well as familiarity with basic VBA (Visual Basic for Applications) to automate processes.
• Advanced Data Functions: Proficient in functions like TEXT, DATE, financial functions (NPV, IRR), and advanced data lookup methods.
• Collaboration Features: Ability to protect sheets, work with shared workbooks, and track changes.

Microsoft Outlook:

• Email Management: Efficient at managing emails, using folders, rules, and categories to organize inboxes.
• Scheduling & Calendar: Proficient in managing calendars, scheduling meetings, setting reminders, and managing invitations.
• Contacts & Tasks: Managing contact lists, delegating tasks, and setting task priorities.

Microsoft Teams:

• Collaboration & Communication: Skilled in chat, video calls, and creating/joining Teams and Channels for projects.
• File Sharing: Proficient in sharing and co-editing documents within Teams.
• Meetings & Integration: Managing online meetings, setting up calls, and integrating with other Office applications like Outlook and OneDrive.

Other Tools:

• OneDrive: Proficient with cloud storage, file sharing, syncing, and collaborating on documents in real- time.
• SharePoint: Ability to navigate team sites, upload files, manage permissions, and work with shared resources.

CPRS, Inc. is an Equal Opportunity Employer

Other duties may be assigned.

• Review invoice details, purchase order or service order details, distinguishing notations, supporting documents, and field tickets. Review for reasonableness, agreement with pricing and mark-up terms, spot check invoiced calculations, and review backup documentation for propriety.
• Review purchase order details and requisition attachments to gain insight into project. Work to fully understand the nature of the project, associated quotes, proposals, etc. as well as governing contract documents and addendums.
• Perform detailed analysis utilizing invoice testing templates against expected outcomes based on project knowledge. Schedule out and review provided invoices to analyze results.
• Review and understand work paper instructional pages/legends and how to use them. Utilize assigned work paper structure, properly document audit program details, status and findings.
• Upload testing work papers and claims/rejection support documents to the appropriate SharePoint folders.
• Record findings in supplemental schedules, document the arguments position and discuss findings with mentor, peer reviewer or Lead Analyst. Ability to demonstrate full understanding of the objectives and outcomes is paramount.
• Perform self-review of documents, tests, and supplemental schedules used to support ‘invoice rejectable assertions,’ paying strict attention to detail and minimizing the need for re-work or recall of incorrect rejections.
• Utilize programs and software of the client to successfully perform the duties of the position and correspond with internal and external Stakeholders in a professional and efficient manner.
• Work with Vendors in a tactful and professional manner to assist in resolving the claim.
• Attend team meetings and participate in a thoughtful and engaging manner. Review and understand meeting minutes and be prepared to discuss any content therein.
• Acquire Supervisor approval for any changes in work schedule or inability to participate in team meetings/discussions/classes in advance of session start times.
• Perform substantive tests and other duties as assigned by Supervisor.
• Maintain compliance with all CPRS policies and procedures.
• Maintain board minutes as assigned by Managers and/or projects.
• Other projects and duties as assigned by Manager, including individual management of Capex Projects, Value Capture compilation support, audit reports etc.
• Ability to perform Audit Protocol Checklist without supervision.
• Perform peer review and mentoring activities as directed.