Oracle EPM Cloud Application & Integration Analyst
San Jose, CA, United States23h ago
Key details
- Location
- San Jose, CA, United States
- Work style
- Onsite
- Level
- Senior
- Job type
- Full-time
- Experience
- 5–8 yrs
- Function
- Finance & Accounting
- Focus area
- other
- Posted
- 23h ago
Skills
About the role
At Cadence, we hire and develop leaders and innovators who want to make an impact on the world of technology.
Department: IT – Enterprise Applications (Finance Systems)
Reports to: IT-Director, Enterprise Applications – SAP / EPM
Location: San Jose, CA (onsite/in-person)
Experience: 5–8+ years Oracle EPM / Hyperion; 3+ years SAP ECC FI/CO
About the Role
Cadence is looking for a hands-on Oracle EPM Cloud Application & Integration Analyst to own production support and continuous improvement of our Oracle EPM Planning platform (Financials, Capital, Workforce and Projects). You will be the go-to expert for application administration, business rules, data integrations from SAP, Coupa and Workday, security, and release management – partnering closely with FP&A, Accounting and HR stakeholders to keep planning and forecasting cycles running smoothly. The role also requires strong SAP ECC FI/CO knowledge to manage the finance data flowing from SAP into EPM and to support the related SAP finance processes.
Key Responsibilities
Production Support
• Own L2/L3 support for Oracle EPM Planning through the Jira service queue; triage, resolve and meet SLAs.
• Perform root cause analysis for critical and recurring incidents and implement preventive fixes.
• Raise and manage Oracle Service Requests (My Oracle Support) for product defects and platform issues.
• Support planning, budgeting and forecast cycles, including after-hours activities when needed.
Application Administration & Build
• Dimension management: maintain members, hierarchies, properties, attributes, UDAs and aliases; metadata loads; keep hierarchies aligned with SAP and Workday (Oracle EDM experience a plus).
• Form management: design and maintain data forms, composite forms, validation rules and form-level security.
• Create and maintain Smart Lists, dashboards, infolets, navigation flows and EPM / Financial Reports.
• Create and tune business rules (Calc Manager, Groovy) and rule sets; manage rule security (launch access).
• Administer security: users, groups, roles, data access permissions and SSO; support quarterly access reviews.
Data Management & Integrations
• Own Data Integration / Data Management: locations, import formats, data load rules, period and category maps.
• Maintain data load mappings (explicit, between, like, multi-dimension) and resolve unmapped-member errors.
• Support and monitor integrations: SAP Financials / Capital / Projects, Workforce.
• Automate loads, calculations, backups and reports using EPM Automate and scheduled jobs; reconcile data to source.
SAP ECC FI/CO
• Act as the SAP ECC FI/CO point of contact for EPM: company codes, GL accounts, cost centers, profit centers, internal orders and WBS elements that feed Financials, Capital and Projects.
• Keep SAP FI/CO master data (chart of accounts, cost center and profit center hierarchies) aligned with EPM dimensions and data load mappings.
• Reconcile SAP actuals (GL, cost center, asset and project balances) to EPM after each load; investigate and resolve differences with Accounting and FP&A.
• Support month-end and year-end close activities that affect the SAP-to-EPM actuals load, including period open/close, late adjustments and reloads.
• Troubleshoot SAP-side extract and interface issues with the SAP technical team, and support FI/CO tickets and small enhancements related to planning and reporting.
• Contribute to the SAP S/4HANA transition for EPM integrations, including changes to finance data sources and mappings.
Environment, Change & Release Management
• Coordinate Oracle monthly updates: regression testing in Test before Production rollout.
• Migrate changes from Test to Production following change control and business approval.
• Manage daily maintenance, snapshots / backup and restore, and environment refresh with HR data masking.
• Maintain SOX-compliant documentation: change records, test evidence, runbooks and knowledge articles.
• Act as a backup across all modules and help cross-train team members.
Required Qualifications
• Bachelor’s degree in Information Systems, Computer Science or related field.
• 5+ years of Oracle EPM / Hyperion Planning experience, including 2+ years on Oracle EPM Cloud (EPBCS / PBCS).
• 3+ years of hands-on SAP ECC FI/CO experience (General Ledger, AP/AR, Asset Accounting, Cost Center and Profit Center Accounting, Internal Orders), including period-end close and finance master data.
• Hands-on experience with Workforce, Capital and/or Projects modules in Planning.
• Strong skills in dimension management, forms, Smart Lists, dashboards and Smart View.
• Proven ability to create business rules and rule sets (Calc Manager; Groovy preferred) and manage rule security.
• Hands-on Data Integration / Data Management experience, including data load mappings and load troubleshooting.
• Experience integrating Oracle EPM with SAP FI/CO (actuals and master data loads); Workday integration experience strongly preferred.
• EPM Automate scripting; working knowledge of SQL.
• Experience with EPM security, Oracle monthly updates, migration and environment management.
• Solid understanding of budgeting, forecasting, capital and workforce planning processes.
• Production support experience using ITIL processes and a ticketing tool (Jira preferred).
Preferred Qualifications
• Oracle Enterprise Data Management (EDM), Narrative Reporting, or FCCS exposure.
• Coupa integration experience.
• SAP S/4HANA Finance exposure (Universal Journal / ACDOCA) or experience with an ECC to S/4HANA conversion.
• SAP FI/CO certification.
• EPM REST APIs, EPM Integration Agent or Oracle Integration Cloud (OIC).
• Scripting in PowerShell or Python.
• SOX / ITGC controls experience in a public company.
• Oracle EPM Planning Cloud Implementation Professional certification; ITIL 4 Foundation.
Key Competencies
• Strong analytical and troubleshooting skills – quickly isolates data, rule, metadata or integration issues.
• Clear communicator with finance and HR users; able to explain technical issues in business terms.
• Ownership mindset with disciplined documentation and follow-through.
• Works well under deadline pressure during planning and forecast cycles.
We’re doing work that matters. Help us solve what others can’t.
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.