Lead Oracle Engineer

Houlihan Lokey
New York, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 200K

Job location

New York, United States of America

Tech stack

Clean Code Principles
API
Artificial Intelligence
Audit Trail
User Authentication
Unit Testing
Cloud Computing
Information Systems
Data Validation
ETL
Data Security
Data Synchronization
Database Queries
DevOps
Financial Software
JSON
Oracle
Oracle Applications
Performance Tuning
Regression Testing
Release Management
Cloud Services
Oracle APEX
Salesforce
Simple Object Access Protocol (SOAP)
SQL Stored Procedures
PL-SQL
SQL Databases
Oracle Fusion Middleware
Data Streaming
Integration Testing
Systems Integration
Web Services
XML
Extensible Stylesheet Language Transformations (XSLT)
Data Logging
Apex Code
Data Server Interface
File Transfer Protocol (FTP)
IT General Controls (ITGC)
Sql Optimization
Bi Publisher
SOAPAPI
Netsuite Erp
Oracle Service Cloud
Information Technology
REST
Oracle Integration
Oracle Cloud Infrastructure
Software Version Control
Data Pipelines
Workday
ServiceNow

Job description

As the Lead Oracle Engineer, you are the firm's primary technical authority for its Oracle Cloud ecosystem, responsible for the design, development, and ongoing support of enterprise-grade solutions built on Oracle APEX, Oracle Integration Cloud, and Oracle Fusion Cloud ERP. Based within the Information Technology organization, you enable Finance, Accounting, Procurement, and operational teams to work efficiently through scalable, secure, and well-architected custom applications and integrations. Your work spans the full technical lifecycle-from requirements gathering and solution architecture to hands-on development, production support, and continuous improvement., * 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 application, 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.
  • Design reusable integration patterns, error-handling frameworks, logging mechanisms, reconciliation processes, and exception monitoring to ensure reliability and operational visibility across the OIC environment.
  • Develop technical solutions across Oracle Fusion Financials modules-including General Ledger, Payables, Receivables, Procurement, Expenses, Cash Management, and Fixed Assets-leveraging FBDI, ADFDI, ESS jobs, BI Publisher, OTBI, REST APIs, and SOAP services.
  • 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 continue improvement mindset to the Oracle ecosystem by evaluating new technologies, simplifying complex solutions, improving supportability, and strengthening the overall Oracle platform.

Soft Skills:

  • Communicates effectively with both technical and non-technical audiences, translating complex Oracle solutions into clear, actionable terms for stakeholders across Finance, IT, and the business.
  • Builds strong, collaborative working relationships across Finance, Accounting, IT, and vendor teams, bringing a dependable and solution-focused approach to every engagement.
  • Takes full ownership of complex technical problems, following through with clear root cause analysis and sustainable long-term remediation rather than quick fixes.
  • Adapts readily to shifting priorities, Oracle quarterly updates, and evolving business requirements without losing focus or momentum.
  • Demonstrates a continuous improvement mindset-actively seeking opportunities to simplify, automate, and elevate the Oracle ecosystem over time.

Requirements

  • 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.
  • Demonstrated 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., * 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.

Benefits & conditions

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.

Houlihan Lokey provides a competitive benefits package. Our current benefits offerings can be found here

About the company

Houlihan Lokey, Inc. (NYSE:HLI) is a leading global investment bank recognized for delivering independent strategic and financial advice to corporations, financial sponsors, and governments. With uniquely deep industry expertise, broad international reach, and a partnership approach rooted in trust, the firm provides innovative, integrated solutions across mergers and acquisitions, capital solutions, financial restructuring, and financial and valuation advisory. Our unmatched transaction volumes provide differentiated, data-driven perspectives that help our clients achieve their most critical goals. To learn more about Houlihan Lokey, please visit HL.com.

Apply for this position