Overview and Responsibilities:The Director, Oracle EPM (FCC) is the lead architect responsible for the design, configuration, and technical health of the FCC environment. This role leads the build of complex consolidation logic, manages data integration architecture, and ensures the system is optimized for performance. As the subject matter expert (SME), you bridge functional business requirements and technical implementation across the Oracle Cloud EPM suite.
Key responsibilities include architecting the FCC application and master data design, developing and tuning consolidation calculations, building and automating data integrations, and maintaining reporting deliverables and environment lifecycle processes to support a reliable and efficient close.
• Architect the FCC application structure (dimensions, hierarchies, metadata, and security mapping) to ensure performance and data integrity.
• Author and maintain complex business rules (Calculation Manager / Groovy) for currency translation, intercompany eliminations, and equity adjustments.
• Design and build data pipelines using Data Management / Data Integration (EPM Integration Agent) to automate data loads from ERP and other sources.
• Monitor and tune system performance; optimize calculation logic and troubleshoot consolidation bottlenecks.
• Design and manage Oracle EDM as the master data hub; define viewpoints, node types, hierarchies, and request workflows across FCC/Planning/ERP.
• Own environment lifecycle management (patching, testing, upgrades) and automate admin tasks, backups, and migrations using EPM Automate and REST APIs.
• Build and maintain advanced reporting deliverables (Financial Reporting and Narrative Reporting packs) for internal and external stakeholders.
• Provide technical leadership, peer mentoring, and design/code reviews; produce technical design documentation and troubleshooting guides.
Basic Qualifications:• Extensive, hands-on Oracle Cloud EPM experience with Financial Consolidation and Close (FCC), including configuration of Task Manager, Supplemental Data Manager (SDM), and Approvals.
• Expertise authoring and maintaining complex calculation logic using Calculation Manager and Groovy scripting.
• Strong experience with data integration architecture and engineering using Data Management / Data Integration and EPM Integration Agent, including mappings and transformations.
• Proven automation capability using EPM Automate and REST APIs for migrations, backups, and routine maintenance.
• Working knowledge of SQL for data validation, reconciliation, and troubleshooting.
Additional Qualifications:• Demonstrated diagnostic mindset and ability to trace data lineage from source ERP trial balance through transformations to consolidated FCC outputs.
• Extensive Oracle EDM experience (applications, viewpoints, request workflows, mapping sets) and understanding of EDM adapters with FCC and Cloud ERP.
• Experience with performance tuning for large-scale consolidations and report generation, including optimization of calculation scripts.
• Strong technical writing skills (technical design documents, configuration workbooks, and troubleshooting guides).
• Ability to lead and mentor junior developers/administrators, providing reviews and ensuring best practices in calculation design and metadata conventions.
#LI-TE1
ADDITIONAL INFORMATION
Hiring Salary Range: $165,000.00 - 240,000.00.
The hiring salary range for this position applies to New York City, California, Colorado, Washington state, and most other geographies. Starting pay for the successful applicant depends on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable, as otherwise dictated by the appropriate Collective Bargaining Agreement. This position is bonus eligible.
What We Offer:- Attractive compensation and comprehensive benefits packages. Check out our full list of benefits here: https://www.paramount.com/careers/benefits
- Generous paid time off.
- An exciting and fulfilling opportunity to be part of one of Paramount's most dynamic teams.
- Opportunities for both on-site and virtual engagement events.
- Unique opportunities to make meaningful connections and build a vibrant community, both inside and outside the workplace.
- Explore life at Paramount: https://www.paramount.com/careers/life-at-paramount
