Credit Systems Analyst

First Commonwealth Bank; Pennsylvania; On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Telecommuting may be eligible

Job summary

First Commonwealth Bank is seeking a Credit Systems Analyst to review the structure, content and quality control of reports used in calculating the Allowance for Credit Loss (ACL). The role supports audits, process improvements, and reporting for policy exceptions, financials, covenants, and criticized assets.

The incumbent works with multiple departments, develops partnerships to understand business drivers, and can lead projects with limited supervision in a collaborative team environment.

Qualifications

• Bachelor's degree or equivalent experience in business, accounting, finance, economics or related field.
• At least two years of related lending/credit, report writing, core systems or related activities.
• Strong data analysis skills are required.
• Outstanding verbal and written communication across all levels of the organization.
• Advanced problem solving skills and analytical planning; work independently.
• Proficient Word, Excel, Access.
• Must have a valid driver's license; travel may be required between Indiana, PA, Pittsburgh, PA and NE Ohio.
• May be eligible for telecommuting.

Responsibilities

• Develops and produces advanced, standard and ad hoc department and enterprise-level credit reporting.
• Ensures accurate report production for Credit Committee and other staff meetings.
• Develops, maintains and reconciles models used in ACL calculations.
• Reviews structure and quality of internal and system-generated reports.
• Assembles, compiles, and resolves data errors to ensure consistency.
• Streamlines processes and reports; participates in special projects.
• Deletes and appends records for system consistency.
• Tracks policy exceptions, financial statements and covenants with analyses.
• Maintains and updates the department's business continuity plan.
• Supports and provides direction to other Credit Systems Analysts on reporting solutions.
• Leads some Credit Systems projects and updates management on status.
• Completes other related duties as assigned.

Skills

Data analysis

Verbal and written communication

Problem solving

PC skills (Word, Excel, Access)

Driver's license

Telecommuting flexibility

Education

Bachelor's degree in Business, Accounting, Finance, Economics or related field or equivalent experience

Tools

SQL

SQL Server Management Studio

Microsoft Report Builder

Job description

The incumbent will develop strong partnerships and will work with multiple departments to review the structure, content and quality control and quality assurance of identified critical and system-generated reports utilized by Credit Systems in calculating the Allowance for Credit Loss (ACL). The position will assist with maintaining and improving the structure and reporting process with respect to policy exceptions, financials, covenants, criticized assets, watch lists, and annual reviews as needed. The incumbent will support management with the planning, design and execution of departmental audits and reviews. The position can work independently under limited supervision as well as a member of a department or project team.

1. Develops and produces advanced, standard and ad hoc department and enterprise-level credit reporting. Ensures accurate report production for Credit Committee, other committees and/or other staff meetings as assigned.
2. Develops, maintains and reconciles independent models used in calculating the quarterly Allowance for Credit Loss (ACL).
3. Works with multiple departments to review the structure, content and quality of internal and system-generated reports. Develops strong partnerships to aid in understanding of underlying business drivers that may affect reporting.
4. Adheres to applicable credit/operational risk controls in accordance with Company and regulatory standards and policies. Keeps abreast of business and credit risk trends that may affect reporting.
5. Assembles, compiles, and resolves errors/inconsistencies in data from various business partners to ensure consistency in reporting.
6. Streamlines current processes and reports, and works on various special projects to improve the department's efficiency.
7. Deletes and appends records (for the above systems) for consistent information.
8. Utilizes specialized reporting that requires the ability to resolve complex issues in creative and effective ways by applying professional concepts and bank objectives for the following:
   • Tracking Policy Exceptions and running analysis reports.
   • Tracking/monitoring financial statements and running analysis reports.
   • Tracking/monitoring financial covenants and running analysis reports.
9. Maintains and updates the department business continuity plan.
10. Supports and provides direction to other Credit Systems Analysts on business reporting and analytic solutions as necessary.
11. Ability to lead some Credit Systems projects and update management on the status.
12. Complete other related duties as assigned.

Bona Fide Occupational Qualifications

Required

1. Bachelor's degree in Business, Accounting, Finance, Economics or related field or have equivalent experience.
2. At least two years of related work experience in lending/credit, report writing, core systems or related activities are encouraged.
3. Strong data analysis skills are required.
4. Outstanding verbal and written communication skills and interpersonal skills. Communicate across all levels of the organization as well as externally with auditors, examiners and software vendors. Present clear and concise reporting to senior level management.
5. Advanced problem solving skills and analytical planning. Possess the ability to work independently in providing solutions to complex and diverse assignments.
6. Proficient PC Skills including Word, Excel, Access.
7. Must have a valid driver's license. Minimal travel between Indiana, Pa, Pittsburgh, Pa. and Northeast Ohio may be required.
8. Proficient reading, writing, and grammar skills, proficient analytical and mathematical skills; proficient communicative and interpersonal relations skills. Possess a thorough knowledge of credit administrative procedures, commercial lending practices, loan structures, regulations, risk assessment, products, data structures and reporting.
9. May be eligible for Telecommuting

Recommended

1. Working knowledge of SQL
2. Working knowledge of Microsoft Report Builder and SQL Server Management Studio
3. Understanding of the Current Expected Credit Loss accounting standard (CECL)
4. Understanding of Model Risk Management and SOX Controls

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.