skip to Main Content
Find Your Local Branch

Find your local Sonora Bank branch. A Texas tradition since 1900.

Home Office - Sonora Branch

(325) 387-3861 | Fax: (325) 387-3745

Boerne West Branch

(830) 331-9118 | Fax: (830) 331-9128

Wimberley Branch

(512) 842-3316 | Fax: (512) 842-3317

Sherwood Way Branch

(325) 949-0099 | Fax: (325) 949-1931

Bulverde Branch

(830) 438-0416 | Fax: (830) 980-5004

Southland Branch

(325) 947-2100 | Fax: (325) 947-2517

Boerne East Branch

(830) 331-8300 | Fax: (830) 331-8120
Access ID:          Forgot Password? | eBanking Demo | Enroll

Data Analyst

Posted Date: 05/11/2020
Location: Boerne, Texas

JOB DESCRIPTION – DATA  ANALYST

 

RESPONSIBILITIES

This team member will develop, implement, monitor and validate MIS reporting for management, quantitative analytic models, assessments and/or applications in support of loan portfolio, finance and other support through database information sourcing through Cognos.  Apply diverse methodologies and solve complex and/or undefined risk problems and create detailed and summary reports and recommendations for senior management.  The position will report to the Bank’s CFO.

This team member will develop & support processes that transform raw data into meaningful and useful information for internal management, the board of directors, and external governmental agencies.

A successful candidate for this role will have background in Excel modeling, data mining, MIS reporting, and predictive data analytics. Previous experience with IBM Cognos database, banking and financial operations is preferred, but not required.

JOB DUTIES

  • Provide detailed and summary statistical and analytical reporting for senior management ad-hoc and on recurring schedules.
  • Support our Executive Leadership team in loan portfolio concentration analysis, loss forecasting, regression analysis using internal & external benchmarks, quantifying loss given default, probability of default, corporate planning, deposit and interest rate analysis, and credit risk management, etc.
  • Develop and maintain credit risk valuation models utilizing correlations, concentrations, rating migrations, and risk contributors.
  • Ensure robustness of models, efficient data collection/input, and accurate and timely reporting requirements for various business units.
  • Analyze internal and external information to develop analytical approaches to determining calculate the Allowance for Loan and Lease Losses (ALLL)
  • Support the upcoming transition to the CECL framework with logical portfolio segmentation, model development and validation, and automated data gathering from internal and external sources.
  • Develop, maintain and validate enhanced loss forecasting models for internal budget and regulatory submissions.
  • Develop, maintain and validate consumer and commercial loan pricing models utilizing risk-based approaches.
  • Identify new sources of actionable data, data-capture mechanisms, and means of efficient data-integration for general business use.
  • Maintain large data sets using advance statistical/modeling tools and ability to pull datasets directly from source systems.
  • Work with various business units to resolve and prevent data quality issues.
  • Produces advanced analytical material for discussions with cross-functional teams to understand complex business objectives and influence solution strategies.
  • Work with CFO and Lenders to track performance metrics, understand the portfolios they oversee and the key risks affecting those portfolios
  • Support the communication and reporting of results to senior leadership and presentation to Board of Directors. Put this near the top of the list

 

QUALIFICATIONS

  • 6-12+ months in retail/commercial finance or credit risk.
  • 3+ years of experience in Statistical modeling and analysis
  • 3+ years of qualitative/quantitative data analysis and reporting
  • Prior experience with managing and analyzing large data sets
  • Strong understanding of commercial banking and lending products including experience in loss forecasting
  • Ability to communicate effectively and present analysis insights to senior management
  • Strong problem solving skills
  • Solid interpersonal skills, ability to work independently and as part of a team
  • Solid knowledge MS Excel and database integration
  • Self-starter with ability to develop processes and data input to ensure robust data collection with a willingness to develop reporting and processes from the ground up.
  • Must be able to attend Cognos training and become proficient in maintaining many reports for management.

 

EDUCATION

  • Bachelor’s or Master’s degree (in Mathematics, Statistics, Computer Science, Economics, Finance, Analytics or other similar quantitative disciplines)

 

Work Environment

 

Must be able to work under pressure and exhibit good sound judgment in making decisions pertaining to the overall health of the bank. Position requires extended periods of standing, sitting, and computer use. In addition, travel between branches and to customers and events may be required.

 

Such duties as listed in this description are not meant to be all inclusive and the employer reserves the right to add, alter, or delete duties as seen fit, with or without notice.

 

Sonora Bank provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Sonora Bank complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Apply for this position

Allowed Type(s): .pdf, .doc, .docx
T. Andrew Flores NMLS#: 747986
Vice President | Commercial Loan Officer
 

  Sherwood Way

 (325) 262-4581

Marc Villareal NMLS#: 1771694
Assistant Vice President / Assistant Branch Manager
 

  Boerne East

(830) 816-1412

Jen Jones
Jen Jones NMLS#: 
Senior Vice President/Bank Manager
 

  Sonora

(325) 387-3861

Clay Wilson NMLS#:  1256712
Vice President, Loan Officer
 

Southland Branch

(325) 947-2189

Dawn Riley NMLS#:  1888520
Asst. Branch Manager / Loan Officer
 

Wimberley

(512) 842-3613

Jay Orr NMLS#: 1933142
Vice President, Loan Officer
 

Sherwood Way Branch

(325) 262-4581

Kelly Hays NMLS#: 1940848
Loan Officer
 

Sherwood Way Branch

(325) 944-4068

Back To Top