Payroll Analyst - Advantage Solutions

Payroll Systems Analyst

At our Company, we grow People, Brands, and Businesses! We are seeking a dedicated Payroll Analyst who will assist in system upgrades, patches, and customizations as needed in all applications. Manage system issues log and work with payroll management to resolve. Monitor and administer compliance to all imports from third-party systems, Oracle JET/PTS.  Support as needed extractions to the Finance Department.

Take this opportunity to join North America’s leading business solutions provider and build your career working with amazing people in a growing industry! Apply today!

What we offer:

• Full-Time Benefits (Medical, Dental, Vision, Life)
• 401(k) with company match
• Training and Career Development
• Generous Paid Time-Off 

Responsibilities:

• Quality control of payroll records from JET/PTS – Run interface, review data, work with business partners and supervisor with said data on regularly scheduled events, special projects and terminations. Perform audits and reconciliations.
• JET/PTS Development Partner – Partner with IT/System Smith on all changes that require Oracle payroll testing.
• Oracle Development Partner – Partner with EBS team on changes and upgrades to the Oracle functionally to include OTL, ESS, MSS and Payroll modules.
• Benefit Billing – Track benefit rate changes to ensure the integrity of billing and cost allocations.
• Payroll Distribution – Maintain access database for cost withholding taxes, payroll distribution reports to Controllers and HRBP’s.
• Business Partner Relations – Work with Finance, Operations, HR and Payroll on daily operations, special projects and future development and opportunities.

Qualifications:

• Bachelor's Degree required or equivalent experience
• 5+ years of experience in human capital systems, advanced access database and Excel skills required
• 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, PTS/JET

Job Will Remain Open Until Filled

The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

Position Summary

The Payroll Systems Analyst will assist in system upgrades, patches and customizations as needed in all applications. Manage system issues log and work with payroll management to resolve. Monitor and administer compliance to all imports from third-party systems (Oracle JET/PTS).  Support as needed extractions to Finance Department.

Essential Job Duties and Responsibilities

• Quality control of payroll records from JET/PTS – Run interface, review data, work with business partners and supervisor with said data on regular scheduled events, special projects and terminations. Perform audits and reconciliations. Participate in annual PwC control sampling.
• JET/PTS Development Partner – Partner with IT/System Smith on all changes that require Oracle payroll testing.
• Oracle Development Partner – Partner with EBS team on changes and upgrades to the Oracle functionally to include OTL, ESS, MSS and Payroll modules.  Partner with EBS and business partners to assess new development and opportunities.
• Benefit Billing – Create benefit billing reports using Oracle OBIEE (business intelligence reporting) and KBX. Will use Access database to facilitate spreadsheet reporting. Track benefit rate changes to ensure integrity of billing and cost allocations.
• Payroll Distribution – Maintain access database for cost withholding taxes, payroll distribution reports to Controllers and HRBP’s.  Maintain libraries and user permissions in SharePoint, for div/dept changes and or reorganizations.  Develop and research for opportunities.
• Business Partner Relations – Work with Finance, Operations, HR and Payroll on daily operations, special projects and future development and opportunities.

Supervisory Responsibilities

Direct Reports

This position does not have supervisory responsibilities for direct reports

Indirect Reports

This position does not have guidance or mentoring responsibilities for indirect reports

Travel and/or Driving Requirements

• Travel and Driving are not essential duties or functions of this job  

Minimum Qualifications

The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job

Education Level: (Required)    Bachelor's Degree or equivalent experience

Field of Study/Area of Experience: 

• 5+ years of experience in human capital systems, advanced access database and excel skills required

Skills, Knowledge and Abilities

• 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, PTS/JET

Environmental & Physical Requirements

Office / Sedentary Requirements

Incumbent must be able to perform the essential functions of the job.  Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds. 

Additional Information Regarding The Company Job Duties and Job Descriptions

Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law.  The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.