Junior Data Analyst

• Support Manager, Promo Analytics with day-to-day data collection, extraction and Financial reporting.
• Oversees weekly promotion frequency reporting and communications to Category Management team to ensure compliance of all promotion activities.
• Maintains and updates compliance and forecasts databases to protect data integrity and ensure accurate and current information is available as required.
• Coordinates auto shipment order generations to ensure adequate product for promotions and identify any concerns to be resolved prior to promotional events.
• Provide regular and ad-hoc reporting and data analysis with understanding of retail business processes and products
• Provides weekly support to the Manager and Sr. Director in preparing / updating financials and layout information for the weekly Ad Meeting
• Liaises with Category Management and Marketing Teams for Tier One Marketing Flyer events. Responds / resolves any issues / discrepancies throughout the planning process.
• Creates event flyers and other promotional materials to provide clear and accurate direction at the store level.
• Responds to emails and telephone inquiries from other departments to resolve issues or concerns in a prompt and effective manner.
• Support Category Management, Business Analytics, and the Promotions Team in maintaining / approving promotions
• Creates and coordinates promotional events and liaises with Category Management to ensure promotional event transmissions are accurate and concise.
• Maintains order exception lists and runs various reports to develop future promotional strategies and provide relevant data as required.
• Participate in special projects as required
• Approves and manages event cancellations, promo change forms including pricing changes, product substitutions, regional product changes and store order cancellations. Liaises with Supply Chain, Inventory, Category Management and Promotions Teams on respective changes

• In-depth knowledge of the MS Office suite, particularly MS Excel is required.
• Knowledge in VBA programing for Excel / Access / Outlook is strongly preferred.
• Basic understanding of SQL for MS Access, TeraData or other relational data base is preferred
• Demonstrate a strong desire and ability to learn and develop.
• Strong acumen for the retail business.
• This position requires a demonstrated level of initiative and judgment in order to organize and prioritize tasks, workload and projects. Courtesy, tact and diplomacy are required in managing cross departments working relationships.
• Requires an understanding of inter-related work processes to be able to adapt to differing assignments.

• Post-secondary Degree in Finance, Business, Mathematic, Statistic or equivalent.

• Greater than two years, but less than or equal to three years Finance, Business, Mathematic, Statistic, data science or equivalent experience

AppleOne