Lead Oracle Engineer
About the role
The Lead Oracle Engineer plays a pivotal role in the firm's Oracle Cloud ecosystem, focusing on the design, development, and support of enterprise-grade solutions built on Oracle APEX, Oracle Integration Cloud, and Oracle Fusion Cloud ERP. This position is based within the Information Technology organization and supports Finance, Accounting, Procurement, and operational teams through scalable, secure, and well-architected custom applications and integrations.
Responsibilities
Design, develop, and maintain advanced Oracle APEX applications supporting Finance, Accounting, Procurement, and operational business processes, with a focus on user experience, role-based security, workflow automation, auditability, and long-term maintainability.
Maintain and enhance ETL and data pipelines processes that support APEX applications, reporting, data synchronization, and downstream business processes.
Review existing custom applications and data flows to identify opportunities for simplification, performance improvement, automation, and automation.
Lead the design and development of integrations between Oracle Fusion Cloud ERP and internal or external systems using Oracle Integration Cloud—including application and scheduled integrations, file-based integrations, REST/SOAP, ERP adapter, SFTP, and event-driven integration patterns.
Create, maintain, and optimize SQL and PL/SQL packages, procedures, functions, views, triggers, and data validation logic, applying performance tuning practices to support applications, integrations, reporting, and automation.
Partner with business users and cross-functional teams to gather requirements, perform fit-gap analysis, and translate business needs into scalable, well-documented Oracle Cloud solutions.
Work with security, audit, and compliance teams to ensure all solutions align with SOX, ITGC, data security, segregation of duties, and change management requirements.
Troubleshoot complex production issues across APEX, OIC, Oracle Fusion, BI Publisher, OTBI, ESS jobs, APIs, and data interfaces—providing clear root cause analysis and sustainable long-term remediation.
Support end-to-end testing—including unit testing, system integration testing, UAT, and regression testing.
Support Oracle quarterly updates by reviewing release notes, assessing potential impact, testing integrations, validating custom applications, validating critical business processes, and resolving post-upgrade issues.
Provide technical guidance to developers and consultants on Oracle APEX, OIC, Oracle Fusion integration, and development best practices, contributing to team capability and knowledge sharing.
Actively explore AI-enabled tools, Oracle Process Automation, and emerging Oracle Cloud capabilities to identify and implement automation opportunities that reduce manual effort, streamline integrations, and improve operational efficiency.
Bring an innovation and continuous improvement mindset to the Oracle ecosystem by evaluating new technologies, simplifying complex solutions, improving supportability, and strengthening the overall Oracle platform.
Qualifications
Bachelor’s degree in Computer Science, Information Systems, Engineering, Finance Technology, or a related field, or equivalent professional experience.
8+ years of hands-on experience with Oracle technologies, including Oracle Cloud ERP, Oracle APEX, ODI, OIC, SQL, and PL/SQL.
8+ years of experience designing and developing Oracle APEX applications in an enterprise environment.
5+ years of experience with Oracle Integration Cloud, including ERP adapters, REST/SOAP APIs, scheduled integrations, file-based integrations, and error handling.
Strong experience supporting Oracle Fusion Cloud ERP, preferably within Financials, Procurement, Expenses, or related finance applications.
Advanced SQL and PL/SQL development experience, including performance tuning, complex queries, stored procedures, packages, functions, and data validation logic.
Strong understanding of Oracle Fusion integration methods including FBDI, ADFDI, ESS jobs, BI Publisher, OTBI, REST APIs, SOAP services, and business events.
Experience with JSON, XML, XSLT, web services, API authentication, SFTP, and secure data transmission practices.
Strong communication skills with the ability to work directly with business stakeholders, IT teams, vendors, and senior leadership.
Preferred Qualifications
Experience in financial services, banking, consulting, or a similarly regulated and high-performance environment.
Experience with Oracle BI Publisher, OTBI, FDI/FAW, or Oracle Analytics Cloud.
Familiarity with Oracle Visual Builder Cloud Service, Oracle Process Automation, or Oracle Digital Assistant.
Experience with SOX controls, audit requirements, ITGC, production change control, and incident management.
Experience supporting integrations with Workday, Concur, Salesforce, ServiceNow, or similar enterprise platforms.
Exposure to DevOps practices, source control, migration processes, and structured release management.
Pay
Houlihan Lokey is committed to providing its employees with an exciting career opportunity and competitive total compensation package, which may include other components such as discretionary incentive compensation. The firm’s good faith and reasonable estimate of the possible salary range for this role at the time of posting is: $130,000–$200,000 Actual salary at the time of hire may vary and may be above or below the range based on various factors, including, but not limited to, the candidate’s relevant qualifications, skills, and experience and the location where this position may be filled.
Schedule
The Lead Oracle Engineer works full-time and is based in the firm’s headquarters in San Francisco, California.
Benefits
Houlihan Lokey provides a competitive benefits package. Our current benefits offerings can be found here.