Associate Manager, Business Planning and Sales Insights

This is a Full Time Job

The Associate Manager of Sales Planning is responsible for supporting the VP and Director of Sales Planning by providing sales analytics and financial models, in support of the organization's commercial goals. The individual will provide transactional and revenue forecasts, conduct critical sales and business analytics, integrating multiple data sources and providing an objective viewpoint and recommendations to the Sales Team. This position requires not only strong analytical and operational expertise, but also excellent communication skills – the ability to present complex data in clear, visually appealing, and executive-ready formats. This role focuses on providing Sales Planning functional leadership, analytical, and technical support to the Digital business at the national & account levels.

Responsibilities
1. Account Management
• Responsible for supporting Apple and Google
• Create power point presentations to illustrate YoY financial results and present during Account Business Reviews
• Provide account-level and consolidated revenue and gross profit forecasting by title and product lifecycle
• Utilize account-level analytics to incorporate long range planning, recurring business reviews, promotion analysis, seasonality trends relative to the industry, and other ad-hoc analyses
• Conduct account-level title assortment based upon performance, pricing, and other account-level trends to help drive sales volume and profitability
• Analyze Profit and Loss (P&L) reporting to assess account and/or line of business profitability against forecast and budget
• Develop, manage, and analyze account-level reports and trackers to provide key account-level insights and recommendations to support business planning, promotion management, performance evaluation, goal forecasting, and title and assortment planning
• Ability to work independently and have confidence in making your own decisions

2. Data Management & Analytics
• Analyze account data and provide performance results on marketing programs along with insights and identify opportunities to grow revenue to the commercial team; ability to utilize data to create compelling stories
• Audit and reconcile remittances to ensure accurate payments are being received based on retailer POS reports
• Provide supporting data to the Digital Sales team to help influence decisions and provide performance results on marketing programs along with insights and identify opportunities to grow revenue to the commercial team; ability to utilize data to create compelling stories
• Be a key partner across all functional teams by providing data and key insights on the Digital business
• Be able to analyze and summarize large data sets into an effective summary to facilitate decision making and strategic planning
• Coordinate internally to develop relationships with other Sony business units as necessary
• Ensure data integrity by proactively monitoring and striving to maintain high levels of quality, accuracy, and process consistency within Sales Planning
• Be the expert in digital data; understand data sources and nuances of each account
• Provide ad-hoc analyses as requested by senior leadership

3. Sales Planning Processes & Tools
• Work closely with the Project Lead and Development Team of our internal software (Commercial Tool) and implement new functionality to enhance efficiency within the team
• Create templates and tools that will reduce inefficiencies when aggregating data across multiple accounts
• Work with the Sales Planning Director to envision, develop, and manage Sales Planning core processes & tools in support of the account teams
• Assist in the creation of internal business planning tools to measure account performance against annual goals
• Ensure accuracy of business plans, forecasts, and outputs
• Create templates and manage processes around account P&Ls and post analyses to ensure consistent methodology across the business is used

4. Cross-Account Management
• Consolidate and aggregate data across all Digital Accounts to report on sales performance and provide actionable insights
• Manage sales reporting and analytics. Present results in a clear and concise format that support leadership in executing strategy
• Escalate key issues such as deviations in performance to the Director of Sales Planning and conduct detailed analytics to make appropriate recommendations
• Coordinate with Sales Planning Analysts to ensure delivery of sales performance reports to the leadership team in a timely manner

QUALIFICATIONS
• Bachelor's Degree in Business Management, Finance, Economics, Statistics or relevant field is strongly preferred
• A minimum of 4-5 years relevant experience is required. Experience within the entertainment/consumer goods industry collaborating with both internal and external sales and management teams is strongly preferred
• Advanced knowledge with Microsoft Office applications particularly Excel (VLOOKUP, SUMIFS, INDEX MATCH, pivot tables and reporting) and PowerPoint
• Some experience with Business Objects and or other BI analytics tools (Tableau, Alteryx)
• Demonstrated skills in defining problems, analyzing, and synthesizing data, drawing conclusions, and developing actionable recommendations for the business
• Prior work experience within a fast-paced sales environment is required
• Strong interpersonal skills and ability to communicate effectively (both written and verbal) with varying levels of management and with external customers
• Strong presentation skills and ability to tell a story using data
• Prior experience collaborating cross-functionally with various teams and departments
• Ability to work independently and thoroughly through a fast paced, dynamic environment
• Excellent attention to detail and capability to prioritize workload to meet deadlines