Oracle EPM/EPBCS Financial Systems Analyst

Western Alliance Bank; Phoenix (AZ); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

Ownership stake in the company

Medical and dental insurance

Time off

401k matching program

Tuition assistance program

Employee volunteer program

Wellness program

Job summary

Western Alliance Bank is seeking a Financial Systems Analyst to oversee Oracle EPM Cloud platforms (EPBCS, Smart View) and to partner with Finance, FP&A, and IT. You’ll ensure accurate data, govern processes, and support budgeting, forecasting, and reporting with a focus on automation and scalability.

The role combines data management, system governance, and end-user support to drive efficient financial processes.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Systems, Computer Information Systems, Computer Science, or a related field.
• 3+ years of experience supporting financial systems, FP&A processes, accounting systems, reporting platforms, or business intelligence tools.
• Hands-on experience with Oracle EPM Cloud, EPBCS or PBCS, Essbase, Oracle SmartView, planning applications, financial metadata, and business rules.
• Experience using Oracle Smart View for reporting, data retrieval, ad hoc analysis, and data submission.
• Working knowledge of budgeting, forecasting, month-end close, financial reporting, reconciliations, and variance analysis.
• Strong analytical, troubleshooting, communication, documentation, and stakeholder management skills.
• MS or MBA preferred.
• CPA, CMA, Oracle EPM certification, or relevant professional certification preferred.
• Experience in banking, FP&A, financial services, or a highly regulated environment preferred.
• Experience with Oracle EDM, PCMCS, EPM Automate, Data Management, Data Integrations, Narrative Reporting, Power BI, SQL, automation tools, or data warehouse platforms preferred.
• Experience documenting financial systems processes, internal controls, audit, system changes, and recurring operational procedures preferred.

Responsibilities

• Support the administration and maintenance of Oracle EPM Cloud applications, including EPBCS planning and reporting environments.
• Maintain and validate metadata, dimensions, hierarchies, forms, dashboards, reports, and business rules.
• Execute, monitor, and troubleshoot monthly, quarterly, and annual planning, forecasting, and reporting processes.
• Assist with testing Oracle EPM monthly updates, enhancements, patches, and configuration changes.
• Partner with Finance leadership and IT to support application security, access reviews, change management, and system governance.
• Load, validate, reconcile, and certify financial and operational data in EPBCS for actuals, forecasts, budgets, and management reporting.
• Support data integrations and recurring data feeds from Accounting, Treasury, ALM, HR, data warehouse, and other source systems.
• Investigate data quality issues and reconcile differences between source systems, EPBCS, Smart View reports, and downstream reporting outputs.
• Document key data flows, dependencies, control points, and recurring monthly processes.
• Identify opportunities to automate manual data preparation, validation, and reporting activities.
• Develop, maintain, and enhance Oracle Smart View templates, reports, templates, ad hoc retrievals, and recurring analysis workbooks.
• Train and support FP&A, Accounting, and business users on Smart View functionality, reporting standards, and best practices.
• Troubleshoot Smart View connection, retrieval, submission, formatting, and data refresh issues.
• Create clear documentation, user guides, standard operating procedures, and training materials for recurring financial systems processes.
• Support monthly forecast, annual budget, long-range planning, variance analysis, and executive reporting cycles.
• Partner with FP&A teams to understand reporting needs and translate business requirements into scalable system solutions.
• Assist with financial data analysis, trend analysis, and recurring management reporting packages.
• Support close and forecasting deadlines by coordinating data readiness, resolving system issues, and communicating status to stakeholders.
• Maintain process documentation and evidence for recurring close, forecast, budget, and reporting activities.
• Recommend and implement process improvements that increase efficiency, data accuracy, transparency, and user adoption.
• Collaborate with IT, Oracle Support, vendors, and business partners to resolve system issues and improve finance technology capabilities.

Skills

Analytical skills

Troubleshooting

Communication

Documentation

Stakeholder management

Education

Bachelor's degree in Finance/Accounting/IS/CS

Tools

Oracle EPM Cloud

EPBCS/PBCS

Essbase

Oracle Smart View

Data Management

Power BI

SQL

Job description

Western Alliance Bank is seeking a Financial Systems Analyst to oversee Oracle EPM Cloud platforms (EPBCS, Smart View) and to partner with Finance, FP&A, and IT. You’ll ensure accurate data, govern processes, and support budgeting, forecasting, and reporting with a focus on automation and scalability.

The role combines data management, system governance, and end-user support to drive efficient financial processes.