Data Analytics Engineering Intern

What you'd do

• 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.
• Fully In Person Experience: This is a full time, in-office internship based at our beautiful New York City HQ in Soho.
• You'll work on site five days a week and collaborate closely with our team, gaining hands-on experience in a fast paced, learning oriented environment.
• Showcase Your Work: At the end of the summer, present your project to our executive and data teams.

What they want

• 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.

What you get

• Flexible PTO, plus 10 paid company holidays
• 401K with a company match
• Medical, dental, and vision plans
• HSA and FSA options
• Commuter benefits
• Parental leave
• Company-wide onsite or offsite each year
• Beautiful office in Soho, Manhattan with a stocked kitchen, catered breakfast and lunch once per week, happy hours and meet-ups

About Perchwell · Internships

Perchwell is the modern real estate listings platform built for agents to search smarter, collaborate better, and close deals faster. We are building the future of residential real estateʼs critical listings infrastructure: a platform where market research and client collaboration converge. Our modern architecture enables continuous innovation at a pace legacy systems cannot match, with AI-powered features and mobile-first capabilities designed for how agents actually work.