What are the responsibilities and job description for the Merchandising Strategy Analyst position at LanceSoft, Inc.?
**This is starting out as a 3 month contract, but the HM plans to extend based on performance/business needs
*****This is hybrid role - candidate must be willing and able to go onsite, Tuesday-Thursday
**Prescreen requirements: (3 parts)
- Please have the candidate complete the following business questions and have the response at top of resume;
The financial services and gift card business ended last week at $2.08M in sales. Sales were up $85K or 4% to LY. Units were up 158K.
What methods would you use to analyze category performance and how would you identify drivers of the performance to LY?
- Additional Questions that MUST be answered at top of resume:
How many years of experience? ( 3 to 5 years analytical experience in a business environment. Ability to multi-task several concurrent requests
and quickly pull together data.)
Do you have supplier or retail background ?
Do you have Project management experience ?
Do you have Payments or gift card experience ?
Do you have Reporting and analyst experience?
Business software - Micro strategy or tableau.?
- Please have the candidate complete an advanced excel assessment and have a screenshot of the score at the top of the resume
The candidate selected for this position will be a creative, out-of-the-box thinker who is intellectually curious with a demonstrated interest in learning. This person will also need to be a self-motivated, entrepreneurial individual who can function in a performance-driven environment. He/she must be accustomed to working on multiple tasks in parallel. This professional must demonstrate strong team player and leadership skills.
The ideal candidate will also:
- Be highly organized, and possess strong planning and time management skills
- Communicate in an open and honest way that builds trust and respect
- Be a collaborative and flexible team player
- Be comfortable working on a cross-functional team
1. Quantitative Analysis: Collaborate with the Category Management Team(s) to scope and plan any and all financial and quantitative analyses that will aid in day-to-day management of the business and yield critical answers to longer-term strategic questions. Understand the required data sets to complete the analyses and procure them accordingly. Manage the delivery of timely, zero-defect analyses to support insight development. Run ad hoc analysis upon request and provide actionable insights with recommendations for next steps
2. Product Management: Run Daily sales, seasonal reporting, weekly vendor reporting and analyze market data to assist in decision making. In addition,
• Partner with Category Management teams to build promotional plans and activities related to everyday and seasonal businesses. Attend proofing meetings and partner with Merchandising Analytics to manage funding.
• Attend seasonal meetings and work with Category Management teams to assist with item selection and coordinate all billing and end of cycle disposition.
• New Item set up and maintenance for planogram and mid-year items.
• Off-Shelf coordination of off-shelf programs with key suppliers, setting up programs and running off-shelf reporting.
• Oversee price change activities.
3. Communication Development & Project Manage: Communicate effectively, both verbally and on paper, to Merchandising and Cross-Functional teams throughout the organization. Partner with outside partners. Assist with communication and reporting on sales performance, seasonal sales and sell thru and ad planning. Distill findings and craft a succinct and powerful business case that effectively communicates actionable recommendations. Support the development of presentations for mid-level and senior executives. Keep projects on track and moving forward.
Experience:
MUST HAVES:
- 3 to 5 years analytical experience in a business environment. Ability to multi-task several concurrent requests and quickly pull together data
- Supplier/Retail Background
- reporting analyst exp
- micro strategy or tableau - exp and knowledge
Education:
Educational Credentials: The right candidate will possess a Bachelor’s Degree in Business Administration, Marketing, Finance or similar field.
*****This is hybrid role - candidate must be willing and able to go onsite, Tuesday-Thursday
**Prescreen requirements: (3 parts)
- Please have the candidate complete the following business questions and have the response at top of resume;
The financial services and gift card business ended last week at $2.08M in sales. Sales were up $85K or 4% to LY. Units were up 158K.
What methods would you use to analyze category performance and how would you identify drivers of the performance to LY?
- Additional Questions that MUST be answered at top of resume:
How many years of experience? ( 3 to 5 years analytical experience in a business environment. Ability to multi-task several concurrent requests
and quickly pull together data.)
Do you have supplier or retail background ?
Do you have Project management experience ?
Do you have Payments or gift card experience ?
Do you have Reporting and analyst experience?
Business software - Micro strategy or tableau.?
- Please have the candidate complete an advanced excel assessment and have a screenshot of the score at the top of the resume
The candidate selected for this position will be a creative, out-of-the-box thinker who is intellectually curious with a demonstrated interest in learning. This person will also need to be a self-motivated, entrepreneurial individual who can function in a performance-driven environment. He/she must be accustomed to working on multiple tasks in parallel. This professional must demonstrate strong team player and leadership skills.
The ideal candidate will also:
- Be highly organized, and possess strong planning and time management skills
- Communicate in an open and honest way that builds trust and respect
- Be a collaborative and flexible team player
- Be comfortable working on a cross-functional team
1. Quantitative Analysis: Collaborate with the Category Management Team(s) to scope and plan any and all financial and quantitative analyses that will aid in day-to-day management of the business and yield critical answers to longer-term strategic questions. Understand the required data sets to complete the analyses and procure them accordingly. Manage the delivery of timely, zero-defect analyses to support insight development. Run ad hoc analysis upon request and provide actionable insights with recommendations for next steps
2. Product Management: Run Daily sales, seasonal reporting, weekly vendor reporting and analyze market data to assist in decision making. In addition,
• Partner with Category Management teams to build promotional plans and activities related to everyday and seasonal businesses. Attend proofing meetings and partner with Merchandising Analytics to manage funding.
• Attend seasonal meetings and work with Category Management teams to assist with item selection and coordinate all billing and end of cycle disposition.
• New Item set up and maintenance for planogram and mid-year items.
• Off-Shelf coordination of off-shelf programs with key suppliers, setting up programs and running off-shelf reporting.
• Oversee price change activities.
3. Communication Development & Project Manage: Communicate effectively, both verbally and on paper, to Merchandising and Cross-Functional teams throughout the organization. Partner with outside partners. Assist with communication and reporting on sales performance, seasonal sales and sell thru and ad planning. Distill findings and craft a succinct and powerful business case that effectively communicates actionable recommendations. Support the development of presentations for mid-level and senior executives. Keep projects on track and moving forward.
Experience:
MUST HAVES:
- 3 to 5 years analytical experience in a business environment. Ability to multi-task several concurrent requests and quickly pull together data
- Supplier/Retail Background
- reporting analyst exp
- micro strategy or tableau - exp and knowledge
Education:
Educational Credentials: The right candidate will possess a Bachelor’s Degree in Business Administration, Marketing, Finance or similar field.
Salary : $40 - $44
