OVERVIEW

We are seeking a motivated and technically strong Computer Science Intern – Operations Data & Visibility to join our Biz Tech Operations team. This internship offers a unique opportunity to work on high-impact data and analytics initiatives that directly support our Distribution Technology organization, including distribution centers (DCs) and third-party logistics providers (3PLs). 

As an intern, you will help design and build data pipelines, analytical models, and reporting solutions that improve operational visibility across inventory, 4-wall activities, orders, shipments, and fulfillment performance. Your work will contribute to foundational capabilities accelerating ALO’s continued growth.

The ALO internship programs starts June 8th and ends July 31st. Interns will be working 40 hours a week at our Beverly Hills HQ.

RESPONSIBILITIES  

• Partner closely with Distribution Technology, Data Engineering, and Operations teams to define data-driven solutions that improve operational visibility across DCs and 3PLs
• Assist in the design and development of data pipelines and data models that integrate information from multiple enterprise systems, including: 
  • Progress databases 
  • Azure SQL databases 
  • Amazon Redshift 
  • Other 3rd party data sources 
• Support the creation of a centralized distribution data layer that enables consistent reporting and analytics across supply chain, inventory, order lifecycle, shipment status, and fulfillment performance
• Develop and maintain SQL queries, views, and transformations to support operational dashboards and KPI reporting
• Contribute to the development of ThoughtSpot dashboards and insights that allow business users to self-serve key distribution and logistics metrics
• Collaborate with Business Analysts and Business stakeholders to help define problem statements, document requirements, and translate business questions into analytical solutions
• Create and maintain technical documentation, including data flow diagrams, source-to-target mappings, and metric definitions
• Validate data accuracy and consistency across systems, assisting with reconciliation, anomaly detection, and data quality checks
• Work with internal and third-party development teams by reviewing requirements, clarifying technical questions, and providing feedback on delivered solutions
• Learn and apply best practices for data engineering, analytics engineering, and enterprise reporting in a real-world environment

Qualifications

• Currently pursuing a degree in Computer Science, Data Science, Information Systems, or a related technical field
• Strong working knowledge of SQL and relational databases
• Experience with or exposure to data modeling, ETL/ELT concepts, and analytical workflows
• Familiarity with one or more programming or scripting languages such as Python, Java, or C# is a plus
• Interest in data analytics, business intelligence, and operational reporting
• Strong problem-solving skills and the ability to work with ambiguous requirements in a fast-paced environment
• Ability to communicate technical concepts clearly to both technical and non-technical stakeholders
• A passion for learning new technologies and applying them to real-world, business-critical challenges

NICE TO HAVE

• Exposure to cloud data platforms (AWS, Azure)
• Experience with BI tools such as ThoughtSpot, Tableau, or Power BI
• Coursework or projects involving supply chain, logistics, or operations analytics

The base pay range for this position is $45/hr-$50/hr which represents the current range for the non-exempt position. Please note that actual pay will vary based on factors including but not limited to location, experience, and performance.