Oracle Fusion HCM Technical Lead - Reporting & Integrations

Falcon Chase International

United Kingdom

On-site

GBP 85,000 - 110,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Falcon Chase International is seeking an Oracle Fusion HCM Technical Lead to work with a leading UK client. The role requires NPPV3 eligibility and a minimum of 3 years' UK residency, subject to clearance requirements.

You will lead HCM reporting, extracts, and integration workstreams, collaborating with cross-functional teams. The role involves hands-on design and development, including OTBI, BI Publisher, HCM Extracts, APIs, and OIC, with a focus on production readiness and governance.

Qualifications

  • Experience with Oracle Fusion HCM ecosystem and reporting.
  • Ability to design and develop OTBI analyses and BI Publisher reports.
  • Strong SQL skills for data modelling and troubleshooting.
  • Experience with HCM Extracts and outbound interfaces.
  • Hands-on involvement in integration projects using OIC.

Responsibilities

  • Take ownership of Oracle HCM reporting, extracts and integration workstreams, including plans, priorities, dependencies, milestones, testing, cutover and production readiness.
  • Lead customer workshops and translate business and functional requirements into technical solutions using OTBI, BI Publisher, HCM Extracts, APIs, file interfaces and Oracle Integration Cloud (OIC).
  • Collaborate with HCM, Payroll, Security, Data Migration, Testing and external application teams to manage dependencies, risks and technical decisions through to resolution.
  • Review technical deliverables produced by other developers while retaining hands-on responsibility for complex design and development activities.
  • Design, develop and support Oracle BI Publisher reports and data models using complex SQL, parameters, List of Values (LOVs), RTF/Excel/eText templates, bursting, scheduling and report delivery.
  • Develop OTBI analyses and dashboards, including prompts, calculations and scheduled outputs using relevant HCM and Payroll subject areas.

Skills

Oracle Fusion HCM
OTBI
BI Publisher
HCM Extracts
OIC (Oracle Integration Cloud)
SQL

Tools

OTBI

Job description

We are looking for an Oracle Fusion HCM Technical Lead to work with one of our leading UK clients. Candidates must be NPPV3 eligible; applicants with a minimum of 3 years' UK residency will also be considered, subject to meeting the clearance eligibility requirements.

Key Responsibilities
Workstream Leadership & Solution Ownership
  • Take ownership of Oracle HCM reporting, extracts and integration workstreams, including plans, priorities, dependencies, milestones, testing, cutover and production readiness.
  • Lead customer workshops and translate business and functional requirements into technical solutions using OTBI, BI Publisher, HCM Extracts, APIs, file interfaces and Oracle Integration Cloud (OIC).
  • Collaborate with HCM, Payroll, Security, Data Migration, Testing and external application teams to manage dependencies, risks and technical decisions through to resolution.
  • Review technical deliverables produced by other developers while retaining hands-on responsibility for complex design and development activities.
BI Publisher, OTBI & SQL
  • Design, develop and support Oracle BI Publisher reports and data models using complex SQL, parameters, List of Values (LOVs), RTF/Excel/eText templates, bursting, scheduling and report delivery.
  • Develop OTBI analyses and dashboards, including prompts, calculations and scheduled outputs using relevant HCM and Payroll subject areas.
  • Write, debug and optimise SQL for reporting, reconciliation and issue investigation.
  • Troubleshoot report failures, performance issues, missing data, formatting problems, security restrictions, effective-dating discrepancies and scheduling or delivery defects.
HCM Extracts & Outbound Interfaces
  • Design, develop and support Oracle HCM Extracts, including data groups, records, attributes, parameters, output structures, schedules and delivery options.
  • Work with delivered and user-defined database entities and Fast Formula where appropriate.
  • Implement full and incremental (changes-only) extraction patterns to meet business and downstream application requirements.
  • Develop outbound files in required formats and validate and reconcile extract results against Oracle Fusion source data.
  • Optimise high-volume extracts and resolve incomplete, failed or long-running processes.
Oracle Integration Cloud (OIC)
  • Design, develop and support scheduled, application-driven and orchestration-based integrations using appropriate OIC adapters and connectivity patterns.
  • Build integration mappings, lookups, transformations, branching, looping, data enrichment, file handling and orchestration logic.
  • Integrate Oracle Fusion with internal and external applications using REST/SOAP services, file-based interfaces and SFTP.
  • Implement robust fault handling, retries, tracking, business identifiers, duplicate prevention, recovery and diagnostic logging.
  • Design integrations with consideration for payload size, pagination, batching, throughput, idempotency and restartability, particularly for high-volume interfaces.
Testing, Production Support & Governance
  • Prepare unit-testing evidence and support SIT, UAT, data reconciliation, defect triage, regression testing, deployment, cutover and post-go-live hypercare.
  • Investigate and resolve issues using OIC monitoring, Oracle Fusion logs, SQL queries and report/extract outputs, identifying root causes across source data, configuration, security, integration and target systems.
  • Coordinate with customer security and infrastructure teams on service accounts, credentials, certificates, SFTP connectivity and environment-specific endpoints.
  • Maintain technical design documents, mappings, report and interface catalogues, deployment records, operational runbooks, monitoring and recovery procedures.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle Fusion HCM Tech Lead – OTBI/OIC Expert
Oracle Fusion HCM Tech Lead – OTBI/OIC Expert

Falcon Chase International • United Kingdom

On-site
GBP 85,000 - 110,000
Oracle Fusion HCM Lead in London
Oracle Fusion HCM Lead in London

Energy Jobline CVL • Greater London

On-site
GBP 110,000 - 140,000
Oracle HCM Technical Specialist (FTC)
Oracle HCM Technical Specialist (FTC)

Catalyst Partners • Greater London

Remote
GBP 70,000 - 90,000
Oracle Fusion HCM Payroll Consultant
Oracle Fusion HCM Payroll Consultant

Red Commerce Schweiz GmbH • City Of London

Remote
GBP 101,000 - 185,000
Principal Consultant: Oracle Fusion HCM Cloud
Principal Consultant: Oracle Fusion HCM Cloud

K&K Talents • England

On-site
GBP 70,000 - 90,000
Oracle Fusion Hcm Payroll Consultant
Oracle Fusion Hcm Payroll Consultant

RED SAP Solutions • England

Hybrid
GBP 70,000 - 95,000
Oracle HCM Consultant
Oracle HCM Consultant

Dabster • United Kingdom

On-site
GBP 85,000 - 110,000
Senior Oracle Fusion Cloud Developer-SC Cleared
Senior Oracle Fusion Cloud Developer-SC Cleared

VE3 • Maidenhead

On-site
GBP 70,000 - 110,000
Senior Oracle Fusion Cloud Developer
Senior Oracle Fusion Cloud Developer

VE3 • Maidenhead

On-site
GBP 90,000 - 130,000
Oracle HCM Fusion Functional Consultant (Payroll, Absence, Compensation & Benefits) - SC Clearance
Oracle HCM Fusion Functional Consultant (Payroll, Absence, Compensation & Benefits) - SC Clearance

International Business Machines Corporation • Greater London

Hybrid
GBP 90,000 - 130,000
25 days holiday + holidays
Private medical, dental & optical
Pension plan with salary sacrifice