Summer 2027 Internship - People Intelligence Intern
New York
internship
On Site
entry
H1B: no
Fanaticscollectibles Summer 2027 Internship - People Intelligence Intern at Fanaticscollectibles working with people data using SQL and Python. Responsible for data validation, documentation, and translating technical work for business partners.
Responsibilities
Fanatics Collectibles is seeking a People Intelligence Intern to join our team for Summer 2027. This role is part AI engineer, part data engineer: you will build AI-powered tools and workflows that connect the dots across workforce data and turn it into insights that inform business decisions, and help build out the People Intelligence data foundation in Snowflake that powers them.
You'll gain hands-on experience in AI-powered automation, analytics, and data engineering, working with AI tools such as Claude, ChatGPT, and Grok alongside Snowflake, Oracle HCM, SQL, and Python to build agent workflows, develop reliable data models, and support reporting and AI-driven solutions.
This role is ideal for someone who is analytically minded, already building with AI rather than just curious about it, and wants to own real work on a small team. You'll own a defined project and present it to HR leadership at the end of the summer.
Build AI-Powered Tools and Workflows: Design, test, and maintain AI agent and automation workflows on top of our people data, including recurring reporting, data validation, and stakeholder requests, with outputs that are repeatable and auditable.
Connect the Dots with AI: Use AI to join signals across people data, including retention, hiring pipeline health, organizational effectiveness, and employee experience, and turn them into analyses and insights leaders can act on.
Support Employee Lifecycle Programs: Partner with our Employee Lifecycle team to build tools, trackers, and automations for the HR calendar's tentpole events, such as performance and talent reviews, promotion cycles, compensation planning, and engagement surveys, reducing manual work and giving the HR team clearer visibility.
Build the People Data Foundation: Help extend our People Intelligence data environment in Snowflake, already underway, that powers that AI work, bringing workforce data from Oracle HCM and other people systems into governed, well-documented data models.
Develop and Maintain Pipelines: Help build new pipelines and harden existing ones that move data from source systems into Snowflake, with validation checks so what lands is complete, consistent, and trusted.
Validate and Reconcile Data: Use SQL and Python to connect, structure, and reconcile people data across systems, trace data quality issues to their root cause, and document the fixes.
Document the Work: Create and maintain clear documentation for what you build and the data behind it, including metric definitions, data dictionaries, process maps, and standard operating procedures, so the work is repeatable and the team can pick it up after the summer ends.
Translate for the Business: Turn technical work into plain language that HR business partners and leaders can use, and partner with the People team to understand the real question behind each request.
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.
Qualification
Foundational understanding of ETLCuriosity about people and data
Required
Currently pursuing bachelor's or master's degree in Computer Science, Data Science, Information Systems, Business Analytics, Statistics, Economics, Industrial/Organizational Psychology, or related field
Working knowledge of SQL and Python on real data
Foundational understanding of ETL, pipelines, and data modeling
Hands-on experience building with AI tools beyond everyday use