MSP/VMS Analyst

Workwell

San Diego (CA)

Hybrid

USD 70,000 - 75,000

Full time

9 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Workwell North America in San Diego seeks an MSP/VMS Analyst to support account reconciliations across VMS, MSP and ATS platforms. You will manage high‑volume transactional data, maintain data integrity, and resolve billing discrepancies promptly while coordinating with branches and the Payroll Team.

The successful candidate has 2–5 years of detail‑oriented accounting or data analysis experience, advanced Excel skills (PivotTables, VLOOKUP/XLOOKUP, validation), and strong communication.

Qualifications

  • 2-5 years working in a highly detail-oriented role focused on accounting, data analysis, or AR/AP reconciliation.
  • Strong attention to detail, organization, and analytical skills.
  • Advanced level proficiency in Microsoft Excel (PivotTables, VLOOKUP/XLOOKUP, data validation).
  • Strong verbal and written communication skills.

Responsibilities

  • Run reports across multiple systems to gather and audit data.
  • Manage high-volume transactional data with strict accuracy and deadlines.
  • Reconcile and analyze data for payments to suppliers/vendors.
  • Compare ATS and VMS transactions weekly to ensure data integrity.
  • AP/AR research and reconciliation across systems.
  • Upload AP/AR invoices into ERP system and track aging.
  • Collaborate with branches and Payroll on outstanding issues.

Skills

Excel proficiency
Data analysis
AP/AR reconciliation
Communication
Attention to detail

Tools

PivotTables
VLOOKUP/XLOOKUP
ERP systems
Sage Intacct

Job description

The MSP/VMS Analyst plays a critical role in supporting account reconciliations for our growing MSP business. This position is responsible for managing multiple accounts while ensuring the accuracy and integrity of data entered into and processed through VMS, MSP, and ATS platforms. Success in this role requires advanced Excel proficiency, strong AP/AR research and reconciliation experience across multiple systems, the ability to maintain minimal to no variances in comparison reporting, and a proactive approach to resolving billing issues and discrepancies in a timely manner.

Responsibilities
  • Work within multiple technologies/systems to run reports, gather, and audit data
  • Manage high-volume transactional data while maintaining strict accuracy and meeting critical deadlines
  • Reconcile and analyze data pulled to assist payment files for suppliers/vendors.
  • Analyze and compare weekly transactions from our Applicant Tracking System (ATS) to the VMS system
  • AP/AR research and reconciliation across multiple systems
  • Confirm and upload AP/AR Invoices into the company’s accounting/ ERP system
  • Communicate with branches and Payroll Team regarding outstanding issues and follow up for resolution
  • Partner with Workwell North America collections team to ensure payment receipt
  • Help the Cash Application team determine how cash received should be applied to related Vendor Management System (VMS) invoices on a temp by temp and invoice basis
  • Maintain and modify VMS tools in excel for new & existing VMS customers.
  • Maintain and add new client contracts of related VMS clients to contracts and ATS database
  • Monitor and ensure compliance with client-specific billing requirements, invoice procedures, and contractual terms
  • Identify, investigate, and resolve invoice discrepancies, payment variances, and system integration issues
  • Perform regular audits of VMS, ATS, and ERP data to ensure accuracy, completeness, and compliance
  • Generate and distribute recurring financial, operational, and reconciliation reports to leadership and stakeholders
  • Track supplier/vendor payment statuses and elevate aging balances or unresolved discrepancies as needed
  • Support special projects that would assist Operations, Payroll, and Finance and Accounting
  • Collaborate with multiple stakeholders to facilitate problem solving, reconciliation, process creation/improvement, etc.
  • Analyze trends, identify process gaps, and recommend workflow improvements to increase efficiency and reduce discrepancies
Knowledge, Skills, And Attributes
  • 2 - 5 years working in a highly detail-oriented role, focusing on accounting, bookkeeping, data analysis, accounts receivable analysis, or other similar type of position
  • Strong attention to detail, emphasis on organization, and analytical skills
  • Advanced level proficiency in Microsoft Excel (including PivotTables, VLOOKUP/XLOOKUP, formulas, and data validation)
  • Strong verbal and written communication skills
  • Dedication to completing all tasks with accuracy
  • Strong emphasis on process
  • Ability to solve problems and identify solutions quickly and effectively
  • Adaptability and ability to shift priorities quickly
Work Environment and Physical Demands
  • Professional office environment. This role routinely uses standard office equipment including, but not limited to, computers, phones, photocopiers, filing cabinets and fax machines.
  • While performing the duties of this job, the employee is regularly required to engage in professional and interpersonal written and verbal communications with a wide variety of individuals including employees, customers, vendors, managers and others.
  • In accordance with the requirements of a typical office work environment, the employee will be required to attend meetings in person and/or by phone/video conferencing, use keyboards, keypads, dial pads etc., Some overhead reaching, bending and twisting, as per usual office environment and functions.
  • This position requires the ability to occasionally lift office products and supplies, up to 20 pounds.
Qualifications (Preferred)
  • 5+ years working in a heavily detail oriented role, focusing on accounting, bookkeeping, data analysis, accounts receivable analysis, or other similar type of position
  • Prior experience within the Staffing industry, including an understanding of managed service programs, vendor management systems, requisition management, and/or employer of record services
  • Dedication and desire to improve existing processes
  • Strong Problem-Solving Skills: Analytical thinking and project management skills;
  • Computer Skills: Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint); Sage Intacct and other ERP systems.
Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

This is a hybrid role working in the office Monday and Wednesday

Brand: Workwell North America

Territory: America

Location: San Diego, California

Salary: $70,000 - $75,000

Workplace: Hybrid

Experience: Mid

Hours: Mon – Fri 9

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Hybrid MSP & VMS Data Analyst
Hybrid MSP & VMS Data Analyst

Workwell • San Diego (CA)

Hybrid
USD 70,000 - 75,000
VMS Specialist
VMS Specialist

Integrity Staffing Solutions • Newark (DE)

On-site
USD 40,000 - 70,000
Accounts Receivable Specialist
Accounts Receivable Specialist

Vistage Worldwide, Inc. • San Diego (CA)

Hybrid
USD 30,000 - 39,000
Hybrid AR Specialist I — Global Billing & VAT
Hybrid AR Specialist I — Global Billing & VAT

Vistage-Worldwide • San Diego (CA)

Hybrid
USD 34,000 - 41,000
Accounts Receivable Specialist I
Accounts Receivable Specialist I

Vistage Worldwide • San Diego (CA)

Hybrid
USD 34,000 - 41,000
Accounting Manager - AZ, On Site
Accounting Manager - AZ, On Site

Vensure • Chandler (AZ)

On-site
USD 110,000 - 140,000
Health Insurance
401(k) with company match
Paid Time Off
+2
Senior MSP Accountant — Revenue, Close & Compliance Lead
Senior MSP Accountant — Revenue, Close & Compliance Lead

GXA • United States

Remote
USD 70,000 - 90,000
Staff Accountant
Staff Accountant

Leapros, Inc. • St. Charles (IL)

On-site
USD 55,000 - 75,000
Diversity and inclusivity commitment
Hybrid Staff Accountant: Close, Reconcile & Excel Mastery
Hybrid Staff Accountant: Close, Reconcile & Excel Mastery

Swank Motion Pictures, Inc. • St. Louis (MO)

Hybrid
USD 60,000 - 85,000
Healthcare benefits
401(k) match
Paid time off
+3
Accounts & Administrative Specialist
Accounts & Administrative Specialist

ADP, Inc. • Santa Clara (CA)

Hybrid
USD 65,000 - 90,000
Remote work flexibility