Sr. Commercial Reporting Analyst

Northwest Bank; United States; Remote; USD 70,000 - 90,000; Full time

Job summary

A financial institution is seeking a Sr. Commercial Reporting Analyst to manage comprehensive reporting activities. Responsibilities include generating bank-wide reports and ensuring compliance with regulations. The ideal candidate will possess a Bachelor's degree in a relevant field along with significant experience in financial institutions. This position can be performed remotely for eligible candidates.

Qualifications

• Bachelor's degree preferred with experience in banking.
• 5-6 years of experience in a financial institution required.
• Proficiency in reporting analytics and portfolio management.

Responsibilities

• Produce and coordinate bank-wide and external reporting.
• Ensure compliance with internal policies and regulations.
• Generate periodic and ad-hoc reports for stakeholders.

Skills

Financial reporting

Analytical skills

Power BI

Microsoft Excel

Regulatory compliance

Education

Bachelor's Degree in Economics, Finance, or Business

Tools

Power BI

Abrigo

Signature

CustomerOne

Job description

Job Description

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 (FDIC/Auditors/Shareholders) 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

This position can be performed remotely, unless you live within 40 miles of one of our Hub locations. Hub locations:
INDEPENDENCE, OH: 6480 Rockside Woods Blvd S, Suite 345, Independence, OH 44131
COLUMBUS, OH: HQ, 3 Easton Oval, Columbus, OH 43219
BUFFALO, NY: 375 Essjay Road, Suite 100, Buffalo, NY 14221
MOUNT JOY, PA: 101 East Main Street, Mount Joy, PA 17552
WARREN, PA: 100 Liberty Street, Warren, PA 16365
ERIE, PA: 800 State Street, Erie, PA 16501
PITTSBURGH, PA: Bellevue, 532 Lincoln Avenue, Bellevue, PA 15202 and Pittsburgh Business Office, 525 William Penn Place, Suite 3550, Pittsburgh, PA 15222
FISHERS, IN: 11 Municipal Drive, Suite 150, Fishers, IN 46037

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