Sr. Sales Effectiveness Analyst

Description

As a Sr. Sales Effectiveness Analyst, you will help AMER GTM team members and Sales counterparts to generate performance reports, forecast upload, analyze data, support financial monthly forecast updates on volume and sales budget on a day-to-day basis. Moreover, you will work on helping the team to improve business reporting and operations by generating automated reporting, data analysis, support with internal tools, building data templates and collecting system requirements, working on data discrepancy investigations and various problem-solving tasks.

• Support internal business planning and GTM channel management for Pixel and wearables
• Track status of key sales activities and promotions, NPI and run rate business trends that may influence our outlook, and reflect the trend into weekly sell out forecast
• Work with the sales team to track latest promo plan in promo calendar, performance from promotional activities and actualize the run rate as well as required budget spend
• Support compliance management for RIB governance, finance V reconciliation
• Data, performance tracking (for sales volume and budget spend) and reporting
• Ensure and develop ongoing reporting to ensure that our baseline data - customer/channel mappings, pricing and distribution mapping are all clean so our business can operate successfully
• Regular running of key reports for the team, ensuring data accuracy and finding key insights in the data to share with the team
• Track key performance metrics - forecast, budget planning, budget spend across the team
• Perform large scale data analysis and modeling to identify trends and efficiency opportunities
• Provide ad hoc reporting and analyses efficiently and accurately
• Support team to generate various cuts of data, template based on business reporting needs
• Tools and systems:
  Drive efficiencies into the business tracking and monitoring progress by automating the process, tools and building new reporting views and automated dashboards via Tableau

• BA/BS degree or equivalent practical experience
• 5+ years of experience as a Sales or Business Analyst
• Experience forecasting hardware, ideally including deal-based businesses and using Anaplan
• Strong project management skills with ability to handle multiple projects simultaneously and to tight deadlines in a high paced and dynamic environment
• Existing relationships within Regional or District Carrier HQ and fluid at navigating Markets/HQ dynamics preferred
• Distinctive problem solving and structuring skills, with ability to synthesize data into useful formats and bring actionable insights through effective communication
• Exceptional and proven follow up/follow through, with extreme attention to detail
• Strong business, analytical, reporting, data manipulation, dashboard creation, and business intelligence skills
• Team player who thrives in a cross-functional collaborative environment
• Strong communication, organizational and time management skills
• Natural ability to build strong relationships, maintain a positive attitude and be self-motivated
• Fluency in data management and manipulation in Anaplan, Tableau and Salesforce
• Self-starter, independently motivated, but with a good sense of when to ask for help
• Thrives in a dynamic team environment
• Experience in consumer goods industry strongly preferred
• Fluency with Tableau, Excel, GSuite, Google Analytics, SQL, Dremel (Google Big Query), Plex

Education:

• Bachelor’s Degree
• 5 – 8 years

Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and food service agencies reimagining the way people connect with brands at every point in their shopping journey.

As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America.

We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward…