Financial Systems Analyst
Western Alliance Bancorporation
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Western Alliance Bank is seeking a Financial Systems Analyst to manage Oracle EPM Cloud (EPBCS), Smart View reporting, and data integration support. The role collaborates with Finance, FP&A, Accounting, Treasury, IT, and other stakeholders to ensure accurate, timely financial data for budgeting, forecasting, and management decisions.
Responsibilities include administering EPBCS, loading and reconciling data, improving reporting templates, and supporting month-end close and variance analysis.
Qualifications
- Bachelor's degree in Finance, Accounting, Information Systems, or related field.
- 3+ years of experience supporting financial systems, FP&A processes, accounting systems, or BI tools.
- Hands-on experience with Oracle EPM Cloud, EPBCS/PBCS, Essbase, and Oracle Smart View.
- Experience using Oracle Smart View for reporting, data retrieval, and data submission.
- Knowledge of budgeting, forecasting, month-end close, financial reporting, reconciliations, and variance analysis.
Responsibilities
- Administer Oracle EPM Cloud applications including EPBCS planning and reporting environments.
- Maintain metadata, dimensions, hierarchies, forms, dashboards, reports, and business rules.
- Support monthly/quarterly/annual planning, forecasting, and reporting processes.
- Test Oracle EPM updates, enhancements, patches, and configuration changes.
- Collaborate with Finance and IT on security, access reviews, change management, and governance.
- Load, validate, reconcile, and certify data in EPBCS for actuals, forecasts, budgets, and reports.
- Support data integrations from source systems and data quality issue investigations.
- Develop, maintain, and enhance Smart View templates and reports; train end-users.
Skills
Education
Tools
Job description
Financial Systems Analyst
CityScape
The Financial Systems Analyst supports the administration, optimization, and ongoing operation of the organization's Oracle Enterprise Performance Management platform, including Oracle EPBCS and Smart View. This role partners with Finance, FP&A, Accounting, Treasury, ALM, IT, and other business stakeholders to ensure financial data is accurate, timely, well controlled, and available for budgeting, forecasting, reporting, and management decision-making.
The ideal candidate brings a strong blend of finance, accounting, systems, reporting, and analytical skills, with the ability to troubleshoot financial data issues, support month-end forecasting activities, improve Smart View reporting, and help modernize financial systems processes.
- 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.
- Support SOX, audit, access management, data governance, and documentation requirements for financial systems processes.
- 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.
- 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.
- competitive salaries
- an ownership stake in the company
- medical and dental insurance
- time off
- a great 401k matching program
- tuition assistance program
- an employee volunteer program
- a wellness program
- In addition, you'll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!
Western Alliance Bank, Member FDIC, is a wholly owned subsidiary of Western Alliance Bancorporation. Serving clients nationwide, Western Alliance Bank includes six legacy bank brands - Alliance Association Bank, Alliance Bank of Arizona, Bank of Nevada, Bridge Bank, First Independent Bank and Torrey Pines Bank - that remain part of the company’s heritage, as well as AmeriHome Mortgage, a Western Alliance Bank Company.
Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR@westernalliancebank.com or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.
Western Alliance Bancorporation
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
