Payroll Systems Analyst

Advantage Solutions•St. Louis, MO
•$67,200 - $84,000•Remote

About The Position

The Payroll Systems Analyst assists with system upgrades, patches, and customizations across applications; manages the system issues log and works with payroll management to resolve issues; monitors and administers compliance for imports from third-party systems, including Oracle JET/PTS; and supports data extractions for the Finance Department. The role works with IT, EBS teams, Finance, Operations, HR, and Payroll on system changes, payroll testing, daily operations, special projects, and future development opportunities. The position performs payroll-record quality control, audits, reconciliations, and annual PwC control sampling. It also supports benefit billing and payroll distribution through reporting, database maintenance, tracking benefit-rate changes, and maintaining SharePoint libraries and user permissions. The job is primarily performed in an office environment and has no direct or indirect supervisory responsibilities. Travel and driving are not essential duties.

Requirements

  • Bachelor's degree or equivalent experience.
  • At least 5 years of experience in human capital systems.
  • Advanced Microsoft Access database and Excel skills.
  • Experience with Microsoft Access-based database solutions.
  • VBA programming, Excel automation, SQL Server, and Oracle pass-through queries.
  • Working knowledge of Oracle EBS, KBX, OBIEE, TOAD for Oracle, Oracle SQL, and PTS/JET.

Responsibilities

  • Run the JET/PTS interface, review payroll data, and work with business partners and supervisors on scheduled events, special projects, and terminations.
  • Perform payroll audits and reconciliations and participate in annual PwC control sampling.
  • Partner with IT/System Smith on changes requiring Oracle payroll testing.
  • Partner with the EBS team on Oracle functional changes and upgrades involving OTL, ESS, MSS, and Payroll modules.
  • Work with EBS and business partners to assess new development and opportunities.
  • Create benefit billing reports using Oracle OBIEE and KBX, using an Access database to facilitate spreadsheet reporting.
  • Track benefit-rate changes to help ensure billing and cost-allocation integrity.
  • Maintain the Access database for cost withholding taxes and payroll distribution reports for Controllers and HRBPs.
  • Maintain SharePoint libraries and user permissions for division/department changes and reorganizations.
  • Research and develop opportunities related to payroll distribution.
  • Work with Finance, Operations, HR, and Payroll on daily operations, special projects, and future development.
  • Manage the system issues log and work with payroll management to resolve issues.
  • Monitor and administer compliance for imports from third-party systems, including Oracle JET/PTS.
  • Support extractions for the Finance Department as needed.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Life insurance
  • 401(k) with company match
  • Training and career development
  • Generous paid time off
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service