Advantage Solutions
is hiring
Senior Business Analyst
About Our Company
Advantage Solutions is a leading provider of outsourced sales and marketing solutions to consumer goods companies and retailers. Our data- and technology-driven services — which include headquarter sales, retail merchandising, in-store and online sampling, digital commerce, omnichannel marketing, retail media and others — help brands and retailers of all sizes get products into the hands of consumers, wherever they shop. As a trusted partner and problem solver, we help our clients sell more while spending less.
Headquartered in Irvine, California, we have offices throughout North America and strategic investments in select markets throughout Africa, Asia, Australia and Europe through which we serve the global needs of multinational, regional and local manufacturers.
Job Description & 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
- 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%
Requirements
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
What we offer
Salary Range
$77,000/yr - $94,000/yr