Sr Business System Analyst, Oracle EPM

About the job

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.

How You'll Help Move Us Forward

• 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.

The Experience You Will Bring

• 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. BlackLine 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 SmartView for report creation and submission of data into Oracle EPM applications.

What Will Make You Stand Out

• Experience supporting multi-currency global Oracle EPM implementation
• Experience with Oracle Analytics Cloud

Base Pay Range

The base pay range noted represents the company’s good faith minimum and maximum range for this role at the time of posting. The actual compensation offered to a candidate will be dependent upon several factors, including but not limited to experience, qualifications and geographic location. Also, most employees are eligible for additional incentive pay.

Your Benefits Start Day 1

Your wellbeing is important to Pacific Life, and we’re committed to providing you with flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we’ve got you covered.

• Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents
• Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off
• Paid Parental Leave as well as an Adoption Assistance Program
• Competitive 401k savings plan with company match and an additional contribution regardless of participation

EEO Statement

Pacific Life Insurance Company is an Equal Opportunity /Affirmative Action Employer, M/F/D/V. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at Pacific Life Insurance Company.