Data Analytics Engineering Intern, Perchwell

• Rising seniors enrolled in a CS, data science, statistics, or other STEM degree program who are looking to intern at a fast paced SaaS company this summer
• Passionate problem solvers who thrive in fast moving environments
• Strong communicators and team players who can work cross functionally
• Careful thinkers who chase down a number that looks wrong instead of passing it along
• Eager learners who want to gain real world analytics engineering experience
• Working familiarity with RDBMS storage systems and SQL, including joins, aggregations, and CTEs. You don't need window functions yet, but you should want to learn them
• Curiosity about where data comes from and what it represents, not just how to query it
• Attention to detail and an instinct for when something doesn't add up
• Strong communication and problem solving abilities
• Excitement to learn, grow, and build

Desirable

• 10 week internship in NYC
• Perchwell is expanding rapidly across the US, and every new MLS client brings a data source we haven't worked with before. Our Data Analytics Engineering team owns what happens next: understanding what is actually in that data, transforming it into our warehouse, and building the intelligence layer that sits on top of it
• This summer, you'll work on that alongside our analytics engineers and data engineers, supporting both the MLS customers we serve today and the ones we're onboarding next
• Understand New Data: Profile the data we are ingesting for new clients and partner with members of the broader engineering org to identify the most effective patterns for onboarding them into our standard reporting product
• Build and Ship: Extend the dbt models that transform raw MLS data into our warehouse, adding the tests and documentation the rest of the team depends on
• Build Intelligence: Strengthen the layer that sits on top of the warehouse, including metric definitions, semantic models, and the dashboards internal teams and customers rely on
• Own a Project: Take ownership of a summer project, making key modeling, tooling, and implementation decisions. Profiling and mapping a new non MLS data source is one strong candidate
• Collaborate and Learn: Partner with analytics engineers, data engineers, product managers, and customer facing teams to turn open questions into answers people can act on
• Deliver Impact: Work on scalable solutions from broadly defined problems and see your work in production
• Dedicated Mentor: You'll work 1:1 with an experienced analytics engineer who will provide mentorship and support your growth
• Real Ownership: Over 10 weeks, early June to mid August, you will choose and lead your own project, making key decisions along the way
• Showcase Your Work: At the end of the summer, present your project to our executive and data teams
• Work on Real Data: Beyond your project, you'll contribute to models, tests, and dashboards running in production against live customer data
• Internship Dates: June 7 - August 13, 2027

• Applications for this internship close on October 18, 2026, at 11 PM ET. Be sure to apply by the deadline to be considered! We will be reviewing all applications, so please take the time to submit a thoughtful application
• Offers: Internship offers will be extended by November 25, 2026