ALM Associate - Balance Sheet Analytics

PNC Bank•Madison, WI

2d•Onsite

About The Position

PNC’s Chief Investment Office (CIO) is hiring an Associate for its Portfolio Management and Analytics team in New York City. The CIO manages approximately $150 billion in investment securities and $80 billion notional of interest rate derivatives. The role works directly with senior portfolio managers and provides exposure to portfolio construction, investment and balance sheet analytics, risk management, and the strategic management of bank assets and liabilities. The Associate develops expertise in portfolio analytics, fixed-income performance attribution, net interest income (NII) and balance sheet analytics, portfolio stress testing, and the use of investment and hedging portfolios to manage interest rate risk and the broader balance sheet. The position performs financial and statistical analysis, research, due diligence, stress testing, data aggregation, quality assurance, and reporting to support balance sheet and investment decisions. It also develops and maintains Python-based models, analytical tools, data pipelines, reporting, and business intelligence infrastructure, and identifies opportunities for automation and AI with appropriate controls and production stability. The role collaborates with Portfolio Management, Balance Sheet Management, Economics, Finance, Market Risk, Accounting, and business lines. The position is based in PNC’s in-office environment. PNC does not provide employment visa sponsorship or participate in STEM OPT for this position.

Requirements

Bachelor’s degree in Computer Science, Data Science, Financial Engineering, Financial Mathematics, Statistics, Finance, or another quantitative discipline; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
Strong quantitative and analytical skills, including the ability to solve complex financial and data-driven problems.
Strong programming and software development skills, including proficiency in Python and SQL.
Experience working with large and complex datasets.
Strong communication skills and ability to translate technical analysis into clear business and risk insights.
Attention to detail, intellectual curiosity, and ability to independently manage time-sensitive analytical deliverables.
Typically, a university or college degree and at least 2 years of relevant professional experience are required; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.

Nice To Haves

Master’s degree or higher in Computer Science, Data Science, Financial Engineering, Financial Mathematics, Statistics, or a related quantitative discipline.
Knowledge of fixed-income mathematics, portfolio analytics, interest rate risk, and/or forecasting and planning.
Experience developing financial models, scenario analyses, and quantitative tools supporting investment or balance sheet decisions.
Experience building scalable data pipelines, analytical applications, and production reporting solutions using large financial datasets.
Experience with business intelligence and visualization tools such as Power BI.
Familiarity with automation, AI, or modern data analytics techniques.

Responsibilities

Analyze balance sheet and portfolio risk, return, and performance, including the effects of interest rates and market conditions on net interest income and the bank’s financial position.
Perform stress testing, scenario analysis, and portfolio projections to evaluate interest rate risk and support investment and balance sheet management decisions.
Develop, maintain, and enhance Python-based financial models, analytical tools, and data pipelines for balance sheet management and interest rate risk analytics.
Build and enhance scalable data, reporting, and business intelligence infrastructure for CIO analytics.
Partner with Portfolio Management, Balance Sheet Management, Economics, Finance, Market Risk, and Accounting to develop analytical solutions.
Identify opportunities for automation and AI while maintaining appropriate controls and production stability.
Perform financial analysis, research, due diligence, statistical analysis, and report preparation related to the balance sheet.
Collect and research information for PNC’s balance sheet and manage defined analysis and reporting procedures for decision-making tasks.
Aggregate data and perform quality assurance to ensure timely and accurate management reporting.
Prepare and aggregate data for modeling activities; reconcile data and perform quality reviews.
Consult with lines of business to respond to ALM requirements.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature.
Dental and vision options.
Employee and spouse/child life insurance.
Short- and long-term disability protection.
401(k) with PNC match.
Pension and stock purchase plans.
Dependent care reimbursement account.
Back-up child and elder care.
Adoption, surrogacy, and doula reimbursement.
Educational assistance, including select programs that are fully paid.
Wellness program with financial incentives.
Maternity and/or parental leave.
Up to 11 paid holidays each year.
9 occasional absence days each year, unless otherwise required by law.
15 to 25 vacation days each year, depending on career level and years of service.