This job has expired, please see additional jobs below
Treasury Analyst
Bank of the West
San Ramon, CA, United States
Job Details - this job has expired, please see similar jobs below
Description
What sets Bank of the West apart from other banks is our team members–they embody the optimistic spirit of the West. There is a spirit here that drives us to do more. Our team of more than 10,000 employees is vital to the success of our Bank. They reflect our modern western values—straightforward, entrepreneurial and optimistic. We seek to create a corporate culture that fosters and rewards excellence, encourages creative thinking and respects diversity – an environment where team members are engaged, supportive of one another and enthusiastic about serving our customers. Bank of the West offers the stability of a company that has a 135 year history and is part of BNP Paribas, a European leader in global banking and financial services and one of the 6 strongest banks in the world. We offer opportunities across our diverse business lines – Retail Banking, Commercial Banking, National Finance, and Wealth Management.
Job Description Summary
Primarily responsible for supporting PPNR forecasting necessary for CCAR and DFAST regulatory work streams.
Essential Job Functions
• Assists and performs CCAR and DFAST production runs to forecast balance and non-interest income and expense, including remediation of FDIC and FRB findings.
• Take responsibility of CCAR production Hyperion Essbase, including Data flow processes, Business Rules calculations, data accuracy.
• Builds processes and tools necessary to support regulatory stress testing, including those for QRM data upload to Hyperion, calculating various metrics such as CPI, Unused Commitment etc. Ensures these processes are efficient, repeatable and error-free.
• Validates and reconciles data in various systems. Works with LOB partners and/or external vendors on data definitions; collects and validates data for modeling and benchmarking purposes; finds solutions to bridge potential data gaps.
• Works with Financial Technology partners and the Planning team to develop system solution to handle balance roll forward and data transfer for key stake holders in the stress testing process.
• Creates and polishes to perfection presentation materials that are used for decision making in the Financial Forecasting Group. Automates generation of materials where appropriate.
• Conducts independent reviews (IDR) of statistical and qualitative model implementations.
• Shepherds models through the model validation process. Ensures on-time completions of independent reviews by interfacing with model developers, model owners and validators to ensure on-time completion of model implementations and independent reviews.
• Writes technical documentation for statistical and qualitative models, model implementations.
• Uses statistical concepts to review large volume of data for anomalies, and recommends remedial actions.
• Works with LOB partners and modelers on modeling approach, assumption; becomes SME on data and business characteristics for subject portfolios and develops statistical and qualitative predictive models to be used for CCAR Stress Testing.
• Works with Ad-hoc request coming from management or LOB.
• Other duties and projects as assigned.
Qualifications
Required Experience
• Requires advanced knowledge of job area typically obtained through advanced education combined with experience.
• May have practical knowledge of project management.
• Requires 5 years minimum prior relevant experience.
Education
• Bachelor's Degree Finance, Economics, or Mathematics - Required
• Master's Degree Finance, Economics, Mathematics - Preferred
Skills
• Familiarity with financial modeling
• Familiarity with GAAP and IAS/IFRS accounting rules as they apply to Bank investment portfolios.
• Familiarity with Bank regulatory guidelines.
• Commercial banking experience is a plus; familiarity with commercial banking products and processes is a plus
• Knowledge of stress testing and regulatory requirement for banking industry is a plus
• Ability to understand large volumes of multi-dimensional data, and manipulate it with SQL and VBA
• Ability to quickly process and internalize large volumes of information, such as regulatory guidance documents and model documentation
• Expert level Hyperion skills, including: knowledge of multi-dimensional data base, ability to manipulate with outline and implement calculation to increase performance, but not harm existing potential
• Expert level Excel skills, including: expert knowledge of advanced Excel features, such as array formulas and multi-dimensional lookups, ability to write robust, readable and re-usable VBA code, experience tracing data lineage over multiple Excel worksheets and files and expert in Excel charting
• Appropriate personality and character, including:
• Ability to work well with others in a dynamic, team-oriented environment
• Appreciation of a tight control process, ability and willingness to clearly document tools, results and other products of work
• Open mind and ability to quickly assimilate and understand unfamiliar information; and willingness to help and take assignments outside of the immediate area of responsibility
• Ability to create innovative solutions
• Ability to deal with changes, ambiguity, and uncertainty
• Organized and attentive to detail
• Self-starter and highly motivated. Able to manage multiple products, and effectively prioritize workload when dealing with multiple deadlines
Equal Employment Opportunity Policy
Bank of the West is an Equal Opportunity employer and proud to provide equal employment opportunity to all job seekers without regard to any status protected by applicable law. Bank of the West is also an Affirmative Action employer - Minority / Female / Disabled / Veteran.
Bank of the West will consider for employment qualified applicants with criminal histories pursuant to the San Francisco Fair Chance Ordinance subject to the requirements of all state and federal laws and regulations.