Sr Retail Business Analyst

Advantage Sales & Marketing dba Advantage Solutions•Pleasanton, CA

About The Position

Senior Business Analyst At our Company, we grow People, Brands, and Businesses! We are seeking a dedicated Senior Business Analyst to support the National Director of Retail Operations to make a discernible difference across operations with project management, data analysis, and a strong understanding and usage of Excel. Demonstrate knowledge of and experience with software tools to create, edit, and analyze complex reports, graphs, and presentations. Be able to make sound decisions and the ability to take initiative and accountability for the accuracy of information. Independently take ownership of projects to completion by effectively coordinating all the necessary resources. Resolve complex, non-routine problems and issues where no precedent has been established or exists with no supervision. Take this opportunity to join North America’s leading business solutions provider and build your career working with amazing people in a growing industry! Apply today! The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today. Position Summary Support the National Director of Retail Operations to make discernible difference across operations with accurate and insightful data analysis. Demonstrate knowledge of and experience with software tools to create, edit, and analyze complex reports, graphs, and presentations. Be able to make sound decisions and the ability to take initiative and accountability for the accuracy of information. Independently take ownership of projects to completion by effectively coordinating all the necessary resources. Resolve complex, non-routine problems and issues where no precedent has been established or exists with no supervision. Resolve complex, non-routine problems and issues where no precedent has been established or exists with no supervision.

Requirements

Bachelor's Degree required or equivalent experience
Project management experience
5+ years of experience in an analytical position
Analytical and problem-solving skills
Strong written and verbal communication skills with the ability to make oral presentations
Strong critical thinking skills
Advanced MS Excel, including pivot table creation, advanced formulas, vlookup function; Intermediate to advanced MS Access, including importing large data files, query creation, creating macros, reading/editing/writing VBA in modules
Analytical and problem-solving skills
Strong written communication and verbal communication skills
Strong critical thinking skills
Ability to make oral presentations
Strong prioritization skills
Ability to work independently and prioritize duties with minimal supervision, in order to meet deadlines
Strong computer skills including proficiency with Microsoft Word, Excel, PowerPoint, Access, Outlook, and web-browsers
Advance MS Excel, including pivot table creation, advanced formulas, vlookup function
Intermediate to advanced MS Access, including importing large data files, query creation, create macro, read/edit/write VBA in modules

Responsibilities

Utilizing various data systems, extracts raw data from the reporting system, and conducts an in-depth analysis of customer product flow. Consults with internal business partners or external clients to present data and recommends actions to assist the client with meeting business objectives.
Extracts data from third-party market research resources, integrates with internal data, and conducts trend analysis. Interprets results and presents recommendations to the business partner.
Works closely with business partners to develop report specifications based on client needs.
Manages ad hoc projects based on business partner or client requests.
Proactively develops and delivers presentations as required by the client.
Provides training and direction to lower-level Business Analysts.
Utilizing various data systems, extracts raw data from reporting system and conducts in-depth analysis on customer product flow. Consults with internal business partners or external clients to present data and recommends actions to assist client with meeting business objectives.
Extracts data from third-party market research resources, integrates with internal data and conducts trend analysis. Interprets results and presents recommendations to business partner.
Works closely with business partners to develop report specifications based on client needs.
Manages ad hoc projects based on business partner or client requests.
Pro-actively develops and delivers presentations as required by client.
Provides training and direction to lower-level Business Analysts.