Data Analyst Internship

Job Description

Job Title: Data Analyst Internship

About ConnectPrep:

ConnectPrep is on a mission to redefine “tutoring” by leveraging data, insightful analysis, and extensive teaching experience to create tailored solutions for students. We aim to connect students, parents, educators, and the community through our bold ideas and forward-thinking approach to education.

About The Opportunity:

We are excited to offer a Data Analyst Internship to qualified candidates. This is a unique and cross-disciplinary role, blending both instructional and technical aspects. As an intern, you will play a crucial part in engaging with our team of educators to validate and iterate on the data models that drive our analytics.

You will gain a deep understanding of our proprietary algorithms, the technologies and platforms supporting our products, and our educational content. This knowledge will be synthesized into actionable tests to build modules designed to identify the academic needs of individual students. You will collaborate with team members who are innovative and committed to improving education by developing a robust data infrastructure and delivering insightful analytics.

What We Are Looking For:

Core Skills:

• You enjoy creative problem-solving and working with messy, real-world data.
• You possess strong math/quantitative skills and excellent attention to detail.
• You are curious about how data can improve learning and student outcomes.

Academic & Technical Background:

• You are studying (or have studied) Applied Mathematics, Statistics, Computer Science, Data Science, or a related field.
• You have some coding experience and a strong interest in technology and AI.
• You have experience with at least one of the following:
  • SQL
  • Python data tools (e.g., Pandas, NumPy)
  • Building simple data pipelines or analysis scripts in Python

Excel & Analysis Skills:

You are comfortable doing serious work in Excel, including several of the following:

• Advanced formulas and functions
• Tables and formatting
• Conditional formatting
• Advanced charting and visualizations
• Pivot tables and pivot reporting
• Using Excel productively for analysis, not just basic spreadsheets
• Data tables, simulations, and Solver
• (Bonus) VBA and macros

AI, Data, and Analytics Work You Will Support:

• Work with AI tools and workflows to support data-driven decision-making.
• Perform data mining and cleaning from multiple sources (web, internal trackers, marketing platforms).
• Support projects involving AI and chatbot development for ConnectPrep’s programs and website.
• Conduct SEO and keyword research to identify growth opportunities and track performance.
• Analyze website analytics (traffic, engagement, conversions) and prepare simple dashboards or summary reports.
• Assist with data analysis for marketing campaigns, content performance, and business operations.
• Help test, document, and iterate on new data and AI workflows as they are developed.

Nice to Have:

• Prior internship or project experience in data analysis, business intelligence, or marketing analytics.
• Familiarity with web analytics and marketing tools (e.g., Google Analytics, GA4, Search Console, Looker Studio, or similar platforms).
• Experience visualizing data in tools such as Tableau, Power BI, or Data Studio.
• Experience working with SEO tools or keyword platforms.
• Experience collaborating in remote or hybrid teams (Slack, Zoom, project management boards).

Why Join ConnectPrep?

• Get in on the ground floor of an exciting new company, with the potential to help shape our direction.
• Be involved with a team that has bold ideas, with the goal of reinventing education across the globe.
• Gain valuable experience, meet technology innovators, and learn about the business side of our company.

Sound Interesting?

Please submit your resume and letter of interest to careers@connectprep.com.

Eligibility:

All applicants must be a U.S. Citizen or National of the U.S., an alien lawfully admitted for permanent residence, or an alien authorized to work in the U.S. for this employer. ConnectPrep is an equal opportunity employer EEO/M/F/D/V.