Reporting Analyst - Credit Administration

Job Summary

The Credit AdministrationReporting Analyst is responsible for producing and coordinating reporting activities, including maintaining an exceptional level of data accuracy across all sources including loan origination systems, the credit cube, and data lake.  Deliverables include bank wide as well as external (FDIC/Auditors/Shareholders) reporting which includes, but not limited to, risk rating migration, portfolio monitoring, policy exception, delinquency, watch lists, and negotiable collateral monitoring.  This individual will ensure timely presentation and delivery of reporting to relevant stakeholders, provide confidential support and communication on ad-hoc projects, and facilitate various audit and regulatory requests, retaining all supporting evidence, researching & resolving routine questions and problems.

Essential Functions

• Responsible for producing and circulating existing reports from various sources including, but not limited to, Enterprise Data Warehouse, Credit Cube, and Management Portal
• Recommend, build, and reconcile new reports using Power BI, including research and development of linkage of related keys across various data sources
• Generate and package monthly/quarterly extracts/reports for FDIC and/or auditors, including reconciliation to source data
• Generate and package quarterly extracts/reports for Finance, including reconciliation to source data for distribution
• Generate and package monthly extracts/reports for Lines of Business, including reconciliation to source data
• Create/maintain department policy, process and procedure documentation for the Credit Administration team
• Leverage tools including Signature (Core), nCino, Abrigo, and Microsoft Power BI for research and to produce ad hoc and ongoing bank-wide credit risk reporting
• Generate periodic and ad-hoc statistics and reports as requested
• Create and maintain organization for electronic storage of documents, including reasonable naming conventions
• Assist in new onboarding training for core systems including Signature and Nautilus
• Provide back-up support for all administration duties related to Credit Committee, Senior Loan Committee and Criticized Asset Committee
• Conduct IT related data testing and control monitoring
• Assist in strategic projects including merger/acquisitions, new product launches, system conversions, new tool/software implementations
• Ensure compliance with Northwest’s policies and procedures, and Federal/State regulations
• Navigate Microsoft Office Software, computer applications, and software specific to the department to maximize technology tools and gain efficiency
• Work as part of a team
• Work with on-site equipment

Education + Experience preferred

• Bachelor’s degree in Business, Accounting, Finance, Database Management, Economics or related field OR relevant industry experience
• 3 – 5 years of  experience in Credit, accounting, and/or deposit operations
• Advanced Microsoft Excel skills (pivot tables, VLOOKUP)
• Experience using Power BI

Location:

This position can be performed in a hybrid capacity across our footprint.

#LI-EK1

#LI-Hybrid