OVERVIEW 

As a BI Reporting & Visualization Intern at ALO, you’ll help modernize our retail reporting ecosystem by converting manual, Excel-based reporting into scalable, self-service dashboards in ThoughtSpot. You’ll work closely with Retail Analytics and business partners to translate business questions into intuitive visualizations that improve decision-making across the retail organization. 

The ALO internship program starts June 8th and ends July 31st. Interns will work 40 hours per week from our Beverly Hills HQ.  

RESPONSIBILITIES 

• Support the migration of recurring Excel reports into ThoughtSpot, improving consistency, automation, and usability for business stakeholders. 

• Build and enhance visualizations that make it easy for leaders to track business health, identify trends, and take action. 

• Partner with Retail Operations and cross-functional stakeholders to understand reporting needs, clarify requirements, and iterate on dashboard design. 

• Validate reporting outputs by reconciling ThoughtSpot results against existing Excel reports to ensure accuracy and trust in metrics. 

• Help document metric definitions, dashboard purpose, and usage guidelines to support self-service analytics. 

• Respond to ad hoc reporting requests and create quick-turn views or analyses as needed to support business priorities. 

REQUIREMENTS 

• Currently pursuing, or just graduated with a BS or MS in Analytics, Business, Data Science, Statistics, Information Systems, or a related field  

• Strong proficiency in data visualization and dashboarding (ThoughtSpot, Tableau, Power BI, Looker, or similar)  

• Solid working knowledge of Excel (including pivots / complex formulas) and comfort converting manual reporting into scalable BI solutions 

• Familiarity with SQL for querying and validating datasets  

• Detail-oriented with strong data QA instincts—able to reconcile numbers and spot discrepancies 

• Ability to communicate clearly with non-technical stakeholders and present insights through clean, intuitive visuals 

• Interest in retail/business performance reporting and KPI storytelling 

 Compensation for this position is $45-$55/hr.