Sr Business Systems Analyst

Company: Advantage Solutions
Location: Irvine
Posted on: September 11, 2023

Job Description:

**Summary** You will be part of a high-performance team responsible for building a marketing analytics platform. The primary purpose of this position is to design, develop, and maintain analytics dashboards and reports to suit internal business needs and external client requirements. This requires consulting with business and technical stakeholders to determine dashboard and report specifications then building production ready assets to meet those specifications. **Job Duty** Create analytics reports and dashboards to provide valuable, relevant business insights for internal users and clients Clean and transform data using DBT & SQL to prepare accurate, optimized reporting datasets. Identify, define, and prioritize reporting requirements. Create data models, tables, indexes, and stored procedures in PostgreSQL, BigQuery, and DBT to support performant, optimized data warehousing and reporting workflows. Field questions about existing reports and create ad hoc and/or customized reports when necessary. Collaborate with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies **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** 2-5 years of experience in creating business intelligence dashboards and reports in Tableau, PowerBi, Sisense or Looker (Looker strongly preferred). 3+ years of experience preparing complex data sets for analysis. Experience with DBT strongly preferred. 3+ years of experience writing complex SQL against transactional and analytical databases. Experience with Postgres and BigQuery preferred. 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 Strong communication skills, both written and spoken Ability to set priorities and organize work to meet deadlines Experience in consumer-packaged goods industry a plus Strong attention to detail and ability to QA complex data **Skills, Knowledge and Abilities** Excellent written communication and verbal communication skills Good interpersonal skills Decision making skills Analytical and research 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 Ability to work effectively with management Ability to research and analyze data effectively 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 ASM Job Duties and Job Descriptions** Job duties include additional responsibilities as assigned by ones 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. ASM 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. ASM 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. **Responsibilities** The Company is one of North Americas 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** The Sr Business System Analyst will work with internal and external customers in gathering functional requirements documents, understanding application architecture, and managing the unit testing of deliverables. Candidate should have an understanding of Software Development Life Cycle Methodologies and knowledge of Business Intelligence platforms. **Essential Job Duties and Responsibilities** + Train/Onboard new and existing customers + Meet with clients and gather report specifications to then deliver to Business Intelligence team. + Monitor client usage to ensure client retention + Monitor expired client portal passwords + Create help documentation for Company's Reports + Provide basic level internal sales functions to existing clients/customers **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 and Driving are essential duties and function of this job Travel up to 15 % **Minimum Qualifications** Education Level: **(Required):** Bachelor's Degree **or** equivalent experience Field of Study/Area of Experience: Business 5+ years of experience as business systems analyst, sales analyst, or related area. Experience using Retail Link is required. **Skills, Knowledge and Abilities** + Strong written communication and verbal communication skills + Strong prioritization skills + Ability to understand and follow specific instructions and procedures + Ability to exercise sound judgment + Ability to gather data, to compile information, and prepare reports + Ability to research and analyze data effectively + Ability to develop strategic plans to grow the business + Well-organized, detail-oriented, and able to handle a fast-paced work environment + Track record of building and maintaining customer/client relationships + 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 + Ability to complete multiple duties with accuracy shifting from one to another with frequent interruptions and competing deadlines + Strong computer skills including proficiency with Microsoft Word, Excel, PowerPoint, Access, Outlook, and web-browsers + Intermediate level knowledge of PC software applications and strong understanding of PC operating systems **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 The Company Job Duties and Job Descriptions** Job duties include additional responsibilities as assigned by ones 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. **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 - US-CT-Stamford - US-WA-Seattle - US-CA-East Irvine_ **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-428954_ **Position Type** _Full Time_ **Category** _Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)_ **Minimum** _USD $70,000.00/Yr._ **Maximum** _USD $90,000.00/Yr._

Keywords: Advantage Solutions, Irvine , Sr Business Systems Analyst, Professions , Irvine, California