Systems Administrator – Oracle EPM

Davis Polk & Wardwell LLP•New York, NY

1d•Onsite

About The Position

The Systems Administrator – Oracle EPM reports to the Manager, Financial Data and Systems and will be responsible for the daily oversight and administration of the firm’s Oracle EPM applications. The role is responsible for ensuring that the firm’s Oracle EPM applications are functioning optimally to provide accurate and timely data to EPM users and other reporting systems.

Requirements

Proven experience using Oracle Cloud EPM including knowledge of administrative functions.
Highly proficient user of Microsoft Excel including complex modeling.
Strong analytical and problem-solving skills.
Excellent written and verbal communication skills.
Ability to work collaboratively in a team environment.
Attention to detail and strong organizational skills.
3+ years of Accounting/Finance or Financial Systems experience including working with Oracle EPM applications, ideally in a law or professional services firm.
Bachelor's degree in Business Administration, Finance, Accounting, Information Technology, or a related field.

Nice To Haves

Exposure to Oracle Essbase (On-prem database) is a plus, but not required

Responsibilities

Validate daily inbound and outbound data integrations between Oracle EPM and other financial systems and take remedial actions to quickly troubleshoot and fix data discrepancies or failures in the integration processes.
Maintain and update dimension hierarchies in Oracle Cloud and On-prem applications.
Lead efforts to quickly understand, find the root cause and resolve system issues for Oracle EPM users.
Maintain and update multi-layered user access and granular security to Oracle EPM applications.
Run and validate month-end processes to load GL data from non-Oracle ERP system to Oracle EPM.
Create new data integration processes.
Run and validate monthly revenue and expense allocation models in Oracle Profitability and Cost Management application.
Update models as necessary to reflect changes to allocation methodologies.
Collaborate across departments and with Financial Systems team on enhancements to current EPM environment and to build out EPM architecture and functionality by implementing additional modules.
Maintain existing and create new business rules, calculation scripts and data load rules for Oracle EPM.
Create documentation of Oracle EPM processes and procedures.