Senior Financial Systems Analyst (46987)

Job Description

Palmer Group has partnered with a West Des Moines company in their search for a Senior IT/ Financial Systems Analyst. This individual will play a pivotal role in developing and supporting Oracle EPM Cloud Planning Solutions for FP&A, with a focus on Annuities, Cost of Funds, and Investment Planning.

Work model:

-Hybrid
-4 days in office, 1 day remote

What you will do:

-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
-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
-Implement system upgrades, enhancements, and infrastructure updates, troubleshoot technical issues, and optimize system performance for efficiency and reliability
-Utilize SmartView, 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
-Support system migrations, upgrades, and process improvements, collaborating with onshore and offshore teams to ensure seamless execution

What you need to be successful:

-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, SmartView, 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