Senior Pipeline Analyst

Position Overview:

This individual will be responsible for supporting day-to-day oversight to ensure critical service level milestones are achieved. Responsible for pulling daily reporting and directly teams on non-negotiables. Integral part in maintaining employee tables, pipeline and production analytics, loan assignment/re-assignment, and ad-hoc reporting.

Essential Job Functions

• Proficient in handling large Data Sets Using Excel (Required), Access (Required) & Good power point presentation skills
• Analyzing the needs of internal departments and assisting staff with development
• Reviewing code to ensure best practices are in place
• Analyze complex data to develop automated reporting with VBA and Excel
• Create macros to work with a huge amount of data and for Excel reports
• Develop VBA programs to perform tasks automatically
• Proven ability to work effectively in a fast-paced, schedule driven, team-oriented environment.
• Performs data analysis by using existing reporting and Microsoft excel to filter and compile data to enable the production managers to effectively manage their pipeline
• Demonstrates proactive problem solving skills
• Work on complex macros and complex Excel functions to achieve the solution
• Analyze data and run data to identify production impediments or conflicts and develop corrective actions/processes immediately
• Reports/dashboard generation / Publishing Daily / Weekly / Monthly
• Document processes and procedures as required
• Handle manual assignment and re-assignments of loans
• Push reporting to team leaders and members to ensure daily non-negotiables are achieved, particularly those related to compliance adherence
• Identify areas of opportunity and efficiencies from a pipeline reporting perspective, for team members to close production and/or service level gaps

Requirements

• Demonstrate impeccable written and verbal communication skills
• Ability to accept challenges and tackle difficult situations and meet the expected goals
• Must be self-motivated, creative and able to work in a team environment while thinking independently and sharing knowledge and ideas
• Must be able to multi task between multiple analytical projects and able to adapt to constant modification of the work flow
• Strong computer skills
• Advanced Microsoft Excel and Power Point proficiency
• Detail oriented and focused
• Adhering to principles & values
• Strong analytical skills and problem solving skills
• Ability to work in a fast paced environment
• Communicate effectively with meaningful and articulate verbal discussions.