Sql data analyst [h1.location_city]

GENERAL DESCRIPTION OF POSITION

The Sr Commercial Real Estate (CRE) Data Analyst will analyze credit and economic data to estimate the degree of risk and trends involved in various commercial real estate property types.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Manage and monitor the loan portfolio data from an overall analytical perspective. This duty is performed daily, about 30% of the time.

2. Ensure reasonableness (quality control) of existing data collected for loans. Determine if, when and how additional data needs to be collected. This duty is performed monthly, about 30% of the time.

3. Develop, prepare and analyze loan concentration reports by type of loan, collateral, geography and industry. This duty is performed monthly, about 10% of the time.

4. Analyze historic and predictive CRE portfolio performance by segments in different economic cycles and geographic locations. This duty is performed quarterly, about 10% of the time.

5. Coordinate with DFAST team on data integrity and stress testing scenarios. This duty is performed as needed, about 5% of the time.

6. Assist Deputy Chief Credit Officer with analysis and narratives of economic conditions and statistics useful in analyzing loan portfolio risk exposures. This duty is performed as needed, about 10% of the time.

7. Assist Deputy Chief Credit Officer with economic and loan data analysis for preparation of the quarterly allowance for loan loss adequacy report. This duty is performed quarterly, about 5% of the time.

8. Coordinate CoStar and Moody's REIS data analytics research for management.

9. Provide supervision and oversight to maintain quality control of overall CRE data analyst function.

10. The ability to work in a constant state of alertness and in a safe manner.

11. Completes required BSA / AML training and other compliance training as assigned.

12. 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 5 years related experience and / or training, and 1 to 6 months related management experience, or equivalent combination of education and experience.

COMMUNICATION SKILLS

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. Ability to write speeches and articles for publication that conform to prescribed style and format; ability to effectively present information to top management, public groups, and / or boards of directors.

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 apply principles of logical or scientific thinking to a wide range of intellectual and practical problems. Ability to deal with nonverbal, logical or scientific symbolism such as formulas, scientific equations, and graphs. Ability to deal with a variety of abstract and concrete variables.

REQUIRED CERTIFICATES, LICENSES, REGISTRATIONS

Not indicated.

PREFERRED CERTIFICATES, LICENSES, REGISTRATIONS

Not indicated.

SOFTWARE SKILLS REQUIRED

Advanced : 10-Key, Accounting, Other, Presentation / PowerPoint, Spreadsheet, Word Processing / Typing

Intermediate : Database

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 talk or hear; and occasionally required to walk, use hands to finger, handle, or feel. The employee must occasionally lift and / or move up to 10 pounds. Specific vision abilities required by this job include close vision; and color vision.

ADDITIONAL INFORMATION

• Degree in business, finance, accounting, or economics,
• Minimum of 5+ years related experience and / or training in credit analysis, underwriting, or lending experience in commercial real estate with demonstrated knowledge of principals of accounting, finance, and economics.
• One to six months related management experience or equivalent of education and experience
• Previous experience working with Commercial Real Estate lending, Credit analysis and portfolio management experience along with knowledge of various CRE property types, and strong analytical skills is desired.
• Technological aptitude would be beneficial
• Analytically minded and possess good judgment.
• Proficient in Microsoft Word, Power Point with advanced knowledge of Excel charts, graphs and pivot tables.
• Knowledge / experience in Tableau and Power BI is preferred.
• Advanced power user of Moody's REIS and CoStar CRE database property platforms.
• Ability to provide underwriting property data support to lending staff.
• Ability to write in-depth CRE property type reports, business correspondence, and policy / procedure manuals
• Ability to effectively present information to various board committees and respond to questions from groups of executive management, regional managers, bank directors and bank regulators