About The Position

Barry’s is seeking a highly motivated, detail-oriented undergraduate intern to work with its data and analytics team. The role involves using Snowflake to extract and analyze client, class, membership, and sales data; validating and cleaning data across source systems; and helping improve data quality, documentation, and reporting. The intern will also support the data context layer that powers AI-assisted analytics and use AI tools to accelerate analysis, SQL development, and documentation. The intern will own a summer project focused on Marketing or Operations. Working with stakeholders, they will define a business question, build a dataset, analyze results, develop recommendations, and present findings to senior leadership at the end of the program. The position is intended for an undergraduate student seeking hands-on experience with a modern data stack.

Requirements

  • Be an undergraduate student graduating between December 2027 and June 2028 in Computer Science, Data Science, Statistics, Economics, Business Analytics, or a related field.
  • Have working SQL skills, including joins and aggregations; window functions are a plus.
  • Be comfortable using Python for data work, such as pandas.
  • Have strong attention to detail and notice when numbers do not reconcile.
  • Be able to explain findings clearly to non-technical audiences.
  • Have exposure to Snowflake or another cloud data warehouse.
  • Have familiarity with dbt and Git.
  • Have experience with Tableau or another business intelligence tool.
  • Have experience using AI tools, such as LLM assistants or coding copilots, for analysis or coding.

Nice To Haves

  • Interest in fitness, consumer, or subscription businesses.
  • Working knowledge of SQL window functions.

Responsibilities

  • Write SQL in Snowflake to extract, join, and analyze client, class, membership, and sales data.
  • Validate and clean data to improve accuracy and consistency across booking, point-of-sale, e-commerce, and marketing source systems.
  • Work with the team to identify and resolve data inconsistencies and quality issues, tracing problems to their source.
  • Help add data quality tests and documentation to dbt models.
  • Develop Python scripts to automate recurring data extraction and reporting.
  • Validate Tableau reports and dashboards against source data.
  • Document data definitions, processes, and recurring workflows.
  • Help build the data context layer, including metric definitions, semantic models, and dbt documentation, for AI-assisted analytics.
  • Use AI tools to speed up SQL development, analysis, and documentation, and help test new AI use cases for the team.
  • Own a summer project focused on Marketing or Operations, such as campaign performance, first-timer conversion, client acquisition and retention, class attendance and utilization, studio and instructor performance, or membership trends.
  • Define the project’s business question with stakeholders, build the dataset, analyze results, and develop clear recommendations.
  • Present project findings to the leadership team and senior executives at the end of the program.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service