Reverse Engineering Consultant 1
This position is within Corporate Trust Services (CTS).
Wells Fargo Bank is the Premier provider of Corporate Trust Services. We are currently seeking a highly motivated dynamic individual to fill a Financial Modeler (Reverse Engineering Consultant 1) position in the Corporate Trust Services Group. The Corporate, Municipal, and Escrow Services (CMES) Analytics Group builds and maintains payment calculation tools primarily using Excel. These spreadsheets are built in compliance with legal documents and are used by the CMES deal teams to calculate monthly bond payment. This team's process is a key risk and quality control function and is instrumental in improving the efficiency and accuracy of bond payments.
Duties include, but are not limited to:
Develop and maintain cash flow models and bond payment tools in Excel
Understand, interpret and analyze legal documents on a variety of Structured Products
Assist in troubleshooting and problem solving
Recommend and implement automated solutions to replace any manual or semi-automated processes
Develop and implement departmental procedures, policies, and controls in order to maintain the accuracy and efficiency of processes and minimize the risk of incorrect production output
Lead or actively participate in projects, including assisting systems support groups with design, programming, analysis, testing, and implementation
Complete special projects in a timely and efficient manner
Identify and communicate processing issues
Team members support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit's risk appetite and all risk and compliance program requirements.
- 1+ year of mortgage finance experience, securitization modeling experience, or a combination of both; or a BS/BA degree or higher
- Strong organizational, multi-tasking, and prioritizing skills
- Excellent verbal, written, and interpersonal communication skills
- Intermediate Microsoft Office skills
- Strong analytical skills with high attention to detail and accuracy
Other Desired Qualifications
- Four year degree in Finance, Math, Computer Science or other analytical discipline
- Masters or other graduate level work in an analytical discipline
- Proficient/expert in Excel, VBA macros and other MS Office tools including Access
- Knowledge of the following structured products: state and local housing agencies, municipal debt, corporate debt, ABS student loans
- Strong grasp of securitized product deal structures & financial math
- Knowledge of bond payment calculations.
- Experience with securities legal documents such as Trust Agreements, Indentures, Prospective Supplements, Pooling and Servicing Agreements, and Private Placement Memorandums
All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act.
Relevant military experience is considered for veterans and transitioning service men and women.
Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.
0158785 WHOLESALE BANKING
Meet Some of Wells Fargo's Employees
Lauren audits Wells Fargo’s financial reports to assess accuracy and risk. She reviews processes in place, analyzes management controls, and communicates calculations and findings with business partners.
Back to top