Planning Analyst ll

Clopay • Troy, OH

48d • $75,000 - $75,000 • Onsite

About The Position

At Clopay Corporation, we are more than just North America’s largest residential and commercial garage door manufacturer—we are a powerhouse of innovation, safety, and design. Through our premier brands, we lead the industry in providing groundbreaking high-performance closure solutions for both the places people call home and the spaces where the world does business.
Headquartered in Mason, Ohio, and operating state-of-the-art manufacturing facilities in Troy, Ohio, Mountaintop, Pennsylvania, and Goodyear, Arizona, we are a proud American-owned company and a wholly-owned subsidiary of Griffon Corporation. Our reach extends across 55+ distribution centers and thousands of retail locations in the U.S. and Canada ensuring that we deliver the right door for every opening – from homes to businesses and beyond.
By joining our team, you become part of a legacy that blends the residential elegance of Clopay, known as "America’s Favorite Garage Doors," with the industrial strength and 180-year heritage of our rolling brands, Cornell and Cookson. Together, we secure everything from family garages to the world's most iconic stadiums and skyscrapers.
We currently have an opening for a Planning Analyst ll, in our Troy, Ohio location.

Requirements

• Education: Bachelor's degree in accounting, business or supply chain.
• At least One-year related experience and/or training; or equivalent combination of education and experience.
• Mastery of pivot tables, formatting errors, vlookup, sumifs, subtotals, links between files, correcting formula errors and able to select correct tools and formulas in Excel.
• Basic understanding and usage of Power BI and Power Automate - need to have working knowledge.
• Provide meaningful analysis using Demantra Forecast.
• Ability to do critical review of color, words, visuals data validation and integrity.
• Be able to back- up at least two other areas within the department.
• Ability to communicate to leadership using words, numbers and visuals in a round table setting.
• Project management and customer service abilities.

Responsibilities

• Develop and utilize sophisticated Excel and Power BI reports to help DCs effectively manage their inventory.
• Recommend and implement optimal stocking levels to meet customer demand while minimizing costs.
• Troubleshoot and resolve purchasing issues for the DCs.
• Support IT initiatives to automate the purchasing of special orders.
• Identify available stock to efficiently fill trucks and manage logistics.
• Lead inventory cost-savings projects at the DCs to improve profitability.
• Enhance the stock offering to increase sales from on-hand inventory.
• Manage the seasonal stock build to align with market demand and sales cycles.
• Will work daily in Excel and Power BI. Must have experience in using and understanding data.
• Participates in weekly and monthly planning meetings. Must be able to discuss the data with leadership.
• Requires the ability to stay focused for long periods of time, stay organized and understand time and capacity constraints in manufacturing.
• Requires proactive and analytical skills that use data to drive decision-making.

Benefits

• Unrivaled Scale: Work for a market leader with a massive manufacturing footprint and a reputation for excellence that spans nearly two centuries.
• A Culture of “What’s Next”: We invest heavily in automation, sustainable materials, and smart-home integration to stay ahead of the curve.
• Commitment to People: As a Griffon Corporation company, we provide the stability of a large organization with the tight-knit, collaborative feel of a specialized craft team.
• A Legacy of Expertise: Join our "Pioneer Club"—a group of over 440 employees who have been with us for 20 years or more. We offer the stability of a market leader and a place where you can truly grow a lifelong career.
• Commitment to Innovation: We aren’t just keeping up with industry trends; we’re setting them. Whether it’s our exclusive WINDCODE® technology or our award-winning designs, we provide the tools for you to do your best work.
• Community Focused: Our success is linked to the well-being of our neighbors and communities. Through our partnership with Habitat for Humanity, Clopay employees help provide homes and security to families in the communities where we live and work.

What This Job Offers

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