Sr. Business Analyst – Retail & Ecommerce

Allegion; United States; Remote; USD 75,000 - 110,000; Full time

Job summary

A leading security firm is seeking a Sr. Business Analyst for Retail & Ecommerce. This remote position involves demand planning, product forecasting, and providing robust analytics to ensure account success. Ideal candidates have 5+ years in a similar role, strong project management skills, and proficiency in Excel and ecommerce platforms. Competitive salary range is $75,000-$110,000, with benefits including unlimited PTO and a 401K plan.

Benefits

Health, dental and vision insurance

Unlimited Paid Time Off

401K plan with company match

Tuition Reimbursement

Employee Discounts

Qualifications

• 5+ years of analytical sales and demand planning experience.
• Experience with ecommerce retailers and DTC platforms.
• History of resolving retailer disputes.

Responsibilities

• Build and manage relationships with internal stakeholders.
• Lead forecasting process and identify variance drivers.
• Support the development of analytical tools to improve performance.

Skills

Analytical skills

Communication skills

Project management

Financial acumen

Relationship building

Education

Bachelor’s degree in business, finance, supply chain, marketing, data analytics, or related field

Tools

Excel

Shopify

Magento

Job description

Creating Peace of Mind by Pioneering Safety and Security At Allegion, we help keep the people you know and love safe and secure where they live, work and visit. With more than 30 brands, 12,000+ employees globally and products sold in 130 countries, we specialize in security around the doorway and beyond. Additionally, in 2024 we were awarded the Gallup Exceptional Workplace Award, which recognizes the most engaged workplace cultures in the world.

Sr. Business Analyst — Retail & Ecommerce — Remote EST or CST United States The Sr. Retail & Ecommerce Business Analyst is responsible for account(s) demand planning & product forecasting, order management, and providing robust data analytics & business intelligence reporting to ensure account(s) success and decision confidence. This highly analytical position supports external ecommerce accounts, our Direct-to-Consumer (DTC) Ecommerce business, and other assigned retail accounts, requiring strong project management, prioritization, and communication skills. Experience in demand planning/forecasting, order management, working knowledge of retailer processes and systems, and experience developing and managing DTC ecommerce business operations are important for success in this role.

At Allegion, we recognize that great talent and breakthrough ideas can come from anywhere. That’s why this position offers a flexible remote work arrangement, with occasional on-site visits as needed based on the role. Whether you’re working remotely or collaborating in person, we’re committed to providing the tools, support, and dynamic environment you need to succeed.

What You Will Do

• Build and manage relationships with internal stakeholders and with account analysts; ensure strong communication with the buying organization and other functions if/as needed
• Assist sales leader with strategy development, assortment planning & optimization, pricing and related activities.
• Develop and lead forecasting process; 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.
• Plan and smoothly execute product transitions with minimal customer impact (strong replenishment plan)
• Manage vendor compliance reporting and monthly disputes/claims processes
• Support the development and management of a DTC reverse logistics program, including analysis and improvement recommendations
• Assist in resolving consumer issues by analyzing data and working with the consumer service team to create a repeatable feedback loop
• Lead in the development and implementation of new analytical tools, process, and reporting to elevate the business performance, including identifying inefficiencies and streamlining solutions.
• Identify and lead implementation of best practices that improve customer and consumer experiences
• Support channel marketing to ensure SKU information is updated and maintained in retailer systems
• Assist channel marketing with promotional post-performance ROI reporting if/as needed
• Support ecommerce channel projects on time and within budget as well as ad-hoc analytical requests
• SME on account operational requirements and portal navigation, and DTC site navigation. Also act as a training guide for new ecommerce channel business analysts.

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 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
• Analyze competitive manufacturer ecommerce channel presence to identify market trends, pricing strategies, and product offerings

What You Need To Succeed

• High School Diploma required; 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 ecommerce retailers and/or DTC ecommerce platforms (e.g., Shopify, Magento) and CRM systems.
• 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 financial acumen 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
• Strong relationship building and communication skills; highly motivated and organized.
• 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 Eastern or Central US Time Zones

Why Work for Us?

• You’re seeking a rewarding opportunity that allows you to truly help others. With thousands of employees and customers around the world, there’s plenty of room to make an impact.
• You’re looking for a company that will invest in your professional development. As we grow, we want you to grow with us.
• You want a culture that promotes work-life balance. Our employees enjoy generous paid time off, because at Allegion we recognize that you have a full life outside of work!
• You want to work for an award-winning company that invests in its people. Allegion is proud to be a recipient of the Gallup Exceptional Workplace Award for the second year in a row, recognizing our commitment to employee engagement, strengths-based development, and unlocking human potential.

What You’ll Get From Us

• Health, dental and vision insurance coverage, helping you “be safe, be healthy”
• Unlimited Paid Time Off
• A commitment to your future with a 401K plan, which currently offers a 6% company match and no vesting period
• Health Savings Accounts — Tax-advantaged savings account used for healthcare expenses
• Flexible Spending Accounts — Tax-advantaged spending accounts for healthcare and/or dependent daycare expenses
• Disability Insurance –Short-Term and Long-Term coverage, paid for by Allegion, provides income replacement for illness or injury
• Life Insurance — Term life coverage with the option to purchase supplemental coverage
• Tuition Reimbursement
• Voluntary Wellness Program — Simply complete wellness activities and earn up to $2,000 in rewards
• Employee Discounts through Perks at Work
• Community involvement and opportunities to give back so you can “serve others, not yourself”
• Opportunities to leverage your unique strengths through CliftonStrengths assessment & coaching

Compensation:

• The expected Base Salary Range: $75,000-$110,000. The actual compensation will be determined based on experience and other factors permitted by law.
• Bonus Eligible: Yes

Allegion is an equal opportunity and affirmative action employer