Summer 2027 Internship
Fanatics
Posted 15 Nov 2026, 12:31 ET · Verified open on LinkedIn 15 Nov, 13:04 ET
This job at a glance
- Who can apply
- New grads and up to 1 year · Bachelor's degree or Master's degree
- Must know
- SnowflakePythonSQLStakeholder managementStatisticsBusiness analysis
- Work
- On-site in New York · internship
- Pay
- Not stated by the employer.
- Skill demand
- Python16%Stakeholder management14%SQL8%of 99 similar entry-level jobs posted in the US this week
- Listed
- Nov 15, 2026 · still open
Sign in free to see which of these skills your resume already shows.
Company: Fanatics
About The Role
Fanatics Collectibles is seeking a People Intelligence Intern for Summer 2027. This role involves building AI-powered tools and workflows to analyze workforce data, creating insights for business decisions, and contributing to the People Intelligence data foundation in Snowflake. The intern will gain hands-on experience in AI-powered automation, analytics, and data engineering, utilizing tools like Claude, ChatGPT, and Grok, alongside Snowflake, Oracle HCM, SQL, and Python. The ideal candidate is analytically minded, has practical experience building with AI, and is eager to own real work. The intern will own a defined project and present it to HR leadership.
What You'll Do
- Build AI-Powered Tools and Workflows: Design, test, and maintain AI agent and automation workflows on people data, including recurring reporting, data validation, and stakeholder requests.
- Connect the Dots with AI: Use AI to analyze signals across people data (retention, hiring pipeline, organizational effectiveness, employee experience) to generate actionable insights.
- Support Employee Lifecycle Programs: Partner with the Employee Lifecycle team to build tools, trackers, and automations for HR calendar events like performance reviews, talent reviews, compensation planning, and engagement surveys.
- Build the People Data Foundation: Extend the People Intelligence data environment in Snowflake, integrating workforce data from Oracle HCM and other people systems into governed data models.
- Develop and Maintain Pipelines: Build new pipelines and enhance existing ones to move data from source systems into Snowflake, including validation checks.
- Validate and Reconcile Data: Use SQL and Python to connect, structure, and reconcile people data across systems, identify data quality issues, and document fixes.
- Document the Work: Create and maintain clear documentation for built components and data, including metric definitions, data dictionaries, process maps, and standard operating procedures.
- Translate for the Business: Convert technical work into clear language for HR business partners and leaders, and understand the underlying business questions behind requests.
Qualifications
- Currently pursuing a bachelor's or master's degree in Computer Science, Data Science, Information Systems, Business Analytics, Statistics, Economics, Industrial/Organizational Psychology, or a related field.
- Working knowledge of SQL and Python used on real data (coursework and personal projects count).
- Foundational understanding of ETL, pipelines, and data modeling.
- Hands-on experience building with AI tools such as Claude, ChatGPT, Grok, or similar, beyond everyday use (experience with AI agents or agentic workflows is a strong plus).
- Demonstrated ability to build something others have used (e.g., a script, app, dashboard, automation).
- Strong analytical and problem-solving skills, with attention to detail and a habit of validating work.
- Comfort handling confidential people data with discretion and good judgment.
- Interest in people and organizational dynamics, paired with the initiative to learn new tools quickly and collaborate across teams.
Tech Stack/Tools
- AI Tools: Claude, ChatGPT, Grok, or similar
- Data Platforms: Snowflake, Oracle HCM
- Programming Languages: SQL, Python