Demand Planning Analyst

Job Description

Demand Planning Analyst

• Department: Merchandising
• Reports to: Global Merchandising Analyst

Pens.com personalized promotional products are created for and inspired by small businesses. With more than 50 years of experience and serving 22 countries worldwide, Pens.com provides personalized marketing solutions that help businesses connect with their customers through personal brand experience. National Pen offers a broad range of personalized promotional products, including writing instruments, stationery, drinkware, bags, gifts, and trade show accessories, and operates via a network of more than 10 facilities across North America, Europe, Africa, and Asia. **

The Demand Planning Analyst is responsible for gathering and analyzing data, communicating with stakeholders, and developing recommendations for improvement. He/she will support the Demand Planning team, Merchandising, and Product Data Management (PDM), with developing reports needed to make educated decisions that will drive profitable growth across e-commerce, telemarketing, and mail order. This role is directly responsible for collecting, interpreting, and using data to develop reports, including charts, graphs, and dashboards. This role also works closely with the central Data Analytics & Insights team, especially E-commerce Analytics, to ensure an in-depth understanding of channel level performance, and consistency across all reporting.

What You’ll Do:**

Collect, analyze, and interpret large volumes of data from internal sources:

• Identify patterns, trends, and opportunities within merchandising data to support decision making processes and drive strategic initiatives.
• Clean and organize data, applying statistical techniques, and using analytical tools and software.
• Leverage data to identify patterns, trends, and insights.
• Create clear documentation of all program plans, including scope of work, timeline, and implications. Collect, analyze, and interpret large volumes of data from internal sources.
• Identify patterns, trends, and opportunities within merchandising data to support decision-making processes and drive strategic initiatives.
• Clean and organize data, applying statistical techniques, and using analytical tools and software.
• Leverage data to identify patterns, trends, and insights.
• Create clear documentation of all program plans, including scope of work, timeline, and implications.

Prepare reports, presentations, and visualizations:

• When and where appropriate, build and maintain visualizations and dashboards using contemporary business intelligence/analytics platforms.
• Collaborate with internal stakeholders on the design, development, testing, and implementation of new content.
• Ensure complex information is presented in a clear and concise manner to support decision-making.
• Clean and preprocess data to ensure its accuracy and consistency, which involves handling missing data, removing duplicates, and converting data into a suitable format for analysis.

Support Demand Planning and Global Merchandising cross e-commerce, telemarketing, and mail order:

• Work closely with the Demand Planning Team to provide analytical support, including but not limited to assortment analysis, sell-through, product performance evaluation, forecasting accuracy, product health data
• Identify opportunities for process improvements and provide recommendations to enhance operational efficiency and effectiveness.
• Conduct ad-hoc analysis to address specific demand planning-related questions or challenges.

Partner with internal teams to ensure reporting is useful, scalable, standardized, and consistently providing the information needed to facilitate decision making:

• Partner with our data engineering and data warehousing team to manage new report requirements, builds, and maintenance.
• Communicate findings, insights, and recommendations to non-technical stakeholders in a clear and concise manner.
• Collaborate with Data Analytics & Insights team to ensure the availability, scalability, and security of data sources and business intelligence solutions.
• Collaborate with cross-functional teams, such as marketing, sales, and supply chain management, to align strategies and ensure that demand and supply are balanced effectively.

We’re Looking For:

• Bachelor’s degree or equivalent experience in Computer Science, Business, Economics, or related field
• 2+ years e-commerce analytical experience, specifically focused on Merchandising, Demand Planning, and/or Marketing
• Strong retail math skills and analytical skills
• Ability to research and analyze large amounts of data
• Proven experience with taking historical information and projecting trends
• Computer skills to include navigational ability in a networked environment and proficiency in Microsoft suite with advanced proficiency with Microsoft Excel and SQL
• Strong verbal/written communication skills
• Accountable and able to manage projects individually and work well as part of a team
• Team player, comfortable building effective relationships with business partners
• Goal orientated; ability to stay focused on delivering results
• Strong organizational and time management skills
• Self-starter with high energy to meet the needs of an evolving business
• Flexibility to work in a fast paced, quickly changing environment with multiple priorities

To learn more, visit: http://www.pens.com, National Pen is a Cimpress brand (Nasdaq: CMPR)

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation - no applicant will be penalized as a result of such a request.