Payroll Systems Analyst: Oracle & JET/PTS Specialist

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

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.