Capital Planning Analyst II

This position can be based in Cincinnati.Be part of an amazing story.Macy’s is more than just a store. We’re a story. One that’s captured the hearts and minds of America for more than 160 years. A story about innovations and traditions…about inspiring stores and irresistible products…about the excitement of the Macy’s 4th of July Fireworks, and the wonder of the Thanksgiving Day Parade. We’ve been part of memorable moments and milestones for countless customers and colleagues. Those stories are part of what makes this such a special place to work.Job OverviewThe Analyst II, Capital Planning will prepare and analyze Capital Expenditure Requests (CERs) to ensure Macy’s, Inc. is making financially sound investments. The Analyst will also support the Senior in tracking of capital investments. This position will work with the Senior to provide an independent and objective assessment of the actual financial performance of capital projects versus the expected performance assumed in the original financial pro formas. The Analyst will support the Senior in regularly reporting findings to the Chief Financial Officer and other Corporate Strategy Group members and is responsible for preparing the annual summary of capital project tracking for the Macy’s, Inc. Board of Directors. This position requires extensive coordination with all management levels across numerous departments, including Store Environment, Real Estate, Area Research, Stores, Merchants, Tax, and Capital Control. The Analyst will also perform other financial analyses and duties as assigned. What You Will DoPrepare CERs and Senior Management memos.Build and adapt financial models that vary significantly by project; this role involves highly ad-hoc analysis.Develop strong relationships with key partners to ensure timely and accurate input for CERs. Provides regular updates describing actual vs. expected performance for capital projects using financial analyses and statistical modeling. Capital projects include new stores, major store remodels, merchandising initiatives, digital investments, and strategic initiatives.Develop and summarize annual capital tracking report for the broader Macy’s Finance Team.Collaborate with Store Environment, Area Research, Real Estate, Capital Control, Merchandising, Supply Chain, Tax Digital and Stores leadership to effectively evaluate baseline assumptions, costs and economic factors impacting success or failure of a capital investment.Manage and update global assumptions made within CERs to ensure consistency and accuracy.Provide recommendations to guide future capital investment decisions.Provide financial modeling support and evaluate investment opportunities.Maintain various reports and complete ad hoc projects as assigned.Skills You Will NeedCapital Planning & Governance: Working knowledge of capital approval processes, including project tracking, documentation, and stage-gate readiness.Financial Modeling (DCF): Ability to build and interpret discounted cash flow models (NPV, IRR, Payback), develop assumptions, and perform sensitivity/scenario analysis with unique, non-standard project structures.Forecasting & Variance Analysis: Experience consolidating forecasts, validating inputs, and explaining variances to support enterprise-wide capital investment tracking.Advanced Excel & Automation: Advanced proficiency in Excel and the ability to streamline and automate recurring reporting (e.g., Power Query/Power Pivot, complex formulas, pivot tables; VBA a plus).Executive Communication (PowerPoint): Ability to distill complex analyses into clear, concise updates and Board-ready materials; strong PowerPoint proficiency required.Cross-Functional Collaboration: Proven ability to partner with Store Environment, Real Estate, Area Research, Stores, Merchandising, Tax, and Capital Control to coordinate and validate submissions.Analytical & Quantitative Skills: Strong analytical/problem-solving skills, above-average math aptitude (rates, ratios, percentages), and familiarity with basic statistical concepts.Organization & Judgment: Ability to manage multiple priorities, meet deadlines, and work independently while exercising sound judgment and attention to detail.Who You AreCandidates with a bachelor’s degree or equivalent work experience in a related field are encouraged to apply. Minimum of 2 years of relevant experience preferred. Regularly required to sit, talk, hear; use hands/fingers to touch, handle, and feel. Occasionally required to move about the workplace and reach with hands and arms. Requires close vision.Able to work a flexible schedule based on department and company needs.Comfortable working in a dynamic environment with evolving priorities.What We Can Offer YouJoin a team where work is as rewarding as it is fun! We offer a dynamic, inclusive environment with competitive pay and benefits. Enjoy comprehensive health and wellness coverage and a 401(k) match to invest in your future. Prioritize your well-being with paid time off and eight paid holidays. Grow your career with continuous learning and leadership development. Plus, build community by joining one of our Colleague Resource Groups and make a difference through our volunteer opportunities. Some additional benefits we offer include:Merchandise discountsPerformance-based incentivesAnnual merit reviewEmployee Assistance Program with mental health counseling and legal/financial adviceTuition reimbursementAccess the full menu of benefits offerings here. About UsThis is a great time to join Macy’s! Whether you’re helping a customer find the perfect gift, streamlining operations in one of our distribution centers, enhancing our online shopping experience, buying in-style and on-trend merchandise to outfit our customers, or designing a balloon for the Thanksgiving Day Parade, we offer unique opportunities to be part of some of the most memorable moments in people’s lives. Join us and help write the next chapter in our story - apply today! This job description is not all-inclusive. Macy's, Inc. reserves the right to amend this job description at any time. Macy's, Inc. is an Equal Opportunity Employer, committed to a diverse and inclusive work environment. FINANCE00Full timePosting Date: 2026-08-04