ALM & Treasury Data Analytics Analyst

Nicolet Bank; United States; On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

401(k) with company match

PTO & 11.5 Paid Holidays

Job summary

Nicolet National Bank is seeking a Treasury Analyst to manage data for Asset-Liability Management, ALM funding, and interest rate risk within the ALCO framework. You will support day-to-day cash operations and contribute to strategic analysis across the treasury function.

Responsibilities include monthly treasury reporting, ALCO packages, budgeting, forecasting, risk reporting, and documentation of policies and modeling processes.

Qualifications

• Bachelor’s degree in business, finance, accounting, business analytics, economics, or mathematics.
• 0-3 years of experience in finance, accounting, or data analytics.
• Banking industry experience is preferred.
• Ability to maintain strict confidentiality.
• Strong logic-based skills (math, reasoning, analytical, decision-making).
• Proficiency in Microsoft Office applications, including Excel and Power Point, (Tableau / SQL experience is a plus).
• Exposure to Bank Asset/Liability Management concepts; familiarity with ALM systems a plus.
• Understanding of banking and financial markets; experience reviewing bank balance sheets and risks.

Responsibilities

• Assist with monthly Treasury Reporting. Prepare ALCO reporting package.
• Assist with annual budget, monthly forecasting, and management reporting.
• Report results of ALM Stress Tests and liquidity, IRR, EVE, and capital.
• Assist in documentation and monitoring of policies for risk management.
• Develop modeling process documentation and data management improvements.
• Implement automated data collection for risk metrics and treasury reports.
• Query, manipulate, transform, and analyze large data sets.
• Design and maintain framework for distribution of risk information to executives.
• Leverage system functionality (ZM Financial, Vena, Excel) to improve processes.

Skills

ALM analysis

Data manipulation

Excel

SQL

PowerPoint

Analytics

Education

Bachelor's degree in finance, accounting, economics, math

Tools

ZM Financial

Vena Solutions

Tableau

Excel

Job description

Nicolet National Bank is seeking a Treasury Analyst to manage data for Asset-Liability Management, ALM funding, and interest rate risk within the ALCO framework. You will support day-to-day cash operations and contribute to strategic analysis across the treasury function.

Responsibilities include monthly treasury reporting, ALCO packages, budgeting, forecasting, risk reporting, and documentation of policies and modeling processes.