Back to jobs

Undergraduate Summer Scholar, Data Analyst - Summer 2027

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Not stated
Employment
Temporary — employment source
Employment type in the employer’s posting: TEMP
From the employer’s posting

What you’ll work on

Full posting

We are seeking a highly motivated and detail-oriented intern to join our team.

  • Write SQL in Snowflake to extract, join and analyze client, class, membership and sales data

  • Perform data validation and cleanup across booking, POS, e-commerce and marketing systems

  • Develop Python scripts to automate recurring data extraction and reporting

  • Own a summer special project on Marketing or Operations and present results to leadership

  • Validate Tableau reports and dashboards against source data

From the employer’s posting
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.
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)
Develop and implement Python scripts to automate recurring data extraction and reporting
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)
Validate Tableau reports and dashboards against source data so stakeholders can trust the numbers

What you’ll bring

All qualifications

Core experience

  • 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
Qualification wording
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
Apply at Barry's

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 20262 days ago
Recorded sightings
4
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

Barry's is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • dbt
  • Snowflake
  • Tableau
  • pandas
Where the posting names them
- 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
- 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
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)
- 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)
- 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)
- 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
- 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
- Exposure to Snowflake or another cloud data warehouse - Familiarity with dbt and Git - Experience with Tableau or another BI tool
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
- Able to explain findings clearly to non-technical audiences - Exposure to Snowflake or another cloud data warehouse - Familiarity with dbt and Git
- 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
- 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

Your next step

Complete your application on ats.rippling.com. The employer’s form will show what is required.

Applying through Rippling

  • “The résumé will be parsed to fill in the application details”: check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

We appreciate your interest in employment with Barry’s! Barry’s is committed to a policy of equal employment opportunity, and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin, ancestry, sex, gender, age, physical or mental disability, veteran or military status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other legally recognized protected basis under federal, state, or local law. Applicants with disabilities who need assistance with the application process may be entitled to a reasonable accommodation in accordance with applicable law.  If you need assistance in completing this application or with the application process because of a disability, please contact the People and Culture Department (people@barrys.com).


Barry’s is the Best Workout in the WorldTM®. Founded in West Hollywood in 1998, it’s the original strength and cardio interval fitness experience that provides an immersive, high-intensity, one-hour workout that’s as effective as it is fun. Our fitness classes alternate between working out with weights and running on a treadmill. Each day focuses on a different muscle group in order to achieve real results and to prevent injuries. Our program is designed to tone muscle and maximize fat loss, while spiking the metabolism for up to 48 hours following the class.


Please be aware that smoking is prohibited in all indoor areas of Barry’s studios and corporate offices.


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

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

New York, NY

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.