Capital Planning Analyst II

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 Overview

The Analyst II, Capital Planning supports the Director, Capital Planning by executing the Capital Approval Process. The Analyst II coordinates with Macy's business teams on new capital project requests, prepares materials for approval meetings, and tracks projects through the capital process. The Analyst II also prepares and analyzes monthly capital forecast reports to ensure accurate tracking and management of Macy's, Inc. capital investments. This role collaborates with cross-functional partners to consolidate, review, and validate capital forecasts and contributes to executive-level reporting, including regular updates for the Chief Financial Officer and Corporate Strategy Group.

What You Will Do

• Support the Capital Planning team in evaluating capital projects using discounted cash flow (DCF) models.
• Support the Director with capital reporting, project tracking, and documentation throughout the Capital Approval Process.
• Prepare, streamline, automate, and analyze monthly capital forecast reports to support enterprise-wide capital investment tracking.
• Coordinate, consolidate, and automate forecast submissions from cross-functional business teams.
• Support the Director in developing annual summaries of capital project performance for Board-level reporting.
• Collaborate with stakeholders across Store Environment, Real Estate, Area Research, Stores, Merchandising, Tax, and Capital Control.
• Perform financial analyses and support additional projects as assigned.
• Provide recommendations to guide future capital investment decisions.
• Maintain regular, dependable attendance and punctuality.
• Foster an environment of acceptance and respect that strengthens relationships, and ensures authentic connections with colleagues, customers, and communities.
• In addition to the essential duties mentioned above, other duties may be assigned.

Skills You Will Need

Capital 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), develop assumptions, and perform sensitivity/scenario analysis.

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 Are

• Candidates with a bachelor's degree or equivalent work experience in a related field are encouraged to apply. 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.

What We Can Offer You

Join 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 discounts
• Performance-based incentives
• Annual merit review
• Employee Assistance Program with mental health counseling and legal/financial advice
• Tuition reimbursement

Access the full menu of benefits offerings here.

About Us

This 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.

FINANCE00