Senior Oracle APEX & Fusion Integration Solutions Developer (Contract)

Position Overview

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 successful candidate will architect and build a scalable Oracle PaaS-based application utilizing Oracle APEX, Oracle Integration Cloud (OIC), Oracle Fusion REST APIs, and Oracle Database technologies.

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. Marcus & Millichap is a multi-state employer and posted salary ranges are provided in good faith for compliance with all relevant pay-transparency regulations. These ranges may not reflect potential compensation for positions based in other states or regions.

Primary Responsibilities

Solution Architecture

• 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.

Custom Billing Engine Development

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

Oracle Fusion Integration

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

Project Fusion currently leverages Oracle Integration Cloud as the primary middleware platform for Oracle Cloud integrations.

Data & Financial Process Design

• 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.

Technical Leadership

• 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.

Required Qualifications

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

Required:

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

Strongly Preferred:

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

Oracle Functional Experience

Must have hands-on experience with:

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

Strong preference for candidates with experience implementing or developing solutions involving:

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

Soft Skills

The ideal candidate will possess:

• 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

The contractor will be expected to deliver:

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

and 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.

Target Level: Senior Solution Architect / Principal Consultant / Lead Oracle APEX Architect.

Marcus & Millichap 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, veteran status, or any other protected characteristic under federal, state, or local law.