Marketing Analyst

Chicago, Illinois
Legacy Marketing

Experience is everything.

We blur the line between brand and lifestyle to spark conversation and inspire action. As one of the largest independent experiential agencies in North America, we seamlessly blend strategy, creative, and production to develop impactful activations for global brands.

At Legacy Marketing, measurement and data capture are central to what we do. We work with our clients to determine KPIs and track metrics that are directly related to their objectives. We build custom, dynamic reporting dashboards, using best-in-class software tools, that visually tell the story of a campaign’s performance.

YOUR ROLE

The Marketing Analyst will work collaboratively with Legacy’s Account Management, Strategy and Planning teams. In this role you will contribute to every aspect of the reporting lifecycle at Legacy, from implementing reporting strategies and building in-depth post event recaps, to cleansing large data sets to prepare for visualization and insights, to producing the final dashboard output for internal and external stakeholders. This individual’s recommendations based on sound analytics and statistically significant data points will help determine how to grow our efforts as an agency in providing the best results for our clients.

PRIMARY RESPONSIBILITIES

• Source and aggregate data from multiple databases, primarily in the on-premise/off-premise space for well known spirits/alcohol brands
• Cleanse, verify and validate data
• Create, maintain and support reporting dashboards to evaluate KPI performance, while also extrapolating key insights and trends
• Use sales data to determine velocity
• Interpret and input sales data into post event recaps
• Collaborate with cross-departmental teams (Account Teams, Strategy, Planning, etc.)
• Create and refresh data transformation workflows that are used to aggregate and manipulate large, complex data sets
• Design and develop reporting visuals and dashboards that are intuitive and help tell the story behind the data
• Support data warehouse management, including adding new data and creating views to extract data for new and existing reports

SKILLS & REQUIREMENTS

• 2-4+ years of experience in an analytics role using descriptive and diagnostic analytics
• Demonstrated 2+ years using Tableau (or equivalent) to create visual reports that are dynamic and intuitive
• Proven ability to take insights and turn them into actionable steps that can drive business value
• Excellent communication skills with ability to communicate complex concepts verbally and in writing to multiple stakeholders with a variety of analytics knowledge and understanding
• Curious nature with desire to expand analytical, data visualization (Tableau) and storytelling skills
• Detail-oriented
• Highly motivated, problem-solver with strong critical thinking skills
• Ability to multi-task, manage timelines and deliverables of several projects simultaneously
• Microsoft SQL experience preferred
• Experience working with on/off-premise accounts or with beer, wine, spirits clients a plus
• Must be highly proficient in Excel
• Alteryx experience desired, but not required
• BA or BS degree (Statistics, Math, Economics, Business Administration or Marketing preferred)

SALARY & BENEFITS

• $65,000 – $75,000/year
• 18 PTO days per calendar year
• Medical, dental, vision coverage
• 401K with company match