Senior Financial Analyst - Corporate Real Estate

Job Description Advance Auto Parts • Financial Planning & Analysis (FP&A) – Real Estate Finance • Raleigh, NC Advance Auto Parts is a leading automotive aftermarket parts provider serving professional installers and do-it-yourself customers across a large North American store network. At the center of the business is a practical purpose: helping motorists advance by delivering the right parts, trusted service, and fast answers that help customers get back on the road. Our culture is anchored in Inspire. Serve. Grow. We inspire our teams, serve our customers, and grow the business by working as one team, leading with purpose, and staying close to the needs of the customer. Financial Planning & Analysis (FP&A) is a critical partner in that work. The team brings financial discipline, analytical rigor, and sound business judgment to decisions across merchandising, supply chain, store operations, and real estate. For someone who wants to work close to the business, understand the economics of a complex store portfolio, and help leaders make better decisions, this role offers meaningful exposure to a scaled operating environment where strong finance work directly supports customer service, execution, and long-term business performance. About the Team Real Estate Finance sits within Corporate FP&A and supports the business through planning, forecasting, underwriting, capital discipline, and performance analysis for the company’s store portfolio. The team partners closely with Real Estate, Construction, Leasing, Lease Accounting, Treasury, and Operations, to support decisions across new stores, relocations, lease actions, capital projects, rent and occupancy, and store-level economics. Our work helps leaders understand the financial impact of real estate decisions — what the investment costs, what return we expect, what risks we need to manage, and how performance compares to plan after the decision is made. The team is small enough for individual work to have meaningful visibility, and broad enough to build a strong foundation in real estate finance, FP&A, capital planning, and decision support. About the Role The Senior Financial Analyst – Real Estate Finance will support financial planning, forecasting, underwriting, and performance analysis for Advance Auto Parts’ store portfolio. This role will partner with Finance, Real Estate, Construction, Leasing, Lease Accounting, and Operations to build and maintain financial models, analyze business drivers, and support decisions across new stores, relocations, lease actions, capital projects, rent and occupancy, and store-level performance. This is a hands-on FP&A and real estate finance role for someone who wants to work close to the business and build strong technical skills in modeling, forecasting, underwriting, and financial storytelling. The role offers meaningful exposure to store growth, lease economics, capital investment, and portfolio performance, with work that directly supports business decisions. What you’ll do Real Estate Underwriting and Decision Support Build and maintain clear, flexible financial models, real estate proformas, and scenario analyses that support new stores, relocations, expansions, lease actions, capital projects, and other real estate decisions. Evaluate opportunities using ROI, IRR, NPV, payback, cash flow, capex, occupancy costs, and operating income; summarize the key drivers and implications. Validate inputs, help evaluate broker, landlord, and developer assumptions before terms are finalized, and identify sensitivities, tradeoffs, and recommended actions. Maintain strong model discipline by using clean structure, clear assumptions, traceable data sources, formula integrity, and tie-out checks to ensure work is accurate, supportable, and ready for review. Rent, Occupancy, and Lease Forecasting Support the AOP, periodic forecast, and long-range plan for base rent, real estate taxes, and other Real Estate Finance areas; serve as the day-to-day owner for assigned components of the rent and occupancy forecast across the portfolio. Support the ROU asset and lease liability forecast across the portfolio; partner with Lease Accounting to understand ASC 842 impacts and reconcile key model outputs to the general ledger. Track NSO performance against pro forma expectations, including sales, four-wall margin, and ramp; support updates to store-level targets used in the AOP and operating reviews. Analyze actuals versus plan, forecast, and prior year; separate timing variances from structural performance changes, quantify the impact, and explain the key drivers. Support period-end close, recurring business reviews, and leadership updates with clear, accurate, and actionable analysis. NSO and Portfolio Performance Analytics Partner with Real Estate, Construction, Leasing, Lease Accounting, FP&A, Treasury, and Operations on real estate decisions and financial governance. Analyze lease economics, rent and occupancy costs, CAM, taxes, capital spend, project timing, and store-level financial performance. Support analytics that inform site selection and portfolio decisions, including market-level performance, cannibalization considerations, and standard store versus hub and market hub economics. Support post-investment reviews and performance tracking that improve future underwriting assumptions and decision quality. Executive Communication and Model Excellence Translate underwriting, forecast, and variance analysis into clear, concise narratives, memos, and presentations for finance and real estate leaders. Help build timely, well-structured analysis that answers leadership questions and supports clear recommendations. Improve financial models, reporting tools, templates, processes, and documentation over time to enhance accuracy, scalability, and consistency. Pull and structure data from real estate and finance systems; build durable models in Excel and support planning tools such as Anaplan