Data Analyst Internship

ConnectPrep

Data Analyst Internship at ConnectPrep focused on improving education through data analysis and collaboration. Engaging with educators and working on innovative data-driven solutions.

Posted 5/31/2026internshipRemote • Massachusetts • 🇺🇸 United StatesEntry LevelWebsite

Tech Stack

Tools & technologies

NumpyPandasPythonSQLTableauVBA

About the role

Key responsibilities & impact

Engage with our team of educators to validate and iterate the models that drive our analytics.
Develop an understanding of our algorithms, the technologies and platforms that support our products, and our proprietary educational content.
Synthesize the knowledge into actionable tests to build modules that will assist in identifying the academic needs of each individual student.
Collaborate with team members that think outside the box to improve education through the creation of a data infrastructure and insightful analytics.

Requirements

What you’ll need

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)
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
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
Prior internship or project experience in data analysis, business intelligence, or marketing analytics (Nice to have)
Familiarity with web analytics and marketing tools (for example, 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)

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonPandasNumPyExcelVBAdata miningdata cleaningdata analysisSEO

Soft Skills

creative problem solvingattention to detailcuriositycollaboration