Job Description
Business Intelligence Administrator - Incentives - Bolingbrook, IL
Job ID BOL00000410 Date posted 02/02/2019- Administer sales system including: creating and/or running reports, creating and/or cascading goals, account and territory management, staff training, etc.
- Distribute monthly sales reports from internal and external sources ensuring data integrity and ease of use, align brands with suppliers
- Prepare commercial analysis that recaps business performance by trade channel and sales inputs
- Organize and maintain account segmentation data within Information Technology system; review and update quarterly
- Update master records to define customer account segmentation
- Classify accounts based on volume and/or revenues
- Track competitive pricing activity based on sales input
- Create daily/weekly/monthly/quarterly pricing reports and analysis
- Run standard and ad hoc reports for business and supplier needs
- Analyze and rank teams and sales representatives that fail to deliver minimal standards
- Identify potential brand risks and opportunities
- Recap performance goals, and volume goals
- Perform maintenance of data dimensions and routine updating of tracking tools to promote accuracy and accountability
- Perform other duties as assigned
- Bachelor’s degree in Business, Finance, Marketing or related discipline and 3 years of experience in analyzing financial, sales, and operations data in consumer goods
- Proficient at calculating commissions, percentages, and reviewing comparative sales data for analysis
- Expert in Excel with regards to Data Management, Reporting, and Data Analysis
- Experience with Excel VBA, PowerPivot, and relational databases is strongly desired
- Expert knowledge of Excel VBA and PowerPivot with Sales experience
- Must maintain strong working knowledge of portfolio and products
- Possess the ability to perform complicated analysis like forecasting, regression, and cannibalization
- Impeccable organization and time management skills to handle multiple projects successfully
- Ability to quickly learn various business solutions programs (e.g., Diver, Business Objects, Sales Nav, Tableau etc)
- Ability to effectively present information and respond to questions from groups of managers, clients and customers
- Physical demands with activity or condition for a considerable amount of time include sitting and typing/keyboarding using a computer (e.g., keyboard, mouse, and monitor) or adding machine
- Physical demands with activity or condition may include occasional to rare amount of time include walking, bending, reaching, standing, and stooping
- May require occasional lifting/lowering, pushing, carrying, or pulling up to 20lbs
Southern Glazer's Wine and Spirits recruits and hires qualified candidates without regard to race, religion, color, sexual orientation, gender, gender identity, age, national origin, ancestry, citizenship, veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state and municipal laws. The Company prohibits discrimination on other bases such as ancestry, medical condition, or marital status under applicable laws. We make reasonable accommodations to meet our obligations under the Americans with Disabilities Act (ADA) and state disability laws. Candidates should possess the right to work in the United States, as it is not the general practice of Southern Glazer's Wine and Spirits to sponsor individuals for work visas.
Have an HR comment, question, or need more information about career opportunities at Southern Glazer's Wine & Spirits? Click here.
Job Matching
Let us connect you with jobs that match your LinkedIn profile.
Start Matching >