Data Analyst Internship

ConnectPrep • Washington, DC

12h

About The Position

ConnectPrep is offering a Data Analyst Internship for qualified candidates. This cross-disciplinary role combines instructional and technical work. The intern will work with educators to validate and iterate on analytics models, develop an understanding of the algorithms, supporting technologies and platforms, and proprietary educational content, and turn that understanding into actionable tests and modules to help identify individual students’ academic needs. The role supports the development of data infrastructure and insightful analytics to improve education.

The intern will use AI tools and workflows to support data-driven decision-making; mine and clean data from sources such as websites, internal trackers, and marketing platforms; support AI and chatbot projects for ConnectPrep programs and its website; conduct SEO and keyword research; analyze website traffic, engagement, and conversions; and help with analysis of marketing campaigns, content performance, and business operations. The intern will also help test, document, and refine emerging data and AI workflows.

ConnectPrep describes this opportunity as a chance to join an early-stage company, contribute to its direction and education-focused goals, gain experience, meet technology innovators, and learn about the business side of the company. Applicants must be authorized to work in the United States under one of the specified citizenship, permanent-residence, or work-authorization categories.

Requirements

• Enjoy creative problem-solving and working with messy, real-world data.
• Have strong math or quantitative skills and excellent attention to detail.
• Be curious about how data can improve learning and student outcomes.
• Be studying or have studied Applied Mathematics, Statistics, Computer Science, Data Science, or a related field.
• Have some coding experience and a strong interest in technology and AI.
• Have experience with at least one of SQL, Python data tools such as Pandas or NumPy, or building simple data pipelines or analysis scripts in Python.
• Be comfortable doing substantial analytical work in Excel, including several of the following: advanced formulas and functions, tables and formatting, conditional formatting, advanced charting and visualizations, pivot tables and reporting, and using Excel for analysis rather than only basic spreadsheets.
• Be a U.S. citizen or national, a lawful permanent resident, or an alien authorized to work in the United States for this employer.
• Submit a resume and letter of interest to [email protected].

Nice To Haves

• Experience with Excel data tables, simulations, and Solver.
• Experience with VBA and macros.
• Prior internship or project experience in data analysis, business intelligence, or marketing analytics.
• Familiarity with web analytics and marketing tools such as Google Analytics, GA4, Search Console, or Looker Studio, or similar platforms.
• Experience visualizing data with Tableau, Power BI, Data Studio, or similar tools.
• Experience with SEO tools or keyword platforms.
• Experience collaborating in remote or hybrid teams using tools such as Slack, Zoom, or project management boards.

Responsibilities

• Work with educators to validate and iterate on analytics models.
• Learn how ConnectPrep’s algorithms, supporting technologies and platforms, and proprietary educational content work.
• Develop actionable tests and modules to help identify individual students’ academic needs.
• Contribute to data infrastructure and analytics intended to improve education.
• Use AI tools and workflows to support data-driven decision-making.
• Mine and clean data from multiple sources, including websites, internal trackers, and marketing platforms.
• Support AI and chatbot development projects for ConnectPrep’s programs and website.
• Conduct SEO and keyword research to identify growth opportunities and track performance.
• Analyze website traffic, engagement, and 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.

Benefits

• Opportunity to join an exciting new company early and potentially help shape its direction.
• Opportunity to work with a team aiming to reinvent education globally.
• Gain valuable experience, meet technology innovators, and learn about the business side of the company.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed