Sr. Commercial Reporting Analyst
: Job Details :

Join to apply for the Sr. Commercial Reporting Analyst role at Northwest Bank

3 weeks ago Be among the first 25 applicants

Join to apply for the Sr. Commercial Reporting Analyst role at Northwest Bank

Get AI-powered advice on this job and more exclusive features.

Job DescriptionThe 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.

Job DescriptionThe 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 Northwests 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 which are listed below. If you live within 40 miles of one of the locations listed below, you must be onsite Monday - Thursday with Friday as an optional work from home day.INDEPENDENCE, OH

• 6480 Rockside Woods Blvd S

Suite 345Independence, OH 44131COLUMBUS, OH

• HQ

3 Easton OvalColumbus, OH 43219BUFFALO, NY

• 375 Essjay Road

Suite 100Buffalo, NY 14221MOUNT JOY, PA

• 101 East Main Street

Mount Joy, PA 17552WARREN, PA

• 100 Liberty Street

Warren, PA 16365ERIE, PA

• 800 State Street

Erie, PA 16501PITTSBURGH, PA

• Bellevue

532 Lincoln AvenueBellevue, PA 15202

• Pittsburgh Business Office

525 William Penn PlaceSuite 3550Pittsburgh, PA 15222FISHERS, IN

• 11 Municipal Drive

Suite 150Fishers, IN 46037Northwest is an equal opportunity employer. We are committed to creating an inclusive environment for all employees.

Seniority level

• Seniority levelMid-Senior level

Employment type

• Employment typeFull-time

Job function

• Job functionResearch, Analyst, and Information Technology
• IndustriesBanking

Referrals increase your chances of interviewing at Northwest Bank by 2x

Get notified about new Senior Reporting Analyst jobs in Indiana, United States.

Indianapolis, IN $81,000.00-$138,000.00 2 hours ago

Indianapolis, IN $40.00-$45.00 2 weeks ago

Indianapolis, IN $120,000.00-$150,000.00 2 weeks ago

Indiana, United States $47.00-$53.00 1 week ago

Fort Wayne, IN $120,000.00-$150,000.00 2 weeks ago

Indianapolis, IN $70,000.00-$100,000.00 5 days ago

Indianapolis, IN $50.00-$57.00 2 weeks ago

Indianapolis, IN $45.00-$50.00 17 hours ago

Fishers, IN $65,463.00-$79,902.00 1 month ago

Cybersecurity Business Analyst - Business Units

Indianapolis, IN $63,750.00-$145,200.00 3 weeks ago

Information Technology & Digital Senior Business Analyst - Research & DevelopmentSenior Business Analyst - Digital Transformation & AISr. Data Analyst & Business Partner - MerchandisingSUPPLY CHAIN Analyst (0-5 Years Data Analysis Experience)

Indianapolis, IN $65,000.00-$95,000.00 6 days ago

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr