Davis Polk & Wardwell LLP (including its associated entities) is an elite global law firm with world-class practices across the board. Clients know they can rely on Davis Polk for their most challenging legal and business matters. From offices in the world's key financial centers and political capitals, our more than 1,000 lawyers collaborate seamlessly to deliver exceptional service, sophisticated advice and creative, practical solutions. Visit davispolk.com.
Position Summary
The Assistant, System 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.
Essential Duties and Responsibilities
Typical responsibilities include, but are not limited to, the following:
Validate daily data integrations between Oracle EPM and other financial systems and take remedial actions to quickly troubleshoot and fix any issues that arise.
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 Oracle EPM environment that increase EPM functionality.
Maintain existing and create new business rules, calculation scripts and data load rules for Oracle EPM.
Create documentation of Oracle EPM processes.
Work with FP&A on projects and analysis utilizing Oracle applications as a data source.
Qualifications/Position Requirements
Proven experience using Oracle Cloud EPM including knowledge of administrative functions.
Exposure to Oracle Essbase (On-prem database) is a plus, but not required.
Knowledge of FP&A functions such as the reporting, budgeting and forecasting of headcount, finance and productivity data.
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.
Education and/or Experience
2+ 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.
Compensation
The expected base salary for this position ranges from $80,000 - $100,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, anticipated assignment, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. Davis Polk offers a competitive salary and comprehensive benefits package.