Position Title: Oracle Fusion FP&A Enterprise Architect
Location: Chicago IL (Hybrid)
Duration: 6+ months
Job Description:
The Client is seeking a senior Oracle Fusion FP&A Enterprise Architect to own the target-state architecture and phased delivery of a finance, actuarial, analytics and AI modernization program.
The consultant will operate as the technical design authority across Oracle Fusion Cloud ERP, Fusion Data Intelligence, Oracle EPM, Oracle Analytics Cloud, Power BI, OCI data services and Fusion Agent Studio. This role requires an architect who can translate complex finance and actuarial requirements into a governed, scalable and traceable enterprise platform.
The selected candidate must remain hands-on and be capable of leading architecture, data modeling, integrations, analytics, AI agents, security, delivery governance and executive stakeholder alignment.
Required Qualifications:
15+ years of enterprise applications, finance transformation, data architecture or solution architecture experience.
12+ years of Oracle applications experience and 7+ years of hands-on Oracle Fusion Cloud experience.
Successful leadership of at least four full lifecycle Oracle Fusion ERP implementations, including two enterprise-scale finance transformations.
Expert-level functional and technical knowledge of Oracle Fusion Financials, including GL, AP, AR, FA, Cash Management, Tax and intercompany accounting.
Advanced knowledge of Oracle Fusion Data Intelligence or Fusion Analytics Warehouse, including semantic model extensions, security, KPIs and data validation.
Hands-on experience with Oracle EPM Cloud, including Planning, FCCS, ARCS and EDMCS.
Strong Oracle Analytics Cloud and Power BI architecture experience, including governed semantic models, row-level security and executive reporting.
Hands-on OCI architecture experience with Autonomous Data Warehouse, Object Storage, Data Integration, GoldenGate, OCI IAM and Oracle Integration Cloud.
Advanced SQL and PL/SQL skills, plus working Python experience for data validation, automation or advanced analytics.
Deep experience with Oracle integration technologies and patterns, including OIC, REST, SOAP, FBDI, ADFdi, Business Events and file-based interfaces.
Experience designing enterprise finance data models spanning ledger, subledger, planning, actuarial, operational and external datasets.
Demonstrated ability to reconcile data across Oracle Fusion, EPM, FDI, OAC and Power BI while preserving auditability and lineage.
Hands-on experience building AI agents or copilots with Fusion Agent Studio, OCI Generative AI or an equivalent enterprise agent platform.
Knowledge of RAG, vector search, prompt security, agent tool access and evaluation patterns for regulated enterprise environments.
Strong experience with RBAC, segregation of duties, data masking, encryption, audit controls and SOX-aligned financial systems.
Experience establishing CI/CD, release management and Infrastructure-as-Code practices for OCI and Oracle SaaS extensions.
Proven ability to translate requirements from Finance and Actuarial leaders into executable technical architecture.
Experience leading globally distributed delivery teams while remaining technically hands-on.
Excellent executive communication, workshop facilitation and architecture-documentation skills.
