Data Analyst Internship

ConnectPrep, LLC; Washington (District of Columbia); On-site; USD 28,000 - 41,000; Part time

Benefits offered by this job

Ground-floor opportunity

Bold ideas team

Valuable experience

Job summary

ConnectPrep in Washington, DC, is offering a Data Analyst Internship that blends instructional and technical work. You will work with educators to validate models that drive analytics and help identify student needs through data.

Ideal candidates study math, statistics, CS or data science, have some coding experience (SQL, Python, Pandas) and strong Excel skills. This internship provides hands-on experience with data infrastructure and analytics in education.

Qualifications

• 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 SQL, Python data tools (Pandas, NumPy, or similar).
• You have experience building simple data pipelines or analysis scripts in Python.
• You are comfortable doing serious work in Excel with advanced formulas, tables, pivot tables, and data visualizations.

Responsibilities

• Validate and iterate models that drive our analytics.
• Develop understanding of the algorithms and platforms supporting our products.
• Synthesize knowledge into actionable tests to identify student needs.
• Assist with data analysis for marketing campaigns, content performance, and business operations.

Skills

Creative problem solving

Quantitative skills

Attention to detail

Curiosity about data

Education

Applied Mathematics

Statistics

Computer Science

Data Science

Tools

SQL

Python

Pandas

NumPy

Job description

About ConnectPrep

Our goal is to redefine "tutoring" - to use data, insight, and our extensive teaching experience find solutions for our students. ConnectPrep is about connecting - connecting students, parents, educators, and the community. We have bold ideas and an eye towards the future.

The Opportunity

We are offering a Data Analyst Internship for qualified candidates. This is a cross-disciplinary role, both instructional and technical. 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.

Requirements

• Core skills
• 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.
• 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 (Pandas, NumPy, or similar)
  • 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 (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)

Benefits

• 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

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.