Data Analytics Intern - Balsam Brands (hybrid)
This is a Boise State WorkU internship opportunity! If you don't know what Work U is or need a refresher, please check out our webpage here. When you apply to Work U, you will be able to list your top three Work U opportunities. A full list of available Work U opportunities can be found here. READY TO APPLY? Start your application here!
Overview of Organization:
Balsam Brands is a global, eCommerce retailer (Balsam Hill) with roots in holiday and home décor. Our company's mission is to create joy together. We empower our team and partners to love what they do, provide products and experiences that inspire meaningful moments with family and friends, and give back to our families and communities in impactful ways. When you join Balsam Brands, you'll find a culture of caring people doing challenging work, and building a welcoming workplace.
Responsibilities:
- Analyze and generate reports on year-end sales trends, seasonal performance, and key events through the Holiday season
- Review the performance of selected products and determine profit viability
- Evaluate the performance of marketing campaigns such as catalog
- Assist in the preparation of data visualizations, dashboards, and presentations to cross-functional partners
- Assist with migrating data reports to a new system
- Support the team with ad-hoc data analysis requests related to year-end performance metrics.
Qualifications / Applicant Requirements:
- Current student pursuing a degree in Data Analytics, Business, Mathematics, Statistics, Computer Science, or a related field
- Genuine enthusiasm to work with and analyze data
- Hunger to constantly learn and self-teach
- Analytical and creative problem-solving skills
- Ability to effectively communicate with internal teams, both in writing and verbally
- Strong prioritization skills and ability to move multiple projects forward simultaneously
- Experience in Microsoft Power BI is a plus
- Experience in any SQL language a plus
- Experience with Python or other related programming language a huge plus
- Available for some hours in the office on Tuesday and/or Wednesday
Skills intern will develop:
- Gain hands-on experience with data ETL (Extraction, Transformation and Loading Techniques) learning how to clean and prepare data for analysis using Snowflake, Python and Power BI
- Develop skills in creating clear and effective data visualizations using Power BI and/or Python to help communicate insights and trends to both technical and non-technical audiences
- Learn how to perform EDA (Exploratory Data Analysis) to uncover patterns, anomalies, and inform stakeholders of trends to help them read the business clearly
- Ability to build and present a data driven story with recommendations clearly and effectively to cross-functional partners.
Additional Requirements (such as a background check that is administered by your organization, drug testing, etc.)
- Background Check