Established in 1996, Community Bank of the Bay (“CBB”) is an independent, multiple award-winning community-focused bank with over 25 years of active financial investment in businesses and individuals in the San Francisco Bay Area. Our clients include numerous organizations from many industries, including local nonprofits, multi-generational businesses, creative professionals, and owner-operators experiencing change, growth, or expansion.
At CBB, we believe you can only truly serve a community when you are part of it. As the first Community Development Financial Institution (CDFI) formed in California, we are actively involved in local community life. In fact, that’s the whole thought behind community banking: your funds invested locally, through local decisions, by local people, driving the success of the broader community. Our mission is to foster and promote economic development in the communities we serve.
At CBB, our employees are our greatest asset, and we recognize that our success as a community bank is because of our extraordinary staff. We offer a welcoming, friendly, caring work environment with competitive compensation, a strong and robust benefits program, and an emphasis on healthy work/life balance.
Our six core values of Sustainability, Empowering, Respect, Trust, Commitment and Relationship building represent what we stand for and believe in as an organization. Every day, we strive to align our behaviors to these core values in everything we do.
Overview
The Data Risk Analyst will collaborate with members of the Finance, Note Department / Loan Servicing, Credit Administration and Operations to conduct various credit and operational risk management and reporting analytics duties. Major responsibilities include enhancing data integrity quality controls assisting with the development and implementation of reporting dashboards / presentations related to the collection and migration of the Bank’s loan and deposit portfolio risks, respectively. This role will support and maintain the Bank’s financial performance analysis reporting as it relates to credit risk expectation / estimation of the Bank’s financial receivable base and sensitivity to market / interest rate risk estimation of the Bank’s financial condition by assisting the FDM with the preparation of and the performance of periodic or ad-hoc management information systems database integrity review / audit and risk model validation necessary for financial reporting and/or enterprise risk analysis. This position is also responsible for monitoring data integrity trends of the Bank’s management information systems (MIS. This position will work at the direction of the FDM to learn the systems associated with this position, as well as to work on special project as assigned.
Duties and Responsibilities
1. Assist the FDM with the development, enhancement and maintenance of varies of credit and deposit risk measurement methodologies under including but not limited to remaining life, decay / repricing rates, probability of default (PD), loss given default (LGD), discounted cash flow and other methodologies used for the assessment of the Bank’s Sensitivity to Market Risk (SMR) under regulatory guidelines and the Current Expected Credit Loss (CECL) estimates under FASB ASC-326:
- Update sensitivity and scenario analysis to estimate the impact of macro-economic variables on expected credit losses;
- Update model performance monitoring metrics as well as business risk measures to ensure that the banks risk level is in line with its risk appetite;
- Update and enhance credit risk management systems and tools;
- Remediate model risk management / auditor findings;
2. Assist the FDM with managing and performing model validations and data audits relating CECL, SMR / Asset Liability Management (ALM) / Liquidity Risk and Credit Stress Testing:
- Identify model and control risks and make recommendations on methods for
- enhancement;
- Assist the FDM with updating tabular / graphical and written commentary in CECL, SMR / ALM and Credit Stress Testing (CST) presentations;
- Analyze economic, loan and deposit portfolio migration forecast data and explain its relevance to changes in loss and cash flow forecasts;
- Assist in maintaining process and procedures documentation.
3. Perform 3rd party vendor and native database processor loan and deposit database queries in order to identify and correct mass and/or case-by-case input of missing or incorrect key loan and/or deposit data as identified in prior or concurrent portfolio analytics reports:
- Research inconsistencies and/or errors utilizing source data (e.g. imaged collateral/account opening documentation) and provide corrective action recommendations in a concise report manner;
- Perform ad-hoc risk rating revalidation analysis of the loan portfolio Risk Ratings and collateral/lien priority based on information contained in the underlying imaged primary source data (e.g. credit / collateral file documentation etc.) and/or as publicly available;
- Revalidate data integrity implementation via subsequent database queries;
- Maintain catalogued support documentation for any database corrections as part of the regular departmental audit process.
4. Create and update periodic reports pertaining to data integrity trends, portfolio input error rates, including source / type of errors for internal analysis:
- Identify the source of data integrity error rate recurrence;
- Provide recommendations for proactive error rate reduction;
- At the direction of other members of Finance Department staff, work with members of Note Department / Loan Servicing, Credit Administration and Operations to recommend cross-training/retraining scope based on report conclusions;
5. Responsible for establishing and maintaining effective coordination and working relationships with staff and executive management:
- Projects a friendly, helpful and positive attitude towards all employees;
- Assists other personnel and executive management as requested;
- Informs Finance Department Manager and Chief Financial Officer of activities and any problems or concerns;
- Assists with internal and external audits as needed;
- Completes required reports and records accurately and promptly;
- Actively participates in meetings and other events.
6. Responsible for other related duties as required or assigned:
- May participate in the upfront M&A due diligence; analyzes target company information and prepares due diligence reports for senior management’s review
7. Assumes Responsibility for following all bank policies and procedures and regulatory guidelines, and for attending all required training.
Requirements
Education:
- Bachelor’s Degree from an accredited university in Finance, Accounting, Math, Statistics, Computer Science, Information Technology or related field, required; Master’s Degree in Finance, Accounting, Math, Statistics, Computer Science, Information Technology preferred.
Knowledge:
- Demonstrated proficiency with creating, analyzing and updating MSFT Excel (Power) Pivot tables, including Excel based descriptive statistics, linear programming / optimization and scenario modeling and analysis.
- Understanding and or working knowledge of FASB topics, including but not limited to ASC-326 / ASC-805 and their application to CECL / SMR /ALM / CST model implementation and FFIEC call report data.
- Demonstrable programming knowledge in machine language scripting (e.g. SQL, R, Python and MSFT Excel VBA etc.)
Experience:
- 3-5 years of commercial banking / risk analysis experience in regulated fiduciaries with data-quality-analyzing core instrument data / credit loss / migration forecasting.
- Demonstrated experience with writing report scripts in SQL, IBM Cognos Analytics; Microsoft Office power user, including Excel Pivot / Power Pivot and Word Developer.
- Experience with either one of Abrigo, Moody’s Impairment Studio, Oracle Financial Services or nCino Analytics and Reporting, including writing advanced SQL report scripts.
Skills/Abilities:
- Strong analytical skills with the ability to collect, organize, analyze and distribute large amounts of information with a strong attention to detail and accuracy. Performs with minimal supervision assigned duties.
- Ability to evaluate and understand business processes in order to analyze and understand data flow.
- Data visualization development and design preferably utilizing Power BI / Excel desired.
- Experience with FiServ / FIS Core processing systems is a plus.
- Self-motivated with the willingness to learn and dig enthusiastically into new subjects.
- Excellent communication skills and ability to professionally interact at any level of the company.
- Flexibility in responding to changing business requirements.
Benefits
Job Location: Oakland
Job Type: Full-time
Annual Salary: $95K – $125K
Salary may vary depending on multiple factors including but not limited to skill level, depth of work experience, education, relevant licenses/credentials, and geographic location.
Note: The duties and responsibilities listed are typical examples of work performed by the position and are not designed to contain or be interpreted as a comprehensive list of all duties, tasks, and responsibilities. Employees may also perform other duties as assigned.
EOE, including disability/vets. Job candidates must be legally eligible to work in the United States.
Community Bank of the Bay is committed to ensuring that our online application process provides an equal opportunity to all job seekers, including individuals with disabilities. If you believe you need reasonable accommodation in order to search for a job opening or submit an employment application, please email us at hr@bankcbb.com. This is a dedicated email address designed exclusively to assist job seekers whose disability prevents them from being able to apply online. Only messages left for this purpose will be considered. A response to your request may take up to two business days.
Please note: emails received for other purposes, such as following up on an application or non-disability related technical issues, will not receive a response.
We will consider for employment all qualified Applicants, including those with Criminal Histories, in a manner consistent with the requirements of applicable state and local laws, including the requirements of Section 19 of the Federal Deposit Insurance Act.