Senior Financial Systems Analyst Oracle EPM Cloud & FP&A - Financial Services

Senior Financial Systems Analyst Oracle EPM Cloud & FP&A

In the West Des Moines office 4 days a week, cloud and Hyperion experience needed. Possible contract to hire, no visa sponsorship at this time. Will start as a 1 year contract

The Senior Financial Systems Analyst will play a key role in developing and supporting Oracle EPM Cloud Planning solutions for Financial Planning & Analysis (FP&A), with a focus on Annuities, Cost of Funds, and Investment Planning. This role requires strong technical expertise in EPM Cloud, data management, automation, and Groovy scripting, along with domain knowledge of financial modeling for insurance, investments, and capital management.

The ideal candidate will collaborate with Finance and IT teams to enhance system functionality, streamline data integration, and improve financial reporting.

• EPM Cloud Administration & FP&A Support Develop and maintain Oracle EPM Cloud Planning applications, ensuring optimal performance for budgeting, forecasting, and financial planning. Work closely with Finance to improve financial modeling, scenario planning, and investment projections.
• Data Management & Integration Develop and support EPM Automate scripts, Data Management (DM), and integrations between EPM applications, Oracle ERP (R12 preferred), actuarial models, investment systems, and other financial platforms to ensure accurate data flow.
• System Enhancements & Performance Optimization Implement system upgrades, enhancements, and infrastructure updates, troubleshoot technical issues, and optimize system performance for efficiency and reliability.
• Advanced Reporting, Analytics & Scripting Utilize Smart View, Hyperion Financial Reporting (HFR), Essbase, and Groovy scripting to build automated calculations, validations, and advanced financial reports that support business decision-making, with a focus on cost of funds, asset-liability management, and investment return projections.
• Deployment & Change Management Support system migrations, upgrades, and process improvements, collaborating with onshore and offshore teams to ensure seamless execution.

• Bachelor's degree or equivalent professional work experience.
• 5+ years of experience in Oracle EPM Cloud Planning and legacy Hyperion applications (Planning, Essbase, HFM, FDMEE).
• Strong knowledge of financial planning, budgeting, and forecasting, with expertise in EPM Automate, Data Management (DM), and integrations with Oracle ERP (R12 preferred).
• Domain expertise in Annuities, Cost of Funds, Investments, and Financial Modeling for insurance and asset-liability management.
• Proficiency in Groovy scripting for automation, business rule customization, and performance optimization.
• Advanced proficiency in Excel, Smart View, Essbase Spreadsheet Add-in, HFR, and experience troubleshooting EPM Cloud environments.

• Experience with Oracle Cloud EPM modules (EPBCS, FCCS, EDMCS).
• Knowledge of MDX, SQL, VBA, or Python for automation and performance tuning.
• Familiarity with cloud migration strategies, actuarial data integration, and investment portfolio analytics.