Performing analysis to assess the quality and meaning of data required.
Understanding and working with various table structures as well as the data warehouses, lakes that are either primary or secondary sources such as Snowflake.
Knowledge of programming languages like Python , ETL framework , reporting packages
Using tools like Tableau, Microsoft Tools (excel) to represent the data in a visual format that is easy to understand.
Reviewing, ensuring accuracy of the data and recognizing anomalies in data between the data warehouse, data tapes and the loan accounting systems
Research and documentation of the data analysis against each of the commercial portfolio from the loan accounting system specifically AFS Level III
Map the fields, tables from AFS Level III to a target accounting system for migration purposes.
Assist in the on-going monitoring and review of existing transactions to support servicing teams as part of the ongoing production support.
Preferably experience with Heritage First Republic Commercial Lending Core Systems i.e AFS Level III , Loan Vantage ; Enterprise Data Marts
Familiar with the full SDLC and with production support experience.
Agile experience required.
Desired Qualifications
Perform duties and responsibilities specific to department functions and activities.
Bachelor’s Degree in Computer Science required.
Strong technical skills and demonstrated ability to quickly learn and adapt to and use new technologies.
Demonstrated analytical and problem-solving skills; including experience analyzing business problems, identifying solutions and driving the team to the solution.
Excellent Verbal and Written Communication skills; meeting facilitation and experience communicating and presenting solutions for business problems to business stakeholders;
Outstanding organization and prioritization skills
Experience with multitasking and to function efficiently in a high volume, high risk and fast paced deadline-oriented environment.
Self-starter requiring minimal oversight to achieve defined goals.