Sr. Commercial Reporting Analyst

Sr. Commercial Reporting Analyst

The Sr. Commercial Reporting Analyst is responsible for producing and coordinating reporting activities, including maintaining an exceptional level of data accuracy across all sources including loan origination systems, loan accounting systems, data lake and data warehouse. Deliverables include bank wide as well as external reporting which includes, but not limited to, risk rating migration, portfolio monitoring, policy exception, delinquency, watch lists, negotiable collateral monitoring, financial statement tracking, pipeline, covenant, maturity, loan approvals, and loan lifecycle time studies. 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 both routine and complex questions and challenges. This individual will ensure compliance with internal policies and external regulations for all reporting deliverables.

Essential Functions

• Develop in-line risk reporting, concentration monitoring, performance measurements, and KRI (Key risk indicators) with Line of Business and commercial-wide management dashboards.
• Recommend, build and reconcile new reports using Power BI or excel, including research and development of linkage of related data from various sources including loan origination systems, loan accounting systems, data lake and data warehouse.
• Generate and package monthly / quarterly extracts / reports for FDIC and / or auditors, including reconciliation to source data
• Generate and package weekly, monthly, quarterly extracts / reporting for business lines Credit Management in the Commercial Bank, including reconciliation to the source data for distribution
• Create / maintain procedures for data extraction and report creation
• Leverage tools including Signature, Moody's CreditLens, Abrigo, CustomerOne, Power BI, for research and to produce ad hoc and ongoing bank-wide credit risk reporting.
• Generate periodic and ad-hoc statics and reports as requested
• Create and maintain organization for electric storage of documents, including reasonable naming conventions
• Assist with the develop and on-going maintenance of process flow charts / diagrams
• Assist with the develop and on-going maintenance of org charts for the Commercial Bank
• Assist with onboarding activities for new employees
• Provide back-up support for all administration duties for the Loan Administration Team Lead
• Ensure policy exceptions, risk rating migration, loan maturities, delinquencies, are tracked and reported in order to monitor portfolio risk factors and minimize out of order situations.
• Ensure compliance with Northwest's policies and procedures, and Federal / State regulations
• Navigate Microsoft Office Software, computer applications, and software specific to the department in order to maximize technology tools and gain efficiency
• Work as part of a team
• Work with on-site equipment

Education + Experience

Bachelor's Degree in Economics, Finance, and / or Business preferred

5 - 6 years Financial institution / Banking experience required

2 - 3 years of experience in reporting analytics preferred

2 - 3 years of experience in portfolio management preferred

2 - 6 years of experience in regulatory reporting

Proficiency in Abrigo, Power BI, MS Excel

#LI-EK1

Northwest is an equal opportunity employer. We are committed to creating an inclusive environment for all employees.