Retail in store communication Coordinator

• This role will support the graphic production team and assisting with interpreting complex distribution lists and enabling execution of marketing campaigns.
• in depth understanding of marketing campaigns and how they are executed.
• understanding of graphics to accurately interpret detailed large PDF documents containing various campaign related information.
• experience or knowledge developing and managing distribution lists for marketing campaigns
• excel heavy role, needs strong analytical skills (see jd for excel skills)
• should be open to learning, adaptable and positive mindset.
• ability to use campaign inputs and data to build accurate and efficient distribution lists.
• Interview process will consist of 2 rounds.
• Hybrid: 2 days per week in office, with potential for remote work in the future.

GENERAL FUNCTION

This role provides crucial support to the SGHNA RISC Team, which oversees visual merchandising for over 1,500 Sunglass Hut locations, including SGO stores (within Bass Pro and Cabela''s), Solaris, and host businesses like Bloomingdale''s and Macy''s. The RISC team is responsible for managing print production of all in-store initiatives (marketing/RISC/RSM/product), graphic inventory management, developing marketing visual guidelines, NRR graphic production and distribution, and marketing/RISC campaign planning.
The position requires a highly analytical individual who excels in data interpretation and analysis to support graphics management. The ability to interpret and build complex distribution lists will be key to this role. A solid background in project management, inventory management, and complex distribution list creation is essential to effectively contribute to the analytical demands of our team.
MAJOR DUTIES AND RESPONSIBILITIES

1. Support additional workload for SGH graphic needs especially for high priority urgent turn around timeline jobs
2. Support print campaign distribution lists for the below
   1. Urgent inventory pulls
   2. Hot jobs (business critical projects)
   3. Brand image updates based on expiration
   4. React to urgent promotion and new store openings needs
   5. Maintain new crops developed from NRR on code sheet template
   6. Upload needs on graphic platform
3. Update project trackers
   1. Manage job folders for owned projects
   2. Update jobs tracker for owned projects
   3. Record graphic spend

BASIC QUALIFICATIONS

1. Solid Microsoft Office Skills (Word, Excel, Power Point, etc.)
   1. Advanced Excel skills (PIVOT TABLES, V-LOOK UP, CONDITIONAL FORMATTING, DATA ANALYSIS & VALIDATION)
2. Strong Project management skills
3. Strong team skills and an aptitude for cross functional interactions
4. Candidate must be extremely detail oriented, able to think analytically with precision and consistency, and able to understand and manage the complexity of a diverse store groups
5. Strong communication skills, both verbal and written

PREFERRED QUALIFICATIONS

1. 3-5 years in similar position, preferably in a retail channel with multi-brands approach
2. Data analysis and navigating large complex spreadsheets
3. Understanding of multi-brand visual merchandising and store execution experience
4. Ability to work in a fast-paced changing environment
5. Highly organized and a self-starter
6. Strong team skills and an aptitude for cross functional interactions
7. Adobe CS software OR PPT skills to support graphic layouts