EPM Analyst

About the role

We are a global investment bank specializing in M&A and private capital advisory services. Clients worldwide rely on us to help unlock value in their business and turn ambitious goals into reality.

Responsibilities

• Support the implementation, administration, and ongoing development of Oracle EPM applications.
• Support and maintain core Oracle EPM modules, including: FCCS (Financial Consolidation and Close), ARCS (Account Reconciliation Cloud Service), EDMC (Enterprise Data Management Cloud).
• Develop and maintain consolidation, reconciliation, budgeting, and forecasting processes.
• Support financial consolidations, intercompany eliminations, and close processes.
• Develop and maintain budgeting and forecasting models.
• Work with Fusion Essbase cubes and EPM data models.
• Develop and maintain reports using Smart View and Financial Reporting Studio.
• Support data loads and integrations from Oracle ERP into Oracle EPM.
• Partner with Finance and Accounting teams to support financial reporting and planning processes.
• Support reconciliation processes and account reconciliation automation.
• Auxiliary allocation rules, financial calculations, and consolidation rules.
• Maintain metadata, hierarchies, and master data within EPM applications.
• Document EPM processes, business rules, and system configurations.
• Assist with system upgrades, testing, and implementation activities related to Oracle EPM applications.

Requirements

• 5–7 years of experience working with Oracle EPM (strong experience with Oracle Hyperion may be considered if complemented by other relevant skills).
• Hands-on experience with Oracle EPM modules, including: FCCS (Financial Consolidation and Close), ARCS (Account Reconciliation Cloud Service), EDMC (Enterprise Data Management Cloud).
• Experience with Oracle ERP General Ledger (GL).
• Experience with Fusion Essbase cubes.
• Experience with Smart View and Financial Reporting Studio.
• Experience with budgeting and forecasting processes and systems.
• Experience with reconciliation and consolidation processes.
• Experience loading data from Oracle ERP into Oracle EPM.
• Strong understanding of financial statements, consolidations, and close processes.
• Experience working with Finance, Accounting, and FP&A teams.

Qualifications

• Bachelor’s degree
• Preferred: Oracle ERP consolidation in General Ledger, Allocation rules and financial calculations, Oracle EPM administration and security, Experience with Oracle ERP modules such as: Accounts Receivable (AR), Accounts Payable (AP), and Cash Management (CM), Fixed Assets (FA), Projects (PA), and Procurement (PO), Experience integrating Oracle ERP and Oracle EPM systems.

Skills

• Strong financial systems and accounting knowledge, with attention to detail and data accuracy
• Strong analytical and problem-solving skills
• Ability to work independently, manage multiple priorities and collaborate across Finance, Accounting, FP&A, and IT teams
• Strong communication and documentation skills
• Continuous improvement mindset and willingness to learn new technologies

Benefits

PNC offers a comprehensive range of benefits to meet your needs now and in the future. Depending on your eligibility, options for full-time employees include: medical/prescription drug coverage (with a Health Savings Account feature), dental and vision options; employee and spouse/child life insurance; short and long-term disability protection; 401(k) with PNC match, pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives. In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 9 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.