Bank Data Analyst II – CECL & Credit Risk

The Bank Data Analyst II role within Stifel’s Credit Risk Data Analytics group focuses on automation and integration of systematic data extraction from core systems into credit risk applications. You will support credit loss forecasting and management reporting by translating business needs into accurate queries, datasets, and impairment calculations.

What you’ll do

• Operate within the Analyst team in Credit Risk Data Analytics to automate and service systematic data extraction from core systems, integrating results into applications used by the business.
• Serve as a subject matter expert for assigned raw data sets, including maintaining documentation and data dependencies that affect the allowance process.
• Apply data science methodologies to support loan portfolio data integrity used for credit loss forecasting, management reporting, and discovery of data-driven initiatives.
• Partner with business users and the portfolio delivery team to interpret requests, refine requirements, validate proper use of requested data, and translate requirements into queries for objective datasets.
• Produce monthly loan impairment calculations and portfolio analytics.
• Master processing in Impairment Studio with support from Moody’s internal team.
• Analyze assigned raw data sets in depth, documenting sources, outputs, and how they impact impairment.
• Support Portfolio Managers and/or Underwriters in finalizing PD/LGD calibrations by integrating Moody’s Credit Lens and Commercial Mortgage Metrics across an end-to-end Credit Risk Management process.
• Coordinate with third-party consultants and Stifel IT on future implementation packages and the department’s data management strategy.
• Develop analyses for management review of the broad loan portfolio, including PD/LGD metrics down to the loan or facility level.
• Improve accuracy and consistency of loan risk ratings and ImpairmentStudio outputs using automation and documented internal processes, including reconciliation accuracy and consistency metrics via periodic reporting.
• Document processes and models to meet standards required by internal and external auditors and other governance bodies.
• Identify and recommend process and practice improvements for the team.
• Maintain strong stakeholder communication, following up as needed to ensure requests are actively addressed and status is shared.

Required skills and experience

• Minimum 3+ years of investment, financial, or technical experience.
• Minimum education: Bachelor’s degree in Information Technology, Computer Science, or Business Administration, or equivalent work experience.
• Strong technology capability including SQL Server, writing routines in SQL and scripting languages, and MIS presentation tools; ability to analyze and model data structures, automate repetitive tasks, develop dashboards and user interfaces, and train users.
• Understanding of accounting or financial techniques and tools, with attention to detail to support Impairment accuracy and integrity.
• Knowledge of portfolio risk management, including the credit risk lifecycle and how it impacts drivers of impairment.
• Ability to handle complex issues and support hypothesis testing through data analysis.
• Advanced statistical analysis experience working with large datasets.
• Ability to triage requests and prioritize time-sensitive items while staying aware of overall team bandwidth and workload.
• Willingness to learn new tools and data analytics techniques.

Technologies you’ll work with

• SQL Server, SQL, PowerBI, Microsoft Excel, Word, PowerPoint, Outlook, Tableau
• AWS, Python, R, Impairment Studio
• Moody’s Credit Lens, Commercial Mortgage Metrics, MIS Presentation tools

Location and work setup

• St. Louis, MO (onsite)

Benefits

• Comprehensive benefits package including health, dental, and vision care
• 401k
• Wellness initiatives
• Life insurance
• Paid time off