Job Description
Description Junior Business Analyst – Creature Comforts Brewing Company Location: Athens, GA
Job Family: Specialist
Reports To: Business Analytics Manager
Exemption: Exempt
Position Purpose: The Junior Business Analyst assists our analytics team and supports data-driven decision making across the organization. In this role, you will be responsible for creating powerful data visualizations, ensuring product quality while mitigating out-of-stock risks, and transforming data into actionable insights across all departments.
Duties And Responsibilities - Data Cleaning and Report Maintenance
- Extract, transform, and load data from internal and external sources into company database.
- Check data for accuracy and clean data where possible.
- Create and update SQL-based reports as necessary.
- Build new Power BI reports and change existing reports using Power Query and DAX.
- Sales Order Analysis
- Review customer orders for quality and timeliness.
- Compare orders versus forecasted demand.
- Leverage forecasted demand with wholesaler inventory levels to estimate whether future inventory levels will be within allowed ranges.
- Recommend order changes to wholesalers and area managers as needed.
- Routine Reporting and Ad-Hoc Support
- Update and publish collection of Power BI reports on weekly and monthly cadences.
- Develop reporting package analyzing chain and account-level sales performance, determining promotion performance, and determining potential sales opportunities.
- Assist with routine and ad-hoc data analysis across all departments.
- Evaluate future in-house inventory levels and make recommendations for production changes.
- Ensure smooth data transmission to and from internal SAP system.
Requirements Qualifications: - Bachelor’s degree in Management Information Systems, Statistics, Data Science, or a related field.
- High proficiency in Microsoft Excel
- 0-2 years of relevant work experience, including internship experience.
- Excellent analytical skills
- Basic SQL knowledge
- Familiarity with data visualization tools such as Power BI or Tableau
Physical Requirements The physical demands described here are representative of those that must be met by an employee to
successfully perform the essential functions of this job. Reasonable accommodation may be made to
Enable Individuals With Disabilities To Perform The Essential Functions. While performing the duties of this job, the employee is regularly required to sit, walk, stand, use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. Specific vision abilities required by this job include close vision, color vision, depth perception, and ability to adjust focus. This role will primarily perform work duties in an office environment, with regular trips to the production
and warehouse areas.
Disclaimer The job description provided here is intended to outline the general nature and key responsibilities of this role. It is not intended to be an exhaustive list of all tasks, duties, and responsibilities that the employee may be required to perform. The employee may be asked to perform other duties as required. Furthermore, the duties and responsibilities of this position may change at any time, with or without notice, based on the needs of the organization.
Job Tags
Work experience placement, Internship,