Data Analyst Internship

ConnectPrep is hiring a Data Analyst Intern to support educational analytics through a cross-disciplinary combination of instructional and technical work. The role involves validating analytics models, building tests and modules to identify student needs, and supporting data, AI, marketing, and operational analysis.

Responsibilities:

• You’ll engage with our team of educators to validate and iterate the models that drive our analytics
• Our Data Analysts develop an understanding of our algorithms, the technologies and platforms that support our products, and our proprietary educational content
• This knowledge will then be synthesized into actionable tests to build modules that will assist in identifying the academic needs of each individual student
• You will engage with team members that think outside of the box, with the goal of improving education through the creation of a data infrastructure and insightful analytics
• 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:

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