[Remote] Data Analyst Internship

Note: The job is a remote job and is open to candidates in USA. ConnectPrep is redefining tutoring by leveraging data and insights to connect students, parents, educators, and the community. They are offering a Data Analyst Internship that involves engaging with educators to validate and iterate analytics models, developing an understanding of algorithms and technologies, and synthesizing this knowledge into actionable tests to improve educational outcomes.ResponsibilitiesYou’ll engage with our team of educators to validate and iterate the models that drive our analyticsOur Data Analysts develop an understanding of our algorithms, the technologies and platforms that support our products, and our proprietary educational contentThis knowledge will then be synthesized into actionable tests to build modules that will assist in identifying the academic needs of each individual studentYou 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 analyticsWork with AI tools and workflows to support data-driven decision-makingPerform data mining and cleaning from multiple sources (web, internal trackers, marketing platforms)Support projects involving AI and chatbot development for ConnectPrep’s programs and websiteConduct SEO and keyword research to identify growth opportunities and track performanceAnalyze website analytics (traffic, engagement, conversions) and prepare simple dashboards or summary reportsAssist with data analysis for marketing campaigns, content performance, and business operationsHelp test, document, and iterate on new data and AI workflows as they are developedSkillsYou enjoy creative problem solving and working with messy, real-world dataYou have strong math/quantitative skills and excellent attention to detailYou are curious about how data can improve learning and student outcomesYou are studying (or have studied) Applied Mathematics, Statistics, Computer Science, Data Science, or a related fieldYou have some coding experience and a strong interest in technology and AIYou 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 PythonYou 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 macrosWork with AI tools and workflows to support data-driven decision-makingPerform data mining and cleaning from multiple sources (web, internal trackers, marketing platforms)Support projects involving AI and chatbot development for ConnectPrep's programs and websiteConduct SEO and keyword research to identify growth opportunities and track performanceAnalyze website analytics (traffic, engagement, conversions) and prepare simple dashboards or summary reportsAssist with data analysis for marketing campaigns, content performance, and business operationsHelp test, document, and iterate on new data and AI workflows as they are developedPrior internship or project experience in data analysis, business intelligence, or marketing analyticsFamiliarity 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 StudioExperience working with SEO tools or keyword platformsExperience collaborating in remote or hybrid teams (Slack, Zoom, project management boards)Company OverviewConnectPrep offers 1:1 tutoring, SAT/ACT prep, and college and graduate admissions counseling for students nationwide. It was founded in 2014, and is headquartered in Westport, Connecticut, USA, with a workforce of 11-50 employees. Its website is http://www.connectprep.com.