Job Description
Tharseo IT is hiring a senior Oracle E-Business Suite developer who knows Oracle HRMS and Payroll inside and out, to support a U.S. Air Force customer in San Antonio, TX. Position summary Title Oracle EBS Developer (HRMS and Payroll) Company Tharseo IT Customer U.S. Air Force customer, San Antonio, TX Location Remote (U.S.), with occasional travel to the customer site in San Antonio, TX Platform Oracle E-Business Suite R12.2.x Primary modules Core HR, Payroll, Oracle Advanced Benefits (OAB), with Financials support Citizenship and clearance U.S. citizen; must obtain a CAC and pass a Public Trust investigation Travel Occasional travel to the customer site in San Antonio, TX, as the customer requires Reports to Customer technical lead, with day-to-day coordination through the prime contractor's technical and functional teams About the role You'll be the hands-on Oracle EBS developer for an Air Force program that runs payroll, HR and benefits for its workforce on Oracle E-Business Suite R12.2.x. Most of your day is spent in HRMS and Payroll: fast formulas, element and balance logic, payroll and benefits interfaces, and the reports HR and payroll staff depend on every pay period and at year end. You'll also build Oracle APEX reports and dashboards on top of EBS data, so payroll and HR staff can pull the answers they need without waiting on a new concurrent program. You'll work alongside a technical lead and the customer’s functional team. They bring the business requirements. You turn them into working, documented RICE components (Reports, Interfaces, Conversions and Enhancements) and keep the production environment healthy after go-live. This job isn't for a generalist. We need someone who has reconciled W-2s to the penny, debugged a payroll run at 2 a.m., and knows why federal garnishment rules don't always match the seeded logic.
Key responsibilities
Oracle EBS HRMS and Payroll development
- Build and support Oracle EBS R12.2.x customizations across Core HR, Payroll, Oracle Advanced Benefits and Financials, with most of the work in HR and Payroll and secondary support for Cash Management and Treasury.
- Write and maintain payroll, accrual, OAB and validation fast formulas, including element skip rules, earnings and deduction logic, and annual and sick leave accruals.
- Configure and troubleshoot elements, balances, element links, costing and Batch Element Entry (BEE).
- Support payroll processing end to end: pre-payments, Archiver and XML Check Writer, deposit advice, costing and transfer to GL.
- Support quarterly and year-end processing, including W-2 and 1099-R, balance adjustments, tax reconciliation, and Vertex and year-end patch impacts.
- Apply federal payroll rules such as Thrift Savings Plan (TSP) deductions, garnishments under Office of Personnel Management definitions of disposable earnings, and ACA 1094-C and 1095-C reporting. RICE design and delivery
- Work with the technical lead to design and build new Reports, Interfaces, Conversions and Enhancements.
- Develop inbound and outbound interfaces for benefits carriers, retirement plans, banks, tax vendors and other payroll partners.
- Build data conversions and mass updates with Oracle EBS APIs, open interfaces and Web ADI, working directly with EBS table structures and schemas.
- Create audit, reconciliation and operational reports in XML Publisher (BI Publisher) and Oracle Analytics Server Reports, backed by SQL and PL/SQL packages, procedures, functions and triggers.
- Build Oracle APEX reports, interactive reports and grids, charts and dashboards on EBS HRMS, Payroll and Benefits data, including drill-downs from summary totals to the person, assignment and pay-run detail behind them.
- Design APEX data access that respects EBS security: read-only views or reporting schemas over the PER, PAY and BEN tables, authentication and authorization schemes, and row-level restrictions so users see only the organizations and people they're cleared to see.
- Tune the SQL and PL/SQL behind APEX pages so reports return fast against production payroll volumes, and move APEX applications between environments under the same documentation and change control as every other RICE component.
- Use Oracle JDeveloper and Oracle Workflow for customizations, AME approval rules, notifications and self-service (ESS and MSS) personalizations. Full software development lifecycle
- Take part in design, build, unit and parallel testing, documentation, deployment and ongoing maintenance.
- Write functional and technical design documents, test scripts and migration steps for every component.
- Analyze the impact of patches, family packs and legislative updates on existing customizations. Ongoing development and operational support
- Provide production support for the EBS environment, including payroll run failures, data fixes and Oracle SRs.
- Coordinate with the prime contractor's technical and functional teams so work matches business requirements and timelines.
- Support the Oracle Analytics Server (OAS) team where EBS data feeds OAS reports and dashboards. Deliverables You'll be measured on what you ship. Expect to produce:
- New and migrated reports built to the customer's requirements, with HR, Payroll and Benefits reporting first in line, delivered in BI Publisher, OAS or Oracle APEX depending on what the users need.
- New or updated RICE components: fast formulas, interfaces, conversions, extensions and report customizations.
- Technical documentation for everything you build or migrate, including design documents, test scripts, deployment steps and support notes.
- Status updates, issue logs and knowledge transfer to the technical lead, the functional team and anyone who takes over your components later. Required qualifications
- 10+ years with Oracle EBS HRMS (Core HR, Payroll and Benefits) in technical or techno-functional roles.
- 8+ years of Oracle EBS development, including SQL, PL/SQL, XML Publisher (BI Publisher), Oracle Analytics Server Reports, JDeveloper and Oracle Workflow.
- Hands-on development experience on Oracle EBS R12.2.x.
- Hands-on experience building Oracle APEX reports and applications against Oracle EBS data, including interactive reports, authorization schemes and SQL tuning for large data sets.
- Strong knowledge of Oracle EBS table structures, schemas, APIs and open interfaces, especially the HRMS and Payroll data model (PER, PAY and BEN tables).
- Proven skill writing and debugging payroll, accrual and OAB fast formulas.
- U.S. payroll depth: elements, balances, costing, Check Writer and deposit advice, tax withholding and reconciliation, and quarter-end and year-end processing (W-2, balance adjustments, year-end patches).
- Has built and supported RICE components through the full SDLC, including design documents, unit and parallel testing, and production support.
- U.S. citizen able to obtain a CAC and pass a Public Trust investigation.
- Clear writer and communicator who can work with functional analysts, payroll staff and government stakeholders. Preferred qualifications
- Prior work on Air Force, DoD or other federal Oracle HRMS and Payroll systems.
- Federal payroll rules: Thrift Savings Plan, OPM garnishment and disposable-earnings rules, federal leave accruals, and ACA 1094-C and 1095-C reporting.
- Oracle Advanced Benefits open enrollment setup and Oracle Time and Labor (OTL) time entry rules.
- Oracle Financials experience, especially Cash Management and Treasury, plus Payables, General Ledger or Order Management.
- Oracle certification in EBS R12 Human Capital Management or Payroll, or EBS R12 Financial Management Certified Implementation Specialist (Payables, General Ledger, Order Management, Cash Management), or the ability to earn one.
- Experience with EBS upgrades, patching cycles and Vertex tax updates.
- Familiarity with Oracle Analytics Server or Oracle Analytics Cloud dashboards and with Oracle HCM Cloud (HDL, HCM Extracts, OTBI).
- Background with financial controls, audit requirements or federal compliance frameworks. Work location, clearance and compensation
- Location: Remote within the United States. You'll travel to the customer site in San Antonio, TX from time to time for meetings, go-lives and other work the customer needs done in person.
- Citizenship and clearance: U.S. citizenship is required. You must obtain and keep a Common Access Card (CAC) and pass a Public Trust background investigation.
- Compensation: Competitive and based on experience. Tharseo IT offers W-2 employment and subcontract arrangements. Equal opportunity Tharseo IT is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by la