Allegion (NYSE: ALLE) is a global pioneer in seamless access, with leading brands like CISA®, Interflex®, LCN®, Schlage®, SimonsVoss® and Von Duprin®. Focusing on security around the door and adjacent areas, Allegion secures people and assets with a range of solutions for homes, businesses, schools and institutions.

The Sr. Retail Business Analyst is responsible for account demand planning & product forecasting, order management, and providing robust data analytics & reporting to ensure account success and decision confidence. This highly analytical account facing position requires strong project management, prioritization, communication skills, strong experience with demand planning/forecasting and order management, and a working knowledge of retailer processes and systems. S/he communicates well across various levels of a retail organization, including store associates, business analysts and buyers. The position directly supports the account sales leader and works closely with Channel Marketing and Field Sales to ensure success by leveraging strong relationships across internal functions including Sales, Finance, IT, Marketing, Supply Chain and Operations.

What You Will Do

Account Management & Operations

• Build and closely manage relationships with customers at the analyst level; ensure strong communication if/as needed with the buying organization; work across other retailer functions if/as needed including space planning, merchandising, store operations, omni-channel, supply chain and retailer-based vendor resources
• Identify and lead implementation of internal best practices cross functionality that improve customer experience within assigned account
• Communicate and collaborate effectively with internal and external customers and stakeholders
• Assist account sales leader with account planning and strategy development, assortment planning and optimization, pricing and related activities
• Lead account forecasting activities; utilize strong analytical and concise communication skills when speaking to business performance, drivers and impacts (financial and operational)
• Partner with Supply Chain & Operations partners to ensure smooth product logistics, mitigate challenges, and build/enhance forecasting processes.
• Manage vendor compliance reporting and monthly disputes/claims processes
• Plan and smoothly execute product transitions with minimal customer impact (strong replenishment plan)
• Support Channel Marketing to ensure SKU information is updated and maintained in retailer systems, and ensure POGs are setup and maintained properly and maintains integrity; assist Channel Marketing and Field Team when necessary to ensure flawless execution of projects, resets, and in-store events
• Assist Channel Marketing as needed with supplies and merchandising materials for Allegion Field Teams to ensure stores receive materials in a timely manner.
• SME on account operational requirements and portal navigation

Data Analytics & Reporting

• Utilizing internal and external data reporting systems, provide detailed weekly analysis of replenishment orders to maximize inventory turns, fill rate and service level both internally and externally through better forecasting and communication
• Create and analyze weekly and monthly business reporting for key stakeholders which includes category and SKU trend analysis, SKU level forecast accuracy, fill rate, compliance adherence, point-of-sale performance, demand planning/forecasting creation, margin, return on advertising investment, etc.
• Identify trends, develop data supported hypothesis, outline key risks and opportunities, and make actionable recommendations to key stakeholders within the organization.
• Analyze operational, inventory and consumer demand data to provide actionable KPIs to gain efficiencies, minimize non-compliance issues and improve key metrics
• Provide category review planning data and reporting to identify risks and opportunities; lead analytical presentations, identifying performance trends, drivers and projected future impact
• Lead in the development and implementation of new analytical tools, process, and reporting to elevate the business performance
• Act as a training guide and/or SME resource for Retail channel business analysts
• Support account and retail channel projects, teams and ad-hoc analytical requests if/as needed
• Assist Channel marketing with promotional post-performance ROI reporting if/as needed

What You Need To Succeed

• Bachelor’s degree in business, finance, supply chain, marketing, data analytics, or related field preferred
• 5+ years of analytical sales, demand planning, project execution experience working with national, larger regional and/or ecommerce retailers
• Strong working experience with forecast development, identifying variance drivers and root cause resolution
• Experience identifying and resolving retailer disputes including but not limited to fines and shipment issues
• Strong math and advanced Excel knowledge, skills and experience in extracting data from multiple sources to create/discern actionable insights.
• Ability to apply principals of logical thinking to solve a wide range of intellectual and practical problems.
• Must be prepared to function within a fast paced, customer focused organization that is committed to cooperation, collaboration, and interdependence among diversified businesses and functions.
• Attention to detail to ensure data accuracy critical to building stakeholder credibility
• Ability to multi-task and be organized to manage multiple deadlines from various people on a daily basis
• Strong relationship building and communication skills; highly motivated with excellent organization and execution skills
• Ability to work effectively leveraging resources across multiple functions and geographies. Understanding of manufacturing, operations, finance, marketing, and product lifecycle management.
• A willingness to work collaboratively in a small solutions-oriented team with a passion to deliver results and exceed expectations.
• Ability to train and develop others in functional capacity
• Remote-based position with ability to travel up to 20%
• Candidates must reside in the US Eastern and Central Time Zones; preferred location is Atlanta Metro