Payroll Systems Analyst

your adv; St. Louis (MO); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Life insurance

401(k) with company match

Training and Career Development

Paid Time-Off

Job summary

Your adv is seeking a Payroll Systems Analyst to support system upgrades, patches, and customizations across Oracle JET/PTS and related payroll modules. You will manage issue logs, collaborate with payroll management, and ensure data integrity for third-party imports.

You will partner with IT, Finance, HR, and business partners on audits, reporting, and ongoing improvements, while contributing to benefit billing, payroll distribution, and compliance.

Qualifications

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

Responsibilities

• Quality control of payroll records from JET/PTS; run interface, review data, audits and reconciliations.
• JET/PTS Development Partner – collaborate with IT/System Smith on changes needing Oracle payroll testing.
• Oracle Development Partner – collaborate with EBS team on upgrades to OTL, ESS, MSS and Payroll modules.
• Benefit Billing – track rate changes to ensure billing integrity and cost allocations.
• Payroll Distribution – maintain access database for tax withholdings and distribution reports to Controllers and HRBP’s.
• Business Partner Relations – work with Finance, Operations, HR and Payroll on daily operations and future projects.

Skills

Excel automation

VBA programming

SQL Server

Oracle pass-through queries

Education

Bachelor's Degree or equivalent experience

Tools

Microsoft Access

Oracle EBS

KBX

OBIEE

TOAD for Oracle

Oracle SQL

PTS/JET

Job description

At our Company, we grow People, Brands, and Businesses! We are seeking a dedicated Payroll Systems 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!

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

TV1

Job Will Remain Open Until Filled