Advantage Sales and Marketing Merchandising Jobs

Job Information

Advantage Solutions Senior Business Analyst in Chicago, Illinois


Job Summary:

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 accurate and insightful data analysis. As a Business Analyst at Advantage Solutions, you will play a crucial role in analyzing and interpreting data to provide valuable insights that drive informed business decisions. You will collaborate with cross-functional teams to identify business needs, gather requirements, and implement effective solutions. The ideal candidate is a strategic thinker with excellent analytical and communication skills, capable of translating complex data into actionable recommendations.

What we offer:

· Full-Time Benefits (Medical, Dental, Vision, Life)

· 401(k) with company match

· Training and Career Development

· Unlimited Paid Time-Off


o Work closely with stakeholders to understand business objectives and gather detailed requirements for projects and initiatives.

o Utilize analytical tools and techniques to interpret and analyze complex data sets.

o Identify trends, patterns, and anomalies to provide meaningful insights.

o Evaluate existing business processes and systems to identify areas for improvement.

o Recommend and implement solutions to enhance efficiency and effectiveness.

o Create detailed documentation of business requirements, process workflows, and system specifications.

o Ensure documentation is kept up-to-date and accessible to relevant stakeholders.

o Develop and present reports, dashboards, and presentations to communicate findings and recommendations to key stakeholders.

o Identify the specific needs of the business and create user stories.

o Work in align or scrum product team environment.


· Bachelor's Degree required or equivalent experience.

· Strong analytical and problem-solving skills.

· Excellent communication and interpersonal skills.

· 2+ years of experience in an analytical position

· Analytical & problem-solving skills

· Excellent time management skills with the ability to juggle multiple projects at once.

· Strong written and verbal communication skills with the ability to make oral presentations.

· Strong critical thinking skills

· Recommended but not requirement: 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.

Job Will Remain Open Until Filled


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.

Job Duty

· Identify, gather, and write business and functional requirements by breaking features down into user stories

· Serving as the liaison between business owners and Scrum-based BI development teams

· Write ad-hoc T-SQL of a complex nature to support reporting needs

· Develop product ownership by continuing growth in understanding of BI reporting systems and interdependencies with other corporate and external systems, business processes, and data; identifying opportunities for documentation of tribal knowledge for long-term organizational ownership

· Create indexes, tables, columns, and stored procedures as needed in our database environment

· Collaborate with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs

· Develop models and identify trends in support of the business using statistical analysis against data

· Implement and work with Microsoft Business Intelligence and/or Tableau tools (SQL and Excel) and dashboard reports.

Supervisory Responsibilities

Direct Reports

  • This position does not have supervisory responsibilities for direct reports

Indirect Reports

  • May delegate work of others and provide guidance, direction and mentoring to indirect reports

Travel and/or Driving Requirements

  • Travel is an essential duty and function of this job. Driving is not an essential duty or function of this job.

  • Travel up to 10%

Minimum Qualifications

Education Level: (Required): Associate's Degree or equivalent experience

(Preferred): Bachelor's Degree or equivalent experience

Field of Study/Area of Experience: Business, Computer Science, or equivalent job-related experience

· 5+ years of experience in with data mining and quantitative analysis

· 5+ years of experience writing complex SQL against large relational database systems, preferably

· Hands on experience with BI reporting tools such as Power BI and Tableau

Skills, Knowledge and Abilities

· Microsoft SQL Server 2008 or above

· Expert skills with Microsoft Excel; ability to create pivot tables, charts, and graphs; formatting documents, formatting cells, entering and modifying complex formulas, creating and modifying basic charts and graphs, and creating and modifying Pivot Tables

· Ability to develop efficient and self- documenting solutions

· Ability to understand, analyze, and articulate both complex business and complex technical concepts

· Ability to independently read and develop in following technologies: SQL, SSIS, SSAS, and SSRS

· Ability to lead and set priorities and organize work to meet deadlines

· Experience in consumer-packaged goods industry a plus

· Excellent written communication and verbal communication skills

· Good interpersonal skills

· Ability to exercise sound judgment

· Ability to make oral presentations

· Ability to gather data, to compile information, and prepare reports

· Ability to ensure a high level of service and quality is maintained

· Well-organized, detail-oriented, and able to handle a fast-paced work environment

· Flexible and adaptable, able to change and alter according to changes in projects or business environment

· Ability to work independently and prioritize duties with minimal supervision, in order to meet deadlines

Environmental & Physical Requirements

Office / Sedentary Requirements

Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.

Additional Information Regarding Advantage Solutions Job Duties and Job Descriptions

Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes. Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).

Important Information

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Job Locations US-IL-Chicago

Primary Posting Location : City Chicago

Primary Posting Location : State/Province IL

Primary Posting Location : Postal Code 60601

Primary Posting Location : Country US

Requisition ID 2023-430271

Position Type Full Time

Category Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)

Minimum USD $77,000.00/Yr.

Maximum USD $94,000.00/Yr.