Data AI Co-op, Internship

BrainPOP; New York (NY); On-site; USD 43,200 - 52,800; Full time

Job summary

BrainPOP's Data team seeks a co-op/intern focused on empowering analytics with AI. You’ll work across analytics, experimentation, reporting, and data modeling within analytics-engineering, emphasizing CortexAI and semantic layers.

The role spans Snowflake, dbt, Airflow, Python and Streamlit to drive real-time insights. You’ll learn to transform Snowflake data, build dashboards, and craft prompts for AI models, aligning with marketing, product, finance and GTM stakeholders in a hybrid NYC

Qualifications

• Pursuing a Bachelor’s degree (senior preferred) or a Master’s degree in Computer Science, Computer Engineering, Data Science; recent graduates may be considered.
• Background in analytics, data, data engineering or a tech-adjacent role; full stack capability across analytics, data modeling, AI and analytics engineering.
• Team player; able to work independently and with cross-functional teams.
• SQL, including CTEs & window functions; Snowflake experience is a plus.
• Python for data transformation and automation.
• AI-assisted development; experience with LLM coding assistants or similar tooling.
• Prompt engineering experience; ability to craft structured prompts and outputs.
• Experience building dashboards or data visualizations with tools like Tableau.

Responsibilities

• Enhance analytics, experimentation and BI capability for business.
• Produce ad-hoc analysis from Snowflake and in-house telemetry systems for multiple teams.
• Model data for dashboards; translate Tableau workflows to Streamlit apps for experimentation.
• Monitor KPIs; identify opportunities and provide recommendations to improve performance.
• Support building AI workflows within CortexAI semantic layer; design repeatable data models.
• Transform raw Snowflake data into reusable data models pipelined into dbt and semantic layer.
• Model, document and QA CortexAI models to support semantic view and NL query capability.
• Write and iterate on prompt and skill structures; evaluate outputs for analyst-quality results.

Skills

SQL

Python

Tableau

Snowflake

dbt

Airflow

Streamlit

CortexAI

Prompt engineering

Education

Bachelor’s degree or Master’s degree

Tools

Git

NotionAI

Job description

For over two decades, BrainPOP has been trusted by educators and parents worldwide as a source of engaging and impactful learning experiences for all kids. With a presence in over two-thirds of U.S. districts through school and district subscriptions and an estimated annual reach of 25 million students, BrainPOP is empowering kids to take agency over their learning and excel in and out of the classroom.

The company was acquired in 2022 by KIRKBI, the family‑owned holding and investment company of the LEGO brand, marking a significant milestone as their first acquisition in the digital learning realm. We are thrilled to continue making learning fun and accessible with the strategic guidance and support of KIRKBI.

About the Role

BrainPOP’s Data team works across enterprise analytics initiatives to empower the business every day with the latest and greatest data assets. We partner with Finance, GTM, Product and all other parts of business to understand their challenges and provide them with actionable data‑driven insights. We pair traditional analytics, designed experimentation and dashboard reporting with AI‑driven approaches, like creating semantic models to help business self‑serve with real‑time insights, Cortex AI‑based data science models to predict churn, and python applications to drive movie content analytics.

In this co‑op/internship, you’ll learn about empowering analytics with AI - a full stack experience that will span across analytics, experimentation, reporting, data modeling within analytics‑engineering along with strong focus on AI based capabilities.

We are looking for someone who has the curiosity to use the latest and greatest technologies plus AI as an impact‑accelerator across the enterprise. This role is a great fit for someone who thrives in a dynamic and agile environment and can move with an experimental mindset to work with the Data team & business stakeholders in Marketing, Product, Finance and GTM.

You will get exposure to the systems, tools and AI pipelines we use to optimize our business along with the opportunity to work with real world business problems. Our data stack consists of modern data tools like Snowflake, dbt, Airflow, AWS along with Streamlit, python that we use for experimentations, AI platforms like CortexAI, NotionAI, Tableau on the BI side, Salesforce as our CRM.

Details

The opportunity will be from September (7 or 14) through December 18, 2026, Monday to Friday from 9:00 am to 5:30 pm Eastern (40 hours weekly, 8 hours daily with 30 minutes lunch).

We are a hybrid workplace, and a candidate within commutable distance of our NYC office (Flatiron area) who is available to spend Wednesdays in the office is strongly preferred.

The pay rate is $25/hour. Please note: BrainPOP does not offer relocation, housing or travel assistance.

In This Role, You Will

Enhance analytics, experimentation and BI capability for business

• Produce ad‑hoc analysis from Snowflake (our Data Warehouse) or other in‑house telemetry systems as required for Marketing, Product, Finance and GTM with focus on
  • Data modeling & validation as required for Tableau dashboards, along with deployment of dashboards as needed
  • Translating Tableau workflows into Streamlit apps as required for experimentation
  • Analysis of teacher segmentation & usage patterns within our products
• Monitor key performance indicators (KPIs) related to user engagement, product usage, and revenue metrics. Identify areas for improvement and optimization and provide recommendations to enhance performance & identify trends, patterns and opportunities
• Ensure data accuracy, consistency, and completeness across all systems

Support building AI workflows within the CortexAI semantic layer

• Design data models and analytic frameworks for repeatable workflows - product usage analytics, account churn, book of business renewals, customer feedback - and turn them into a reusable, invokable tool using Snowflake and dbt, modeled in the semantic layer for quick business insights through CortexAI
• Transform raw Snowflake data into reusable data models that can be pipelined into dbt & the semantic layer
• Help in modeling, documentation & QA for CortexAI models to support semantic view for natural language query capability
• Write and iterate on prompt & skill structures (YAML + Markdown skill files) based on output quality and stakeholder feedback
• Evaluate model outputs rigorously and enable business to produce analyst‑quality output using semantic layer capability

On Your Resume

Must haves

• Pursuing a Bachelor’s degree (senior preferred) or a Master’s degree in Computer Science, Computer Engineering, Data Science; recent Bachelor’s/Masters graduates may be considered
• Background in analytics, data, data engineering or a tech adjacent role. We are looking for a full stack person who can span the worlds of analytics, data modeling, AI and analytics engineering.
• Team player; able to work independently, as well as collaboratively within the Data team and cross functionally
• SQL, including CTEs & window functions (Snowflake experience a plus)
• Python — comfortable writing Python for data transformation and automation
• AI‑assisted development — You have used an LLM coding assistant like Claude or equivalent to structure prompts clearly
• Some experience in prompt engineering — You can write a structured prompt (YAML + Markdown or equivalent) that helps others think through context, instructions, examples, and output format
• Some experience building dashboards or data visualizations that tell a clear business story with tools like Tableau

Strong Plus

• dbt — Model authoring & YAML tests in a cloud warehouse context
• Snowflake Cortex — Cortex Analyst, Cortex Agents, Dynamic Tables, semantic views or ability to learn quickly
• Comfortable working in Git (PRs, branches, code review)
• Understands stakeholder needs and can translate between the worlds of AI, data, and business to enable strategic insights
• Understands subscription based business models
• Basic understanding of statistics/experimental design

Location:

The BrainPOP team operates in a hybrid work environment: Each role has remote flexibility and an in‑person component at our New York headquarters or other meeting locations. Based on the requirements of a specific role, we may prioritize hiring within a commutable distance of our New York headquarters or in another region relevant to that role.

We can employ individuals residing in the following approved hiring states:

• Arizona
• California
• Connecticut
• Florida
• Georgia
• Illinois
• Massachusetts
• Minnesota
• Missouri
• New Jersey
• New York
• North Carolina
• Ohio
• Oregon
• Pennsylvania
• South Carolina
• Tennessee
• Texas
• Washington

USA Pay Scale

Pay range $25 — $25 USD

We take a geo‑neutral approach to compensation within the US, meaning that we pay based on job function and level, not location. We have competitive pay bands for all other countries based on market standards. Individual compensation decisions are based on a number of factors, including experience level, skill set, and balancing internal equity relative to peers at the company. Based on these factors, we expect most of the candidates offered roles at our company to fall healthily throughout the range. We recognize that the person we hire may be less experienced (or more senior) than this job description, as posted. If so, the updated salary range will be communicated to you as a candidate.

Life at BrainPOP

At BrainPOP, our work directly impacts how teachers teach and students learn. They inspire us to build solutions that facilitate joy and meaningful learning outcomes. Our commitment to educators and kids is reflected in our dedication to the BrainPOP team: ensuring their experience is empowering, creative, collaborative, playful, and anchored in learning and growth.

Our team is made up of educators, data scientists, published authors, engineers, artists, bakers, film buffs, cyclists, dual citizens, and so much more. We value diversity and inclusion, collaboration, and learning from multiple perspectives.

We believe that a diverse organization is a more effective organization. BrainPOP is an Equal Opportunity/Affirmative Action Employer.

NOTICE: We have become aware of various fraudulent websites and third parties impersonating our company and offering false job opportunities. These offers are not affiliated with BrainPOP and are considered part of an unlawful recruitment scam. To ensure your safety and protect your personal information we strongly recommend that you only apply for positions through the official BrainPOP website or BrainPOP's official LinkedIn page. If you receive any job offers or communications that do not originate from this page or our official e‑mail domain brainpop.com, please treat them as suspicious and do not engage or provide any personal information. For any questions or to report suspicious activity, please contact us directly at [e-mail]. While we have reported this general fraud to the authorities, you can report this fraud on your own behalf to the Federal Trade Commission (https://reportfraud.ftc.gov/) and the Federal Bureau of Investigation’s Internet Crime Complaint Center (https://www.ic3.gov/).