Oracle EPM Cloud Application & Integration Analyst
Cadence Design Systems · SAN JOSE, CA · Onsite
What they ask for
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.