A

Advantage Solutions

Guides Rx-to-OTC brand transitions

Payroll Systems Analyst

Enterprise ApplicationsPosted on Nov 10
Full-timeSt. Louis, MO, USA$67.2k - $84k

About the Job

Requirements

  • A bachelor's degree or equivalent experience is required.
  • At least 5 years of experience in human capital systems, advanced Microsoft Access database work, and Excel skills are required.
  • Ability to develop Microsoft Access-based database solutions.
  • Ability to program in VBA, automate Excel, use SQL Server, and write Oracle pass-through queries.
  • Working knowledge of Oracle EBS, KBX, OBIEE, TOAD for Oracle, Oracle SQL, and PTS/JET.
  • Ability to perform the essential functions of the position, including extended sitting, telephone use, computer data entry, and lifting up to 10 pounds as needed.

Responsibilities

  • Assist with system upgrades, patches, and customizations across applications, manage the system issues log, and resolve issues with payroll management.
  • Run the JET/PTS interface, review payroll-record data, coordinate with business partners and supervisors on scheduled events, special projects, and terminations, and perform audits and reconciliations.
  • Participate in annual PwC control sampling.
  • Partner with IT/System Smith on changes requiring Oracle payroll testing.
  • Partner with the EBS team on changes and upgrades to Oracle OTL, ESS, MSS, and Payroll modules, and work with EBS and business partners to assess new development opportunities.
  • Create benefit-billing reports using Oracle OBIEE and KBX, use Access to facilitate spreadsheet reporting, and track benefit-rate changes to maintain 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, and research development opportunities.
  • Work with Finance, Operations, HR, and Payroll on daily operations, special projects, and future development opportunities.
  • Support extractions for the Finance Department as needed.

About the Company

Advantage Solutions

Guides Rx-to-OTC brand transitions

Advantage Consumer Healthcare helps healthcare brands move products from prescription (Rx) to over-the-counter (OTC) in the U.S., providing strategic planning through to tactical execution. It uses Advantage Solutions’ resources to manage regulatory, pricing, packaging, retailer engagement, and in-store activation, with revenue from consulting fees and performance-based incentives tied to sales growth and brand equity gains. The leadership brings hands-on experience from manufacturing, retail, and sales services, plus access to the parent company’s assets and industry connections for targeted U.S. execution. The goal is to increase product availability on shelves, strengthen brand equity, and drive retail sales through a successful Rx-to-OTC transition.

Company size
1-10
Company stage
Not listed
Total funding
Not listed
Headquarters
Pittsburgh, PA
Founded
2011

Recently Posted Jobs

Explore more opportunities at Advantage Solutions

See more jobs