About this role: 

Wells Fargo is seeking a Senior Analytics Assistant for electronic reporting activities under collateral monitoring. Electronic reporting involves preparing client files and analyzing the results for each collateral reporting update during the credit life cycle to correctly identify and evaluate the ineligible collateral. 

In this role, you will: 

• Review and prepare collateral reporting files received from the clients for processing & inventory various reports.  

• Perform additional file format due diligence by reviewing various file types & troubleshooting various file formats. 

• Partner with multiple teams to resolve any issues that arise during each reporting cycle (technical processing team members, collateral analysts, relationship managers, field examiners, and in some situations, clients) 

• Perform trend analysis and exception report review, root cause analysis to identify the probable causes for variation in total gross collateral on the Ineligibles Schedule. Seek second level review as needed. 

• Identify the key fields and their source and check the source files to see if the information is logical and being picked up correctly by the processing tool. 

• Create final ineligibles schedule against the clients collateral reporting files. 

• Support performance of less experienced staff and overall effectiveness of team 

• Proactively provide feedback and present ideas for improving or implementing processes and tools 

• Perform complex administrative transactional and operational support tasks 

• Participate in research, tracking, and data gathering related to projects & update project logs 

• Provide subject matter expertise and interpretation of procedures to less experienced staff

• Interact with team, functional area, internal peers outside work group, and manager on planning and performing analysis, trends, and presentation design 

Required Qualifications:

• 4+ years of Analytics and Reporting experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

 Desired Qualifications

• Advanced level Excel skills, good command of complex & nested formulas. Knowledge of VBA will be an advantage. 

• Experience in exploratory data analysis, data validation & cleaning, data visualization & outlier identification, reporting & insights will be preferred. 

• Fair understanding of the credit life cycle, line of credit & collaterals and their types.