Specialist I, Data Entry

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. This position follows a hybrid schedule, requiring on-site work Tuesday through Thursday, with the flexibility to work remotely on Mondays and Fridays.
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.
Assist in merchandising and Planning tasks, planning and tracking objectives to enhance operational transparency and actionable insights.
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.
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? 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.
About Guitar Center
The Guitar Center Company embodies the world of creativity and music by encouraging our teammates to find their own individual sound. 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.
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.
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. 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.

---