Sr Analyst, Strategic Planning & Insights

Job Purpose  
 

The Sr Analyst, Strategic Planning & Insights will own, analyze and integrate large internal and external datasets from different sources to support data driven decision making across commercial strategy and sales execution. The Sr Analyst will own responsibility over modeling sophisticated retail problems, discovering actionable insights and surfacing sales enablement opportunities through the use of statistical, algorithmic, mining and visualization techniques. The candidate should have extended business knowledge as well as technical abilities. The Sr. Analyst should be able to translate business critical metrics into data requirements then either develop or partner with Business Intelligence to generate scalable final data sets and reporting outputs. This role partners closely with business leadership, commercial teams, and data engineering groups to transform and communicate complex data into impactful business recommendations and support automation and process optimization. 

Essential Functions & Responsibilities  

• Advance data analysis skills, programming, & data engineering 
• Lead sales analytics projects with key partners from the Commercial Analytics Platform (CAP), Business Units (BU) and Field Sales to provide tools and insights to all leadership teams 
• Integration of information across groups and projects and not siloed to one team or one project 
• Work proactively with brand and cross functional teams to understand business questions/objectives, identify the information currently available, clearly define the gaps and articulate a proposed methodology and plan to deliver on these requirements 
• Distill modelling and analysis findings into key concrete insights and clearly communicate results through clear and effective storytelling 
• Do exploratory data analysis and navigate large dataset to come out with broad conclusions 
• Use algorithms and programming to efficiently go through large datasets and apply treatments, filters and conditions to the data 
• Create meaningful data visualizations that communicate findings and relate them back to insights that generate business impact 
• Partner with IT teams to turn data into critical information and knowledge that can be used to make sound organizational decisions and to build data validation frameworks ensuring the data coming to business is reliable and accurate 
• Validate findings using experimental and iterative approach 
• Serve as a liaison between technical and business teams to drive business, helping to translate business needs into scalable reporting and analytical tools and helping to simplify and distill back clear findings from complex data sets 

Key Projects  

• Support the design, development, automation, and adoption of data pipelines to support routine Sales Execution reports and analytical workstreams 

• Build process improvement tools and algorithms that will ensure efficiencies through the sales organization saving data consolidation and data manipulation time across the sales teams

• Build front-end management tools and reports that will enable business to breakdown results and perform various analysis 

• Perform analysis on BU and Sales priorities and selling objectives to ensure we know how to close the gap on business opportunities 

• Maintains knowledge of products, pricing, services, market dynamics to perform strong analysis with insightful findings to the business teams 

• Maintains complete knowledge of company policies, programs and procedures and ensures team members adhere to them when performing duties 

• Support ad-hoc data requests from BU or Sales teams 

• Analyze and visualize data and present business insights to business partners 

• Train end users to appropriately use different data sets 

Expected Experience & Required Skills  

• ​​Bachelor’s degree required - math, finance, engineering, statistics, business or related discipline is required 

• ​2+ years of experience working in Business Intelligence or Data analytics within a large-scale company or fast-paced environment  

• ​Advanced in Microsoft Excel 

• ​Proficiency in PowerBI 

• ​Experienced with Snowflake and reading/ writing SQL queries 

• ​Skilled in PowerPoint 

• ​Experience in manipulating or analyzing syndicated data, IRI/ Circana or Nielsen preferred 

• ​Proven analytical and quantitative skills and ability to use hard data and metrics to back up assumptions and develop business cases 

• ​Experience working with large structured and unstructured data sets 

• ​Skilled at problem solving and idea leadership 

• ​​Strong drive for achieving results 

• ​Ability to work autonomously with minimal supervision 

• ​Experience in partnering with business owners to understand requirements, develop project timelines, and deliver data sets or analysis on time 

• ​Experience with cross-functional analytics initiatives that influence decision making across business stakeholders and business units 

• ​Good interpersonal, communication and negotiation skills 

• ​Ability to influence multi-functional team members 

• ​Deep Technical and Systems orientation 

• ​Motivated self-starter who can effectively work under pressure and manage multiple priorities 

• ​Strong verbal/written communication & data skills, including an ability to effectively communicate with both business and technical teams 

• ​Ability to self-direct, multitask, and prioritize a constantly evolving workload