Senior Vba Developer Jobs in Florida (NOW HIRING)

Calculates and prepares the Allowance for Credit Losses (ACL) report. Coordinates the updated of borrower’s financial information needed for the ACL calculation and updates all related factors (Vintage, WARM, prepayments, line of credit utilization and qualitative factors). Assist in the model validation and ongoing monitoring. Prepares Credit Risk SEC, US-GAPP, OCC and other credit risk financial reporting, development of asset quality presentations, and calculation of Risk Appetite Metrics (RAMs) and Key Risk Indicators (KRIs).

Responsibilities:

Allowance for Credit Losses (ACL):

• Calculate the Allowance for Credit Losses (ACL) according to the approved model, which requires compiling all needed information from credit related units, downloading portfolio data from the bank’s loan system, running the different models in Impairment Studio, preparing the required reports, and reconcile data to GL.
• Update the loss factors (Vintage, LGD, WARM, Prepayment, line utilization and qualitative factors) used in the calculation of the ACL.
• Coordinate the update of borrower’s financial information (DSCR, LTV and Financial Spreads)
• Prepare all ACL related reports (BRC presentation, financial reporting disclosures)
• Assist in the ACL model development, documentation, implementation, and on-going performance testing.
• Ensure model documentation is up to date and in accordance with regulatory requirements.
• Maintain ACL procedures manuals up to date in line with current process
• Estimate loss provisions forecast for the Bank’s budget.

Credit Risk Metrics:

• Calculate and monitor Risk Appetite Metrics (RAMs) and Key Risk Indicators (KRIs) related to credit risk, asset quality, and portfolio performance.
• Engage with the business and Enterprise Data Management Office to identify and help remediate data related items including but not limited to data quality, data classification and data descriptions.

Credit Risk Financial Reporting:

• Prepares Credit Risk SEC, US-GAPP, OCC and other regulatory reporting.
• Ensures that reports reconcile with Financial Reporting reports.
• Liaison between Credit Risk and Financial Reporting for the purpose of coordinating regulatory reporting related to Credit Risk.

Other:

• Work on special projects as required.
• Identify, evaluate, monitor, and make any recommendation deemed necessary to the Executive Credit Officer and/or senior management to assess, reduce, eliminate, or control any current or prospective risks to earnings or capital arising from violations of, or nonconformance with, laws, regulations, prescribed practices, internal policies and procedures or ethical standards.
• Stay abreast of industry changes, trends, and best practices, and assess the potential impact Bank’s credit risk.
• Continuously look for innovative ways to refine and/or automate processes to gain efficiency and improve operational controls.
• Interact with internal/external auditors and regulators.
• Ensure preventive measures are carried out to fully comply with current rules, regulations and internal policies relating to risks pertaining to BSA, USA Patriot Act, OFAC and other AML related issues.

Minimum Education and/or Certifications Requirements:

Bachelor’s degree in business administration, finance, economics or related disciplines, or equivalent experience required.

Minimum Work Experience Requirements:

Minimum of three years of banking experience, ideally in credit risk modeling, and estimating the Allowance for Credit Losses (ACL).

Technical and/or Other Essential Knowledge:

• Strong quantitative, analytical, and problem-solving skills, with the ability to interpret data, identify emerging risk trends, and translate analysis into clear business insights and actionable recommendations.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data modeling, Power Query, Power Pivot, dashboard development, and VBA programming.
• Proficiency in Microsoft PowerPoint and Word, with the ability to prepare professional reports, management presentations, and executive summaries.
• Strong financial analysis and financial modeling skills, including the ability to analyze portfolio performance, credit metrics, and loss trends.
• Proficiency in data visualization and reporting techniques, including the development of dashboards, trend analyses, and management reports.
• Strong attention to detail with a demonstrated ability to identify errors, inconsistencies, and potential data quality issues.
• Excellent written, verbal, and presentation communication skills.
• Ability to multitask and perform effectively under pressure, managing tight deadlines and shifting priorities.
• Strong interpersonal skills with the ability to collaborate effectively across teams.
• Knowledge of banking products, services, and systems.
• Fully bilingual in Spanish and English preferred.

This position is hybrid/remote work eligible.