Data Analyst

About the role

The Credit Data Analyst II will work as a member of Stifel’s Analyst team within the Credit Risk Data Analytics group. This role is responsible for automation and servicing of systematic data extraction from the Core systems and integration of data into applications used by the business. The Credit Data Analyst II will act as a subject matter expert for assigned raw data sets and maintain documentation surrounding them. The position employs data science methodologies to ensure loan portfolio data integrity for credit loss forecasting, management reporting, and supporting data-driven initiatives and developments.

This role interprets requests, collaborates with business users and the portfolio delivery team to define requirements, analyzes data to ensure proper use, and translates requirements into queries to produce objective data sets.

Responsibilities

• Responsible for the monthly production of loan impairment calculations and portfolio analytics.
• Master all aspects of processing within Impairment Studio with the help of Moody’s internal support team.
• Perform in-depth analysis and act as subject matter expert for assigned raw data sets; document data dependencies, sources, and outputs that impact the allowance process.
• Support Portfolio Managers and Underwriters with finalizing PD/LGD calibrations, integrating Moody’s Credit Lens and Commercial Mortgage Metrics platforms in an end-to-end Credit Risk Management process.
• Improve the accuracy and consistency of loan risk ratings and Impairment Studio outputs through automation, documentation of internal processes, and providing data integrity and reconciliation accuracy metrics via periodic reporting.
• Document existing processes and models to meet standards defined by internal and external auditors and other governance bodies.
• Proactively identify and recommend process and practice improvements within the team.
• Maintain strong communication with stakeholders, ensuring all requests are actively addressed and status is communicated.

Requirements

• Solid understanding of financial industry terminology and concepts.
• Knowledge of financial services, specifically wealth management.
• Solid understanding of basic concepts of Microsoft T-SQL and database design.
• Ability to leverage SQL to create queries that model and/or aggregate large, complex datasets.
• Strong analytical skills focused on using logic and reasoning to identify complex relationships within data structures and recommend uses.

Qualifications

• Minimum Required: Bachelor’s degree in Information Technology, Computer Science, or Business Administration, or equivalent work experience.
• Minimum Required: 3+ years of investment, financial, or technical experience.

Skills

• Expert in SQL, Scripting, and Power BI.
• Proficient in Microsoft Excel, Word, PowerPoint, and Outlook.
• Knowledge of Tableau, AWS, Python, and R is preferred.

Benefits

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

About Stifel

Stifel is a global wealth management and investment banking firm with over 130 years of history, operating like a start-up with a focus on innovation and fresh ideas. Built on the premise of safeguarding clients' money as if it were our own, Stifel’s success is tied to helping families, companies, and municipalities achieve their goals. With headquarters in St. Louis and offices in New York, San Francisco, Baltimore, London, Frankfurt, Toronto, and over 400 other locations, Stifel employs approximately 9,000 individuals in roles such as financial advisors, research analysts, project managers, marketing specialists, developers, bankers, and operations associates.