Sr Business System Analyst, Oracle EPM

Job Description

Providing for loved ones, planning rewarding retirements, saving enough for whatever lies ahead – our policyholders count on us to be there when it matters most. It’s a big ask, but it’s one that we have the power to deliver when we work together. We collaborate and innovate – pushing one another to transform not just Pacific Life, but the entire industry for the better.

Why? Because it’s the right thing to do. Pacific Life is more than a job, it’s a career with purpose. It’s a career where you have the support, balance, and resources to make a positive impact on the future – including your own.

We’re actively seeking a talented Sr. Business System Analyst, Oracle EPM to join our Enterprise Financial Solutions team in Newport Beach, CA. As a Sr. Oracle EPM Business System Analyst you'll help move Pacific Life, and your career forward, by ensuring the reliability, interoperability, and sustainability of the various Oracle EPM (Financial Consolidation & Close, Account Reconciliation, Narrative Reporting) and Oracle EDM applications utilized by the Enterprise users.

As a member of the Enterprise Financial Solutions team, this position maintains, modifies, synchronizes, and optimizes multiple Oracle financial solutions to enhance application performance and meet ongoing and future business requirements. This position collaborates with the FP&A and Accounting teams to identify needs and opportunities for new systems and then evaluates each system to determine best business practices. This position will also focus on improving accuracy, ease and timeliness of financial reporting through proper design, configuration and automation of data within the various Oracle EPM applications.

• Responsible for the daily operations of Oracle EPM applications and their availability to our end users.
• Troubleshoot FCC/ARCS/EDM/Essbase/Smart View/Narrative Reporting issues and provide resolution.
• Load required data into Oracle EPM applications with appropriate checks and controls.
• Review financial data within and between FCC, Planning and Essbase to identify any issues and make necessary corrections.
• Provide application support, user support, security, and other ad‑hoc requests.
• Manage metadata by adding new members as well as modifying dimensions and hierarchies through EDM.
• Responsible for designing, creating, and maintaining business rules, CDM load rules, data forms and task lists.
• Work with Enterprise Finance Technology and outside consulting firms in identifying and resolving environment (database, OS, network, security, etc.) issues.
• Support monthly systems closes, forecasts, budgets, and related reporting responsibilities.
• Create, modify, and maintain various financial reports to accurately reflect business performance.
• Prepare documentation where necessary, including process flows and system structure.
• Communicate system changes and coordinate and/or perform testing of system modifications.
• Assist with the development of training materials as and when necessary.
• Special projects and other duties assigned.

• Bachelor’s degree in Accounting, Finance, or related discipline.
• Strong functional knowledge on FCCS and ARCS.
• 2+ years technical experience supporting Oracle EPM FCC/ARCS/Narrative Reporting and/or Essbase or similar tools in the financial close, reconciliation and reporting space (e.g. Black Line and SAP Business Planning and Consolidation).
• 2+ years working with business rules, data forms, batch processes and calc scripts.
• Familiar with accounting and financial reporting requirements as well as ERP‑related systems and concepts.
• Strong analytical, troubleshooting, and problem‑solving skills.
• Proven ability to meet deadlines, prioritize workloads, maintain attention to detail and work independently in a fast‑paced and rapidly changing environment. Ability to multi‑task.
• Highly skilled in ‘power user’ functions in Microsoft Excel.
• Working knowledge of Smart View for report creation and submission of data into Oracle EPM applications.

• Experience supporting multi‑currency global Oracle EPM implementation.
• Experience with Oracle…