Business Intelligence Analyst, Lending (Onsite)

Overview:

The Business Intelligence Analyst, Lending is responsible for supporting the lending division through data-driven analysis, performance report generation, and risk assessment. This position provides valuable insights aimed at improving loan portfolio performance, enhancing underwriting standards, and ensuring compliance with internal policies, procedures, and regulatory guidelines. The analyst will also develop growth strategies and promote new business opportunities through comprehe

nsive research and analysis. Additionally, this individual will enhance current data sets, metrics, and reports, as well as develop dashboards and insights for the credit union. The Business Intelligence Analyst will actively collaborate with both internal and external stakeholders to create innovative solutions and insights using data analysis tools to optimize lending strategies across all loan types (consumer, mortgage, commercial), including loan servicing and collections. **About Frontwave

Credit Union Frontwave Credit Union is a member-owned not-for-profit financial institution serving San Diego, Riverside, San Bernardino and Imperial counties. Founded in 1952, we have grown to 18 branches with 125,000 members and manage over a 1\.8 billion in assets. At Frontwave Credit Union, we are focused on creating consumer solutions to provide our members and the communities we serve with products and services that enhance the quality of life for our members through exceptional service and the progressive application of technology. What’s In It For You:

Responsibilities: Essential Duties and Responsibilities:** Includes the following non-inclusive list. Other duties may be assigned. All duties are to be performed in compliance with applicable laws, regulations, and Credit Union policies and procedures.

• Analyze and manipulate complex, disparate data using spreadsheets, databases, and analytical tools to generate forecasts, actionable insights, and recommendations.
• Analyze application, production, and performance data across all loan portfolios (consumer, mortgage, commercial) to identify trends, investigate root causes, and recommend process or policy improvements.
• Monitor and analyze key portfolio metrics such as credit score trends, charge-offs, delinquency patterns, loan concentrations (by geography, collateral, borrower, NAICS, etc.), and compliance with internal policies and external
• regulations.
• Conduct risk segmentation, assess portfolio credit quality, and support compliance efforts, including HMDA and Fair Lending reporting and TRID guidelines.
• Provide ongoing reporting and insights to management, ALCO, and regulatory bodies, and contribute data to board reports, audits, and examinations.
• Support strategic planning by identifying emerging risks, conducting stress testing under various macroeconomic scenarios, and recommending policy or pricing adjustments.
• Monitor loan performance across portfolios, identifying risks, bottlenecks, and opportunities for improved efficiency, credit quality, and compliance.
• Evaluate secondary market pricing and investor guidelines (e.g., Fannie Mae), and support pricing strategy development to improve margin optimization.
• Analyze the performance of vehicle and credit card portfolios, including usage, delinquency, charge-offs, ROI of reward programs, and dealer relationships. Recommend strategies to enhance profitability, engagement, and growth.
• Collaborate with indirect lending teams to assess dealer scorecards and identify opportunities for improved partnerships.
• Assist the Business Intelligence team to develop and maintain dashboards and reports tracking key KPIs such as roll rates, cure rates, delinquency buckets, recovery ratios, approval/funding volumes, and originator performance.
• Collaborate with Business Intelligence and Information Technology teams to create and enhance automated reporting tools, ensuring data accuracy, consistency, and accessibility across departments.
• Assist with identifying, evaluating, and developing controls to mitigate risk and operational impacts.
• Analyze collections strategies and recommend improvements to enhance recovery and reduce charge-offs.
• Collaborate with various departments to assess reporting needs, develop data collection processes, and optimize workflows.
• Coordinate with IT and other teams on system implementations, updates, and special projects.
• Communicate data or production issues with key stakeholders and contribute to resolving them in a timely manner.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Minimum of two years working with data and enhanced reporting analytics or related experience preferably with a financial institution.
• Strong database skills, including working with advanced data sets, pivot tables, advanced database and statistical functions and methods.
• Strong analytical skills including analysis, data collection, process mapping and troubleshooting for root cause.
• Familiarity with FDCPA, FCRA, MLA, SCRA and other relevant lending regulations is a plus.
• Previous experience with lending analytics tools, such as nCino, a strong plus.

Education and/or Experience:

• Bac