Skip to content
New Grad

Jobs · Board

Back to jobs
Barry's logo

Undergraduate Summer Scholar, Data Analyst - Summer 2027

Barry'sAdded 6h ago

New York, New York, United StatesInternship

Save this job and browse the whole board.

Create free account

No credit card needed

Quick summaryby newgrad.ai

What you'll do

  • Use SQL and Python to extract, clean, and analyze business data.
  • Maintain data quality by testing models and validating Tableau dashboards.
  • Lead a summer project on Marketing or Operations for senior leadership.
  • Utilize AI tools to improve coding efficiency and documentation.

What they're looking for

  • Undergraduates graduating between December 2027 and June 2028.
  • Proficiency in SQL, Python, and cloud data warehouses like Snowflake.
  • Experience with dbt, Git, and BI tools such as Tableau.
  • Ability to communicate complex data findings to non-technical stakeholders.

About the role

We are seeking a highly motivated and detail-oriented intern to join our team. This role will dive into our Snowflake data warehouse, extract and analyze client data, and perform thorough data validation and cleanup. You will also own a summer special project focused on Marketing or Operations and present your findings to senior leadership. This role is ideal for someone passionate about data and analytics and looking to gain hands-on experience with a modern data stack.

What you'll do

  • Write SQL in Snowflake to extract, join and analyze client, class, membership and sales data
  • Perform data validation and cleanup to ensure accuracy and consistency across source systems (booking, POS, e-commerce and marketing)
  • Identify and resolve data inconsistencies and quality issues with the team, tracing problems back to their source
  • Help add data quality tests and documentation to our dbt models
  • Develop and implement Python scripts to automate recurring data extraction and reporting
  • Validate Tableau reports and dashboards against source data so stakeholders can trust the numbers
  • Create clear documentation for data definitions, processes and recurring workflows
  • Help build out our data context layer (metric definitions, semantic models and dbt documentation) that powers AI-assisted analytics at Barry’s
  • Use AI tools to speed up SQL development, analysis and documentation, and help test new AI use cases for the team
  • Own a summer special project focused on either Marketing (e.g., campaign performance, first-timer conversion, client acquisition and retention) or Operations (e.g., class attendance and utilization, studio and instructor performance, membership trends)
  • Define the project’s business question with stakeholders, build the dataset, analyze the results and turn findings into clear recommendations
  • Present your findings to our leadership team and senior executives at the end of the program

Qualifications

  • Undergraduate student graduating between December 2027 and June 2028 in Computer Science, Data Science, Statistics, Economics, Business Analytics or a related field
  • Working SQL skills (joins, aggregations; window functions a plus) from coursework, projects or prior internships
  • Comfortable using Python for data work (e.g., pandas)
  • Strong attention to detail: you notice when numbers don’t tie
  • Able to explain findings clearly to non-technical audiences
  • Exposure to Snowflake or another cloud data warehouse
  • Familiarity with dbt and Git
  • Experience with Tableau or another BI tool
  • Experience using AI tools (e.g., LLM assistants or coding copilots) for analysis or coding
  • Interest in fitness, consumer or subscription businesses

From Barry's's public posting, laid out for reading by newgrad.ai with the wording unchanged. Check the original before you apply.

Listing wrong or expired, or you're the employer and want it removed? Let us know.