Job Description

Job Type Full-timeDescriptionJunior Business Analyst - Creature Comforts Brewing Company Location: Athens, GAJob Family: SpecialistReports To: Business Analytics ManagerExemption: ExemptPosition 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 MaintenanceExtract, 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 AnalysisReview 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 SupportUpdate 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.RequirementsQualifications:Bachelor's degree in Management Information Systems, Statistics, Data Science, or a related field.High proficiency in Microsoft Excel0-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 TableauPhysical Requirements:The physical demands described here are representative of those that must be met by an employee tosuccessfully perform the essential functions of this job. Reasonable accommodation may be made toenable 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 productionand warehouse areas.DisclaimerThe 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. Creature Comforts Brewing Co.

Job Tags

Similar Jobs