Job Summary
Next Generation, Inc., an Equal Opportunity Employer, is seeking a seasoned Senior Oracle Payroll Integrations Developer to design, build, and maintain robust integrations across a payroll ecosystem. You’ll be responsible for payroll data flows, while ensuring data accuracy, compliance, and performance. The ideal candidate is very well‑versed in Oracle Payroll’s data model (including the underlying payroll tables/schemas), and excels at writing clean, scalable code for complex transformations and high‑volume transactions. This is a remote position with collaboration across cross‑functional teams in multiple time zones, and may include client site visits.
Job Responsibilities
- Integration Ownership: Design, implement, and maintain payroll integrations between Oracle (HCM Cloud/EBS) and internal/external systems (HRIS, benefits, finance, time & attendance, tax filing, banking).
- Data Model Mastery: Query, analyze, and optimize against Oracle Payroll underlying tables/schemas (e.g., PAY* / PY* table families and related metadata), ensuring referential integrity and auditability across payroll runs, costing, balances, and retro adjustments.
- Code Development: Write high-quality, performant code (PL/SQL, SQL, Java/JavaScript or Python for middleware utilities) to support transformations, validations, file generation/ingestion, and API orchestration.
- Oracle Tooling: Build/maintain interfaces using HCM Extracts, HDL (HCM Data Loader), Fast Formulas (Payroll/Comp/Absence), BI Publisher, and OIC (Oracle Integration Cloud) or equivalent middleware (MuleSoft, Boomi, etc.).
- APIs & Connectivity: Implement REST/SOAP services, SFTP/file-based integrations, webhooks, and event-driven pipelines; manage authentication, secrets, and connectivity (OAuth 2.0, certificates, keys).
- Performance & Scaling: Tune queries and jobs for high‑volume payroll cycles, optimize partitioning/indexing strategies, batch windows, and error-handling/retry logic.
- Quality & Compliance: Establish automated testing (unit/integration), reconcile outputs against payroll results and general ledger postings; enforce SOX/ISO controls, segregation of duties, and PII protection.
- Observability: Instrument integrations with logging, metrics, and alerts (e.g., Splunk, ELK, OCI Monitoring); create dashboards for SLA tracking and payroll cut‑off readiness.
- Documentation & Standards: Author technical specs, sequence diagrams, data dictionaries/mappings, and runbooks; promote coding standards and CI/CD best practices.
- Mentorship & Collaboration: Partner with Payroll Ops, HRIS, Finance, and Security; mentor junior developers and participate in code reviews and design sessions.
Job Requirements
- 7–10+ years of hands-on experience building Oracle Payroll integrations in enterprise environments.
- Deep practical knowledge of Oracle Payroll data structures, including payroll results, costing, balances, elements, run actions, retro, and year‑end reporting, and proficiency querying the underlying payroll tables/schemas (PAY*/PY*).
- Advanced PL/SQL/SQL (packages, procedures, functions, bulk operations, performance tuning) and strong experience with HCM Extracts, HDL, Fast Formulas, and BI Publisher.
- Proven delivery using OIC or comparable middleware, plus REST/SOAP APIs, SFTP/file pipelines, and secure integration patterns.
- Experience with CI/CD (Git, build pipelines), automated testing, and secure secrets management.
- Strong understanding of payroll compliance (tax, garnishments, retro, audits), data privacy/PII, and financial controls.
- Excellent communication skills; ability to operate in a remote, distributed team and meet tight payroll calendars.
- Background integrating with banking, tax filing, GL/ERP, and benefits carriers.
- Knowledge of GDPR and global payroll nuances (multi‑country).
Job Benefits
- Paid time off
- Medical insurance
- Dental plan
- Vision plan
- Life insurance
- Short-Term / Long-Term Disability (STD/LTD)
- Paid holidays
- Competitive FTE salary range of $130,000-$150,000 USD based on experience, education, and location