Sql data analyst Jobs in Amarillo, TX

Credit Analyst II

The Credit Analyst II performs financial based analysis and underwriting of credits which is used by the bank to assess risk and monitor existing credits to entities or individuals. This position focuses on less complex relationships.

Essential duties and responsibilities include:

1. Create financial spreads within the bank lending operating system (nCino) using financial statements to find and review trends.
2. Prepare reports designed to quantify borrowers' personal, global, and real estate cash flows/project analysis on an accurate and timely basis as assigned by their manager or other designated CA leader.
3. Attend loan committee meetings when directed by management.
4. Verify accuracy of customers' borrowing base certificates for assets such as accounts receivable, inventory, and marketable securities.
5. Calculate financial ratios and monitor for compliance in accordance with customers' loan agreements regarding frequency and definitions of ratios or eligible collateral.
6. Review outgoing analysis prepared by the Credit Analyst I position.
7. Create credit memos and annual reviews, as defined in current department procedures.
8. The ability to work in a constant state of alertness and in a safe manner.
9. Complete required BSA/AML training and other compliance training as assigned.
10. Perform any other related duties as required or assigned.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty mentioned satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education and experience: Broad knowledge of such fields as accounting, marketing, business administration, finance, etc. Equivalent to a four year college degree, plus 4 years related experience and/or training, and 3 years related management experience, or equivalent combination of education and experience.

Communication skills: Ability to read, analyze, and understand general business/company related articles and professional journals; ability to speak effectively before groups of customers or employees. Ability to write reports, business correspondence, and policy/procedure manuals; ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Ability to read, analyze, and understand common scientific and technical journals, financial reports, and legal documents; ability to respond to complex or difficult inquiries or complaints from customers, regulatory agencies, or members of the business community.

Mathematical skills: Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane, algebra, solid geometry and trigonometry.

Critical thinking skills: Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Software skills required: Advanced: 10-Key, Accounting, Spreadsheet, Word Processing/Typing. Intermediate: Alphanumeric Data Entry.

Responsibility for work of others: Carries out supervisory responsibilities in accordance with the organization's policies and applicable laws. Responsibilities may include but not limited to interviewing, hiring and training employees; planning, assigning and directing work; appraising performance, rewarding and disciplining employees; addressing complaints and resolving problems. Supervises a small group (1-3) of employees in the same or lower classification. Assigns and checks work; assists and instructs as required, but performs same work as those supervised, or closely related work, most of the time. Content of the work supervised is of a non-technical nature and does not vary in complexity to any great degree.

Working conditions: Normal working conditions as found within an office setting, wherein there is controlled temperature and a low noise level, plus a minimum of distractions.

Environmental conditions: The following work environment characteristics described here are representative of those an employee encounters while performing essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.

Physical activities: The following physical activities described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions and expectations. Semi-repetitive, low physical. Semi-repetitive type work which requires periods of concentration for varied time cycles as prescribed by the tasks. While performing the functions of this job, the employee is continuously required to sit; frequently required to stand, walk, use hands to finger, handle, or feel, talk or hear; and occasionally required to reach with hands and arms, stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision; and color vision.

Additional information:

-Four (4) years of related experience and/or training

-Three (3) years of related management or supervisory experience

-Analytically minded and possessing good judgment.

-Proficient in Microsoft Word and Excel.

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.