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.