ALM Associate - Balance Sheet Analyst

PNC; New York (NY); On-site; USD 90,000 - 140,000; Full time

Job summary

PNC in New York City seeks an ALM Associate- Balance Sheet Analyst to support balance sheet valuation and interest rate risk management. The role is highly technical, requiring programming, data engineering, database management, and analytical development skills.

You will own and enhance databases, develop tools and reporting, automate data preparation and QA, and collaborate with risk and technology teams to deliver reliable analytics and governance.

Qualifications

• Bachelor's degree in a quantitative field (CS, data science, financial engineering, etc.)
• Proficient in Python and SQL with strong programming skills
• Experience with large financial datasets and scalable pipelines
• Strong analytical and communication skills for stakeholders
• Detail-oriented with ability to manage time-sensitive deliverables
• Understanding of financial statements and interest rate risk concepts

Responsibilities

• Own, maintain, and enhance databases supporting QRM balance sheet valuation and interest rate risk analytics.
• Develop, maintain, and optimize production code, analytical tools, and scalable reporting solutions.
• Build automated processes for data preparation, reconciliation, QC, reporting, and risk analysis.
• Leverage QRM data to create analytics for balance sheet positions, drivers, and risk exposures.
• Support daily and monthly production of balance sheet analytics, with troubleshooting and issue resolution.
• Investigate data anomalies and partner with tech teams to identify root causes.
• Collaborate with analysts, PMs, modelers, risk, finance, and tech to translate requirements.
• Maintain robust documentation, procedures, controls, and backup coverage.
• Support governance, model risk, and regulatory initiatives.
• Identify automation and AI opportunities with proper controls.

Skills

Python

SQL

Data pipelines

Analytical thinking

Communication

Attention to detail

Education

Bachelor's in Computer Science or related quantitative field

Master's in related quantitative discipline

Tools

SQL

Job description

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a ALM Associate- Balance Sheet Analyst within PNC's Finance organization, you will be based in New York City, New York.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

This role is highly technical in nature and requires strong programming, data engineering, database management, and analytical development skills to support balance sheet valuation and interest rate risk management.

Job responsibilities

• Own, maintain, and enhance databases supporting QRM balance sheet valuation and interest rate risk analytics.
• Develop, maintain, and optimize production code, analytical tools, and scalable reporting solutions to improve reliability, efficiency, and analytical capabilities.
• Build automated processes for data preparation, reconciliation, quality control, reporting, and routine risk analysis.
• Leverage QRM data and outputs to create record-level analytics that provide deeper insight into balance sheet positions, valuation drivers, and risk exposures.
• Support daily and monthly production of balance sheet analytics, including troubleshooting, exception management, and resolution of time-sensitive issues.
• Investigate unexpected results and data anomalies within the QRM environment, partnering with technology teams and subject matter experts to identify and resolve root causes.
• Collaborate with balance sheet analysts, portfolio managers, financial modelers, risk management, finance, and technology stakeholders to translate business requirements into practical data and reporting solutions.
• Maintain robust technical documentation, operating procedures, controls, and backup coverage for critical processes.
• Support regulatory, audit, model risk, and governance initiatives related to balance sheet valuation and interest rate risk management.
• Identify and implement automation and AI-driven opportunities while maintaining appropriate controls, transparency, and production stability.

Required qualifications

• Bachelor's degree in Computer Science, Data Science, Financial Engineering, Financial Mathematics, Statistics, or a related quantitative field.
• Strong software development and programming skills, including proficiency in Python and SQL.
• Experience working with large, complex financial datasets and developing scalable data pipelines, analytical tools, and production reporting solutions.
• Strong analytical, problem-solving, and communication skills, with the ability to explain technical concepts to business and risk stakeholders.
• Demonstrated attention to detail and the ability to manage independent, time-sensitive deliverables.
• Solid understanding of financial statements, balance sheet products, and interest rate risk concepts.

Preferred qualifications

• Master's degree or higher in Computer Science, Data Science, Financial Engineering, Financial Mathematics, Statistics, or a related quantitative discipline.

PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Job Description

Using independent judgement on methods, performs financial analysis, conducts research and prepares reports. Performs due diligence and statistical analysis related to the balance sheet. Participates in stress testing efforts. Based on own discretion, researches and collects information for PNC's balance sheet. Manages and performs defined procedures, analysis and report preparation for decision making tasks. Performs data aggregation and quality assurance to ensure timely and accurate management reporting. Prepares and aggregates data for modeling activities. Reconciles and performs quality review of data. Consult with lines of business in responding to various ALM requirements.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Successful candidates must demonstrate appropri