Senior Financial Analyst - Corporate Real Estate

Advance Auto Parts • Raleigh, NC

10d • Onsite

About The Position

Advance Auto Parts is seeking a Senior Financial Analyst for its Corporate Real Estate Finance team in Raleigh, NC. This role is part of the Financial Planning & Analysis (FP&A) group and will focus on supporting the company's store portfolio through financial planning, forecasting, underwriting, capital discipline, and performance analysis. The position offers significant exposure to the business, enabling the analyst to understand the economics of a large store network and assist leaders in making informed decisions. The Real Estate Finance team partners closely with various departments including Real Estate, Construction, Leasing, Lease Accounting, Treasury, and Operations to support decisions related to new stores, relocations, lease actions, capital projects, rent, occupancy, and store-level economics. The team is structured to provide visibility for individual contributions while offering opportunities to develop expertise in real estate finance, FP&A, capital planning, and decision support.

Requirements

• Bachelor's degree in Finance, Accounting, Economics, Business, Real Estate, or a related analytical field.
• Three to five years of experience in FP&A, corporate finance, real estate finance, investment analysis, valuation, consulting, transaction advisory, or a similar analytical finance role.
• Strong Excel and financial modeling skills, including experience building driver-based forecasts, pro formas, scenario analyses, or investment return analyses.
• Strong understanding of FP&A fundamentals, including budgeting, forecasting, variance analysis, and performance reporting.
• Ability to analyze complex financial data, identify key drivers, and translate findings into clear recommendations.
• Strong attention to detail, with the discipline to validate data, pressure-test assumptions, and produce accurate work.
• Strong written and verbal communication skills, including the ability to prepare clear materials for finance and business partners.
• Ability to partner effectively with finance and non-finance stakeholders across functions.
• Strong ownership, organization, and ability to manage multiple priorities across recurring cycles, projects, and ad hoc requests.
• High level of professionalism, discretion, and judgment when handling sensitive financial and strategic information.

Nice To Haves

• Exposure to real estate underwriting, lease economics, occupancy costs, store-level P&Ls, capex, or portfolio analysis.
• Familiarity with ROI, IRR, NPV, payback, DCF, sensitivity analysis, or other returns-based decision frameworks.
• Exposure to ASC 842 lease accounting concepts, including ROU assets, lease liabilities, modifications, or remeasurements.
• Experience translating model output into clear business narratives for finance, real estate, or operating leaders.
• Experience preparing materials for senior leadership, executive reviews, investment committees, or capital approval forums.
• Experience with Oracle, PBCS, Anaplan, or similar planning and reporting systems.
• Experience with CoStar, Lucernex, Power BI, Tableau, SQL, Python, Alteryx, or other real estate, data, or automation tools.
• Experience in retail, multi-unit operations, REIT, real estate private equity, brokerage, transaction advisory, investment banking, corporate development, or consulting.
• MBA, CFA, CPA, or real estate-related coursework or certification.

Responsibilities

• Build and maintain financial models, real estate proformas, and scenario analyses for new stores, relocations, expansions, lease actions, and capital projects.
• Evaluate real estate opportunities using metrics such as ROI, IRR, NPV, payback, cash flow, capex, occupancy costs, and operating income, summarizing key drivers and implications.
• Validate inputs, evaluate assumptions from brokers, landlords, and developers, and identify sensitivities, tradeoffs, and recommended actions.
• Maintain model discipline through clean structure, clear assumptions, traceable data sources, formula integrity, and tie-out checks.
• Support the Annual Operating Plan (AOP), periodic forecasts, and long-range plan for 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.
• Support the ROU asset and lease liability forecast, partnering with Lease Accounting to understand ASC 842 impacts and reconcile model outputs to the general ledger.
• Track new store opening (NSO) performance against pro forma expectations, including sales, four-wall margin, and ramp.
• Support updates to store-level targets used in AOP and operating reviews.
• Analyze actuals versus plan, forecast, and prior year, separating timing variances from structural performance changes and explaining key drivers.
• Support period-end close, recurring business reviews, and leadership updates with clear, accurate, and actionable analysis.
• 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 economics.
• Support post-investment reviews and performance tracking to improve future underwriting assumptions and decision quality.
• Translate underwriting, forecast, and variance analysis into clear narratives, memos, and presentations for finance and real estate leaders.
• Build timely, well-structured analysis that answers leadership questions and supports clear recommendations.
• Improve financial models, reporting tools, templates, processes, and documentation 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 or PBCS.
• Handle sensitive financial, real estate, and strategic information with discretion and professional judgment.

Benefits

• Advance Auto Parts is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state or local protected class.
• We comply with all applicable federal, state, and local laws.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior