Quick overview
Job description
Job Title: Oracle Fusion Technical Lead (Data & Integration, Individual Contributor)
Location: Remote, US
Type: Contract to hire
Job Summary
We are seeking an experienced Senior Oracle Fusion Technical Consultant or Oracle Fusion Technical Lead who will be an individual contributor with deep expertise in Oracle Fusion data architecture, table structures, TCA (Trading Community Architecture), BI Cloud Connector (BICC), SQL, and enterprise data extraction frameworks. The ideal candidate will drive data integration, reporting, analytics, and data migration initiatives involving Oracle Fusion Cloud applications and enterprise data platforms, including Data Lakes and AWS environments.
Key Responsibilities
- Serve as the senior technical resource or Technical Lead for Oracle Fusion data, reporting, and integration initiatives.
- Strong understanding of Oracle Fusion Cloud architecture.
- Deep knowledge of Fusion database structures and subject areas
Have experience in
- Data Model & Table Structure
- TCA - Customer and Supplier data models and strong understanding of customer master and party relationships.
SQL & Reporting
- Develop a deep understanding of Oracle Fusion Cloud data models across ERP, HCM, Procurement and Project portfolio modules.
- Support data warehouse, analytics, and enterprise reporting initiatives.
- Analyze and optimize Oracle Fusion data structures, relationships, and reporting requirements.
- Design and implement scalable data extraction solutions using BICC.
- Lead data integration efforts between Oracle Fusion and downstream systems such as Data Lakes, AWS, and analytics platforms.
- Design data mapping, reconciliation, and validation strategies.
- Build and optimize complex SQL queries for reporting and data analysis.
- Work closely with functional teams to understand business processes and translate requirements into technical solutions.
- Mentor technical team members and establish best practices for data extraction and governance.
- Troubleshoot data integrity, reconciliation, and performance issues.
- Drive solution design reviews and provide technical leadership for enterprise data initiatives.
Required Technical Skills
- Oracle Fusion Expertise
- Strong understanding of Oracle Fusion Cloud architecture.
- Deep knowledge of Fusion database structures and subject areas.
Expertise across Fusion modules such as:
- Financials (GL, AP, AR, FA, CM)
- Procurement
- Projects
- HCM
Data Model & Table Structure
Extensive experience with:
- Oracle Fusion Data Model
- Core Fusion Table Structures
- Entity Relationships
- Data Lineage
- Reporting Data Stores
TCA (Trading Community Architecture)
Hands-on expertise in using
- HZ_PARTIES
- HZ_CUST_ACCOUNTS
- HZ_LOCATIONS
- HZ_PARTY_SITES
- HZ_CUST_ACCT_SITES_ALL
- Customer and Supplier data models
Strong understanding of customer master and party relationships.
BICC (BI Cloud Connector)
Expert-level experience with:
- BICC Extracts
- Incremental Data Extraction
- Full Loads
- Scheduling and Monitoring
- Data Lake Integrations
- PVO-based Extractions
SQL & Reporting
- Advanced SQL development skills.
- Query tuning and performance optimization.
- Data reconciliation and validation.
- Experience creating complex datasets for reporting and analytics.
Preferred Technical Skills
- Data Model & Table Structure
- TCA - Customer and Supplier data models and strong understanding of customer master and party relationships.
- SQL & Reporting
- BICC
- OTBI
- BI Publisher
- Oracle Analytics Cloud (OAC)
- Oracle Integration Cloud (OIC)
- REST & SOAP APIs
- AWS Data Lake Architecture
Similar jobs
- CO

Part Time Key Holder - Cotton On Willowbrook Mall NJRecently posted Auto Apply
COTTON ON · Wayne · Hybrid · Posted 17 Nov 2026 🇺🇸
RecruitingWorkdayInventory Control+1$19 - $22/hr - CO

Part Time Key Holder - Cotton On Houston GalleriaRecently posted Auto Apply
COTTON ON · Houston · Hybrid · Posted 17 Nov 2026 🇺🇸
RecruitingWorkdayInventory Control+1$15 - $18/hr - CO

Chief Operations Officer - Professional ServicesRecently posted Auto Apply
Cogentanalytics · Minneapolis · On-site · Posted 17 Nov 2026 🇺🇸
Capacity PlanningFinancial ReportingForecasting+2$190k - $220k/yr - NG
Quality Assurance ManagerRecently posted Auto Apply
Novotech Global · South San Francisco · Hybrid · Posted 17 Nov 2026 🇺🇸
GCPClinical ResearchCompliance+1$125k - $145k/yr - EM

Pulmonary Clinic Advanced Practitioner Provider Auto Apply
Exceed Medical · TX · Hybrid 🇺🇸
ACLSBLSEHR+1Salary not listed - ST

Maintenance Tech II, 1st Shift (CHARLOTTE)Recently posted
Staples, Inc. · Charlotte, NC · Hybrid · Posted 17 Nov 2026 🇺🇸
Mental HealthSalary not listed - PR
Senior Patient Services Specialist - Breast Surgery ClinicRecently posted Auto Apply
Providence · Seattle · On-site · Posted 17 Nov 2026 🇺🇸
Medical TerminologyPatient CareSchedulingSalary not listed - PR
Business Office SpecialistRecently posted Auto Apply
Providence · Olympia · On-site · Posted 17 Nov 2026 🇺🇸
Medical BillingPatient CareReconciliation+1Salary not listed - PR
Communication Specialist - HybridRecently posted Auto Apply
Providence · Seattle · Hybrid · Posted 17 Nov 2026 🇺🇸
Public Relations$35 - $54/hr - PR
Ultrasound Technologist - UltrasoundRecently posted Auto Apply
Providence · Walla Walla · On-site · Posted 17 Nov 2026 🇺🇸
BLSSalary not listed - PR
Echocardiograph TechnologistRecently posted Auto Apply
Providence · Milwaukie · On-site · Posted 17 Nov 2026 🇺🇸
EchoBLSSalary not listed - PR
Patient Authorization and Referral RepresentativeRecently posted Auto Apply
Providence · Lubbock · On-site · Posted 17 Nov 2026 🇺🇸
SchedulingSalary not listed