Address
Form of workJob 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
Education + Experience preferred
Location:
This position can be performed in a hybrid capacity across our footprint.
#LI-EK1
#LI-Hybrid
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
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
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
