Senior Oracle APEX & Fusion Integration Solutions Developer (Contract)

About the role

Marcus & Millichap is seeking an experienced Oracle APEX and Oracle Fusion Cloud Solutions Architect to lead the design and development of a custom Agent Billing platform as part of Project Fusion. The solution will support the calculation, review, approval, reconciliation, and invoicing of monthly agent charges that are not supported natively within Oracle Fusion Cloud ERP. The application will serve as a billing orchestration and calculation engine tightly integrated with Oracle Fusion Accounts Receivable, Accounts Payable, Projects, Customer, Supplier, and AP/AR Netting processes.

The hourly range for this role is $95.00 - $115.00 per hour. Actual pay will be determined by factors such as education, experience, and job-related skills relevant to the role.

Responsibilities

• Lead architecture and technical design of the Agent Billing Solution.
• Develop a scalable Oracle PaaS architecture utilizing:
  • Oracle APEX
  • Oracle Integration Cloud (OIC)
  • Oracle Fusion REST APIs
  • Oracle Database Services
• Define application architecture, security strategy, audit framework, and deployment approach.
• Collaborate with Finance, Accounting, Treasury, ERP, and business stakeholders to translate requirements into technical designs.
• Design and develop custom capabilities including:
  • Agent billing calculation engine
  • Fee allocation and cost-split calculations
  • Commission deduction prioritization logic
  • Marketing Support Budget tracking
  • Billing workflow and approvals
  • Exception handling and validation
  • Monthly billing cycle processing
  • Audit trail and reconciliation processes
  • Consolidated Agent Billing Statements
• Design and implement integrations with:
  • Oracle Accounts Receivable
  • Oracle Accounts Payable
  • Oracle Projects
  • Customer Master
  • Supplier Master
  • Oracle Payments
  • AP/AR Netting
• Develop integrations utilizing:
  • Oracle Integration Cloud (OIC)
  • REST APIs
  • SOAP Services
  • FBDI
  • BICC
  • File-Based Interfaces
• Understand upstream and downstream AP and AR transaction flows.
• Design billing rules based upon historical transaction activity.
• Create reconciliation controls between:
  • Source charges
  • Billing calculations
  • Oracle AR invoices
  • AP/AR netting settlements
• Design robust exception management frameworks.
• Lead development activities, perform code reviews, and establish development standards.
• Mentor internal technical resources.
• Coordinate with Oracle implementation partners and third-party vendors.
• Support testing, deployment, and production readiness activities.

Requirements

Education

• Bachelor's Degree in Computer Science, Information Systems, Finance, Accounting, Engineering, or related field.

Experience

• 10+ years of enterprise application development experience.
• 7+ years of Oracle technologies experience.
• 5+ years developing Oracle APEX applications.
• 5+ years of Oracle Fusion Cloud ERP integration experience.
• Proven experience leading solution architecture for custom Oracle applications.
• Experience designing large-scale financial systems.

Oracle Technical Skills

• Oracle APEX
• Oracle SQL
• PL/SQL
• Oracle REST APIs
• Oracle Integration Cloud (OIC)
• Oracle Database

Strongly Preferred Skills

• Oracle Visual Builder (VBCS)
• Oracle Identity Cloud Services
• Oracle Autonomous Database
• Oracle Data Integrator
• OCI Services

Oracle Functional Experience

• Oracle Receivables (AR):
  • AutoInvoice
  • Customer Statements
  • Customer Master
  • Receipts
  • Collections
  • Balance Forward Billing
• Oracle Payables (AP):
  • Supplier Management
  • Invoices
  • Payments
  • Supplier Relationships
• Oracle Projects:
  • Project Billing
  • Contract Billing
  • Funding
  • Budget Tracking
• Integrations:
  • Fusion REST APIs
  • FBDI
  • OIC Integrations
  • Financial data staging applications

Preferred Industry Experience

• Commission Calculations
• Billing Engines
• Revenue Sharing Models
• Financial Services
• Real Estate Brokerage
• Insurance Brokerage
• Banking
• Wealth Management

Soft Skills

• Strong analytical and problem-solving capabilities
• Executive communication skills
• Ability to work directly with Finance leadership
• Ability to facilitate design workshops
• Strong documentation skills
• Strong stakeholder management capabilities
• Ability to work independently with minimal supervision
• Excellent written and verbal communication

Key Deliverables

• Phase 1 – Architecture & Design:
  • Solution Architecture Document
  • Technical Design Documents
  • Data Model Design
  • Security Architecture
  • Integration Architecture
• Phase 2 – Build:
  • Oracle APEX Application
  • Billing Calculation Engine
  • Approval Workflows
  • Oracle Integration Cloud Interfaces
  • Fusion API Integrations
  • Reporting and Reconciliation Framework
• Phase 3 – Testing & Deployment:
  • SIT Support
  • UAT Support
  • Production Migration
  • Knowledge Transfer
  • Operational Run Books

Ideal Candidate Profile

The ideal consultant has previously designed and delivered:

• Oracle APEX-based enterprise applications
• Oracle Fusion ERP extensions
• Financial subledger applications
• Billing engines
• Revenue allocation systems
• Commission management platforms
• Large-scale Oracle Fusion integrations

Can operate as a hands-on Solution Architect who is equally comfortable discussing API architecture with technical teams and billing/accounting processes with Finance executives.

Pay

The hourly range for this role is $95.00 - $115.00 per hour.