Borrowing Base Services - Associate Analyst

Wells Fargo Bank•Chicago, IL

4d•$25 - $42•Hybrid

About The Position

Wells Fargo is seeking a Borrowing Base Services - Associate Analyst in Wells Fargo Commercial Capital as part of Commercial Bank. Learn more about the career areas and lines of business at wellsfargojobs.com . In this role, you will: BBC post-posting review – completing review of BBC posting reconciliations and confirmation of various related components, including Excel formula validation and SOR calculation results Collateral reporting file review – inventorying reports, reviewing different types of standardized and ad-hoc/non-standard collateral files for various information, troubleshooting Excel files, validating client-supplied and internally automated calculations Partnering with multiple teams to resolve any issues that arise during each reporting cycle (technical processing team members, WFI&P support teams, relationship managers, field examiners, clients) Performing trending analysis and anomaly identification, escalating potential issues to appropriate audiences, and maintaining all required documentation in appropriate repositories Assisting with special assignments and projects as needed, including designing new workflows and BAU processes for next-generation reporting platform Maintaining up-to-date knowledge of department processes and guidelines and actively developing individual BBC and other tool-related skill proficiency

Requirements

2+ years of Commercial Valuations support experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Nice To Haves

Prior experience in relevant Wells Fargo systems, including: OneView, LUCAS, Vantage/Capital Finance/CEO, LoanIQ
Prior experience reviewing and managing ABL borrowing bases and underlying reporting
Above-average time management skills, including appropriately balancing competing priorities and thriving in an environment with highly cyclical workflow both in terms of work volume and work deadlines/time-sensitivity
Consistent, reliable attention to detail and high standard of accuracy, while also being able to “zoom out” and consider materiality and other broader-perspective variables
Strong technical acumen: a solid grasp of intermediate-level Excel skills (vlookups, pivot tables, building formulas) demonstrates appropriate aptitude for supporting legacy Excel-based BBC templates
Curiosity and a strong desire to learn more and develop skills independently – learning is a mindset, not a task to complete
Flexibility – our world is ever-evolving, and we are committed to continual improvement to better support our internal and external partners, including embracing new systems and processes while continuing to support legacy solutions during periods of transition

Responsibilities

BBC post-posting review – completing review of BBC posting reconciliations and confirmation of various related components, including Excel formula validation and SOR calculation results
Collateral reporting file review – inventorying reports, reviewing different types of standardized and ad-hoc/non-standard collateral files for various information, troubleshooting Excel files, validating client-supplied and internally automated calculations
Partnering with multiple teams to resolve any issues that arise during each reporting cycle (technical processing team members, WFI&P support teams, relationship managers, field examiners, clients)
Performing trending analysis and anomaly identification, escalating potential issues to appropriate audiences, and maintaining all required documentation in appropriate repositories
Assisting with special assignments and projects as needed, including designing new workflows and BAU processes for next-generation reporting platform
Maintaining up-to-date knowledge of department processes and guidelines and actively developing individual BBC and other tool-related skill proficiency