Specialist, Merchandise Planning and Reporting

Position Summary: Specialist, Merch Planning & Reporting

Responsible for supporting vendor planning, merchandising and planning functions, providing analytics, tracking performance, troubleshooting, developing and updating reports, and providing systems support.

Responsibilities will include, but will not be limited to the following:

• Support Merchandise Planning through annual budget and monthly forecast processes, communicating due dates, validating results, and supporting applications and databases to archive data
• Transform multiple submitted team reports into executive level views used to support key business processes including Joint Business Planning, Vendor Funding, Annual Budget, Advertising Tracking, In-stock, Fill-rate, Forecast Accuracy, and other Merchandising reports
• Gather user requirements and partner with Data and Business Intelligence (BI) teams to create dashboards and reports that support budgeting, forecasting, and reporting processes
• Perform data analysis ensuring accurate data interpretation while investigating and correcting any inaccuracies
• Leverage technical skills to manipulate large data sets with MS office tools into consumable, intuitive reports, that assist Merchandising teams with KPIs to aid in decision making
• Utilize macros, VBA, and SQL scripts to pull and automate reports within Excel and MS Access, enhancing efficiency in data handling.
• Track and report on marketing initiatives, focusing on store activations and related inventory stocking levels and sales performance.
• Support vendor funding tasks with data entry, communicating term changes, and providing accurate deal details to ensure transactions and accrued and deducted properly from vendors
• Document business processes with step-by-step instructions to support resource library
• Lead user acceptance testing (UAT) for system updates, resolving bug fixes, issues, data corrections and enhancements.
• Create and escalate tickets to log issues with appropriate teams, providing steps taken, screen shots showing errors and unexpected results
• Assist in merchandising and Planning tasks, planning and tracking objectives to enhance operational transparency and actionable insights.
• Additional duties as assigned

To join our band, you'll need the following experience:

• Bachelor's Degree (or 4 years of relevant work experience), preferably in Business, with 4 years of relevant work experience in Planning or a similar field.
• Skilled proficiency modeling and building complex reports in Excel and Access.
• Proficient in Microsoft Office, including Word and Outlook.
• Strong oral and written communication skills, with a focus on organizational skills and time management to meet deadlines.
• Fundamental understanding of Business Intelligence and graphical reporting tools, including Microstrategy and Tableau, as well as data mining functions, advanced Excel formulas, Excel pivot tables, and data queries of external databases.

Why Guitar Center? Here's just some of the rewards:

For our employees who are musicians we offer the unique opportunity of gig leave-take time off to share your music with the world and return to your job after your tour! Guitar Center offers robust benefits and perks, including Medical, Dental, Vision,401K plus company match, mental health support, paid sick/holiday/vacation time, employee discount program, and tuition reimbursement options.

Pay Rate:$30.00- $37.00/hr depending on background and experience.

The job posting is not necessarily reflective of actual compensation that may be earned, nor a promise of any specific pay for any specific employee, which is always dependent on actual experience, education, and other factors. The pay range(s) listed are provided in compliance with state specific laws. Pay ranges may be different in other locations.

About Guitar Center

The Guitar Center Company embodies the world of creativity and music by encouraging our teammates to find their own individual sound. Our mission is to develop and nurture lifelong musicians and make a difference in the world by enabling musicians and non-musicians alike to experience the joy that comes from creating music. We believe in putting our customers first, engaging with respect and integrity and fulfilling our mission with passion.

The Guitar Center Company operates through several business divisions. Guitar Center is the world's largest retailer of guitars, amplifiers, drums, keyboards, recording, live sound, DJ, and lighting equipment, with more than 290 stores across the United States. 2014 marked the milestone 50th anniversary of the Guitar Center Company as the organization continues to help people make music from coast to coast.

E-Commerce brands Guitar Center, Musician's Friend and WWBW offer online sales of a broad selection of music products.The Music & Arts division operates more than 220 stores specializing in band & orchestral instruments for sale and rental, serving teachers, band directors, college professors, and students since 1952. AVDG and GCPro headline the enterprise audio-visual integration business, delivering a best-in-class commercial and residential customer experience.

Why join us?

With a career at Guitar Center, you become part of the world's largest multichannel musical instrument retailer. Whether at our Stores, Contact Centers, Distribution Centers, or Support Center, Guitar Center employees have a common goal: to help people find their sound and fill the world with more music.

Love this gig and want to apply?

Send your resume and cover letter today along with salary expectations!

Guitar Center is an Equal Opportunity Employer and provides fair and equal employment opportunity to all employees and applicants regardless of race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, veteran status or any other protected status prohibited under Federal, State, or local laws. All employment decisions are based on valid job-related requirements.

If you are a qualified individual with a disability or a disabled veteran and are unable or limited in your ability to use or access our website, you may request a reasonable accommodation to express interest in a specific opening. You can request reasonable accommodation by calling 1-818-735-8800 ext. 2862 or by sending an email torecruiting@guitarcenter.com.