Job Details

Position Description:

Job Purpose and Scope:

Responsible for contributing to the development and ongoing management of the Bank Analytics Program (‘Program’). Serves as an ambassador of the Analytics group and assists with all aspects of the Program, including developing repeatable, auditable, and sustainable processes; reporting; and analysis to inform management and enhance first-line risk management of the Bank.  Supports data, business, and forward-looking analytics for all programs, which includes capital and CRE stress testing, Credit Risk Scorecards, Current Expected Credit Losses, portfolio analytics, market and economic analytics, etc. May also be responsible for directly managing staff with equivalent or less senior titles within the Analytics team.  

Essential Job Functions:

1. Leads development of sustainable, auditable, and repeatable processes to support Programs that enhance first-line risk management. 
2. Provides and/or manages analytical support to management and business units across the enterprise, with a focus on the commercial and consumer loan portfolios.
3. Leads and/or manages the development and implementation of a recurring schedule of analytics reporting on the Bank’s commercial and consumer loan portfolio using SAS, R, VBA, PL/SQL, PowerBI, and/or other tools. 
4. May directly manage staff with equivalent or less senior titles within the Analytics team; absent direct management, serves as a mentor and technical expert for less experienced staff.
5. Leverages existing Bank reporting to extract and mine data to develop analytics which supports Bank initiatives, including capital and CRE stress testing, Current Expected Credit Losses, Credit Risk Scorecards, and/or other projects. 
6. Executes and implements complex models in support of Analytics initiatives. 
7. Participates in and may lead meetings with stakeholders to assist with the conveyance of purpose, outline expectations, and collaborate on the development of Programs.
8. Leads development of analytics to assess market and economic risk. 
9. Develops and leads training to business unit managers and stakeholders. 
10. Regularly exercises discretion and judgment in the performance of essential job functions.
11. Maintains good punctuality and attendance to work.
12. Follows Bank policy, procedure and guidelines.
13. Performs other duties as may be required.

Knowledge, Skills & Abilities:

1. Knowledge of and experience using analytical software such as SAS, SQL, R, Python, Power BI and/or Tableau.
2. Knowledge of trend analyses and root cause determination. 
3. Knowledge of modeling principles and processes, and data quality fundamentals and techniques.
4. Ability to communicate effectively both verbally and in writing.
5. Ability to develop and execute queries and/or reporting for large data sets.
6. Ability to use critical thinking and creativity to solve business problems. 
7. Ability to document procedures for execution of structured queries and reporting code.
8. Ability to operate and work collaboratively in a fast-paced, unpredictable environment, with exacting deadlines.
9. Ability to manage multiple work streams and deliverables, and coordinate across functional initiatives.
10. Ability to produce high-quality documents, presentations, and analyses.
11. Skill in using computer and Microsoft Office, including Word, Excel, PowerPoint and Outlook.

Equipment Used in Job Performance/Working Environment:

1. Computer
2. SQL, SAS, PowerBI, R, and similar tools
3. MS Office Applications, with a heavy reliance on Excel
4. Telephone
5. Multi-function device

Major Job Demands (Physical/Mental):

1. Decision-making
2. Problem-solving

Position Requirements:

Basic Qualifications:

1. Master degree in business administration, accounting, finance, business analytics, or related discipline, or commensurate work experience, required.
2. Minimum of three (3) years’ experience in analytics, business intelligence, data management, or related fields, required.
3. Minimum of one (1) year of management experience preferred.
4. Minimum of three (3) years’ experience with SAS, SQL, R, Python, Power BI and/or Tableau preferred.
5. Minimum of three (3) years’ experience developing and executing queries and/or reporting for large data sets preferred.