Sr Business Analyst

Advantage Sales & Marketing dba Advantage Solutions•Boise, ID

About The Position

Sr. Business Analyst This senior-level role is ideal for a highly technical professional with experience in data automation, tool-building, and data structuring within a retail, grocery, or CPG environment. Supporting the Albertsons Schematics team, this individual will develop macros, queries, and automated tools that enable business teams to efficiently utilize data. The Sr. Business Analyst will independently manage technical workstreams, collaborate with cross-functional partners, and ensure high‑quality, accurate data outputs that support operational excellence. Take this opportunity to join one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management, and marketing services. The Company bridges the gap between manufacturers and retailers across grocery, mass, specialty, convenience, drug, dollar, club, hardware, consumer electronics, and home centers—helping consumers access the best products in the marketplace today. What we offer Full-Time Benefits (Medical, Dental, Vision, Life) 401(k) with company match Training and Career Development Generous Paid Time-Off Responsibilities 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 Data Analysis/Interpretation/Recommendation · Analyze business needs/requirements and provide recommendations to implement and administer new/existing products, processes, and systems · Identify client organization's strengths and weaknesses and suggest areas of improvement · Utilize various data systems, extract raw data from reporting systems, and conduct in-depth analysis on various KPI’s · Define major business opportunities by prioritizing information to support the goals of our Clients, Customers, and Company · Consult with internal and external customers to present data and provide actionable insights to assist with meeting business objectives, tactics, or marketing strategies Project/Client Management and Support · Perform project management duties by executing project schedules and deadlines, monitoring project progress, coordinating activities, resolving problems, and ensuring timely deliverables · Communicate effectively with clients to identify needs and evaluate alternative business solutions with project management · Provide business updates and track overall business KPI’s for management and executive team · Manage and maintain ongoing strategic and collaborative relationships Manage Direct Reports · Manage, train, and mentor team to help them achieve skill development and professional objectives · Manage workload of direct reports to ensure client satisfaction · Create best-in-class practices for team to follow · Ensure team thoroughly understands companies' businesses and the issues and challenges facing the industry and organization Miscellaneous · Perform other job-related projects as needed Supervisory Responsibilities Direct Reports - Hires, retains, trains, coaches, guides, directs, and develops direct reports using company-wide processes, tools and resources Indirect Reports - May delegate work of others and provide guidance, direction and mentoring to indirect reports Travel and/or Driving Requirements - Travel and Driving are not essential duties or functions of this job

Requirements

Bachelor’s Degree or equivalent experience.
3+ years of experience in technical data role involving:
Advanced Excel (including macros)
Queries and/or automated data workflows
Dashboarding tools (Power BI preferred)
Strong technical and analytical abilities, including macro development and dashboard creation.
Advanced Excel proficiency; familiarity with Power BI or similar tools.
Ability to manage multiple projects and prioritize effectively.
Strong organization, accuracy, and attention to detail.
Clear and professional written and verbal communication.
Strong customer service orientation.
Ability to work independently and meet deadlines with minimal supervision.
3-5 years of experience in sales/category insights and analytics role (CPG or Agency)
Analytical and research Skills
Ability to direct, lead, coach, and develop people
Team building Skills
Ability to work independently and prioritize duties with minimal supervision, in order to meet deadlines
Ability to complete multiple duties with accuracy shifting from one to another with frequent interruptions and competing deadlines
Excellent customer service orientation
Strong computer skills including proficiency with Microsoft Word, Excel, PowerPoint, Access, Outlook, and web-browsers

Nice To Haves

Experience with retail, grocery, or CPG datasets is highly preferred but not required; technical skills are the top priority.

Responsibilities

Data Analysis, Tool Building & Data Structuring Extract, clean, organize, and structure large datasets from multiple systems.
Build automated tools, macros, dashboards, and queries to streamline internal processes.
Analyze business needs and recommend technical solutions related to data flow, automation, or tool design.
Identify opportunities to improve efficiency through tool enhancements or system improvements.
Prioritize information and technical output to support the goals of Clients, Customers, and the Company.
Note: This role does not perform insights storytelling, business recommendations, or narrative analysis.
Project/Client Management & Cross-Functional Support Manage individual technical projects and timelines to ensure high-quality, on-time tool delivery.
Communicate with internal partners to understand requirements and determine the best technical approach.
Support schematic, assortment, and related teams by delivering ready-to-use structured data and tools.
Maintain strong collaborative relationships across internal teams.
Analyze business needs/requirements and provide recommendations to implement and administer new/existing products, processes, and systems
Identify client organization's strengths and weaknesses and suggest areas of improvement
Utilize various data systems, extract raw data from reporting systems, and conduct in-depth analysis on various KPI’s
Define major business opportunities by prioritizing information to support the goals of our Clients, Customers, and Company
Consult with internal and external customers to present data and provide actionable insights to assist with meeting business objectives, tactics, or marketing strategies
Perform project management duties by executing project schedules and deadlines, monitoring project progress, coordinating activities, resolving problems, and ensuring timely deliverables
Communicate effectively with clients to identify needs and evaluate alternative business solutions with project management
Provide business updates and track overall business KPI’s for management and executive team
Manage and maintain ongoing strategic and collaborative relationships
Manage, train, and mentor team to help them achieve skill development and professional objectives
Manage workload of direct reports to ensure client satisfaction
Create best-in-class practices for team to follow
Ensure team thoroughly understands companies' businesses and the issues and challenges facing the industry and organization
Perform other job-related projects as needed
Hires, retains, trains, coaches, guides, directs, and develops direct reports using company-wide processes, tools and resources
May delegate work of others and provide guidance, direction and mentoring to indirect reports