Balance Sheet Strategy Analyst

Summary

Pathward is a financial empowerment company focused on increasing financial availability, choice, and opportunity. The Balance Sheet Strategy Analyst designs and maintains financial models, data workflows, dashboards, and reporting to support loan sales and balance sheet optimization, while analyzing transaction economics, portfolio impacts, and strategic alternatives. The role also develops scalable analytical tools using Excel, Power BI, SQL, Matillion, SharePoint, and related platforms.

Responsibilities

• Own and enhance the models, dashboards, and data workflows supporting loan portfolio strategy; build financial models comparing hold, sell, participation, syndication, and other alternatives
• Analyze pricing, expected sale proceeds, gain or loss on sale, retained economics, funding-cost savings, capital impacts, and future revenue tradeoffs
• Develop valuation, cash flow, profitability, balance sheet forecasting, and scenario models incorporating rates, credit performance, prepayments, market pricing, and transaction timing
• Develop ROA and balance sheet optimization models for historical portfolio performance and new business origination, incorporating asset yield, funding cost, capital usage, credit risk, liquidity impact, and strategic balance sheet objectives
• Identify and evaluate loans and portfolios for potential sale based on economics, strategic fit, concentration, and balance sheet usage
• Support the loan-sale lifecycle through portfolio stratifications, valuation, bid comparisons, transaction recommendations, forecasts, and post-transaction performance analysis
• Build Power BI data models and dashboards and use SQL, Matillion, or comparable tools to integrate data, automate recurring analysis, and improve visibility into inventory, pipeline, pricing, and results
• Define data capture, reporting, and governance requirements for off-balance-sheet activities, including fields needed to monitor sold, participated, syndicated, or otherwise transferred exposures and assess ongoing economics and risk
• Establish validation, reconciliation, change-control, and documentation standards for models and recurring analytical outputs; maintain organized materials in SharePoint
• Track transactions against assumptions, translate results and investor feedback into recommendations, and present findings to management and governance committees

Skills

• Bachelor's degree in finance, accounting, economics, business or data analytics, information systems, mathematics, or a related field
• Two to five years of experience in banking, commercial lending, treasury, capital markets, portfolio analytics, FP&A, or transaction advisory
• Strong financial modeling skills, including valuation, cash flow analysis, forecasting, and scenario analysis; advanced Excel proficiency required
• Experience developing Power BI data models and dashboards and working with large loan-level or financial datasets; working knowledge of SQL preferred
• Ability to independently structure complex analytical problems and communicate clear recommendations to technical and nontechnical stakeholders; loan-sale, syndication, securitization, commercial loan pricing, or balance sheet management experience preferred
• Advanced analytics
• Data architecture
• Power BI and SQL
• Forecasting and balance sheet optimization
• Experience with Matillion, Alteryx, Azure Data Factory, dbt, Informatica, or another data-integration platform preferred; SharePoint experience is beneficial

Qualifications

Must Haves

• Bachelor's degree in finance, accounting, economics, business or data analytics, information systems, mathematics, or a related field
• Two to five years of experience in banking, commercial lending, treasury, capital markets, portfolio analytics, FP&A, or transaction advisory
• Strong financial modeling skills, including valuation, cash flow analysis, forecasting, and scenario analysis; advanced Excel proficiency required
• Experience developing Power BI data models and dashboards and working with large loan-level or financial datasets; working knowledge of SQL preferred
• Ability to independently structure complex analytical problems and communicate clear recommendations to technical and nontechnical stakeholders; loan-sale, syndication, securitization, commercial loan pricing, or balance sheet management experience preferred
• Advanced analytics
• Data architecture
• Power BI and SQL
• Forecasting and balance sheet optimization

Nice to Haves

• Experience with Matillion, Alteryx, Azure Data Factory, dbt, Informatica, or another data-integration platform preferred; SharePoint experience is beneficial

Benefits

• This role is also eligible for an annual performance-based incentive opportunity.
• Health insurance
• 401(k) retirement benefits
• Life insurance
• Disability benefits
• Paid time off