Data Analyst Internship

About ConnectPrep

ConnectPrep aims to redefine tutoring by using data, insight, and extensive teaching experience to find solutions for students. The company focuses on connecting students, parents, educators, and the community, with bold ideas and an eye towards the future.

The Opportunity

ConnectPrep is offering a Data Analyst Internship. This is a cross-disciplinary role, encompassing both instructional and technical aspects. Interns will engage with the team of educators to validate and iterate on models that drive analytics. Data Analysts at ConnectPrep develop an understanding of the algorithms, supporting technologies and platforms, and proprietary educational content. This knowledge is then synthesized into actionable tests to build modules that identify the academic needs of individual students. You will engage with team members who think outside the box, aiming to improve education through the creation of a data infrastructure and insightful analytics.

Key Responsibilities

• 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.

Requirements & Tech Stack

• You enjoy creative problem-solving and working with messy, real-world data.
• You have strong math/quantitative skills and excellent attention to detail.
• You are curious about how data can improve learning and student outcomes.
• 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 (Pandas, NumPy, or similar)
• Building simple data pipelines or analysis scripts in Python
• 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

Qualifications

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