About the role#
Perchwell is expanding across the United States, and every new MLS client introduces a data source we have not worked with before. Our Data Analytics Engineering team is responsible for understanding this data, transforming it into our warehouse, and building the intelligence layer that sits on top. As an intern, you will work alongside our analytics and data engineers to support our current and future customers.
What you'll do#
- Profile data ingested for new clients and work with the engineering team to identify patterns for onboarding.
- Extend dbt models that transform raw MLS data into our warehouse, including adding tests and documentation.
- Strengthen the intelligence layer by working on metric definitions, semantic models, and dashboards used by internal teams and customers.
- Own a summer project where you will make key modeling, tooling, and implementation decisions.
- Partner with analytics engineers, data engineers, product managers, and customer-facing teams to turn questions into actionable answers.
- Contribute to models, tests, and dashboards that run in production against live customer data.
What you'll need#
- You are a rising senior enrolled in a Computer Science, Data Science, Statistics, or related STEM degree program.
- Working familiarity with RDBMS storage systems and SQL, including joins, aggregations, and CTEs.
- Strong attention to detail and an instinct for identifying when data does not add up.
- Curiosity regarding data origins and what the information represents.
- Strong communication skills and the ability to work well within a team.
- A genuine excitement to learn, grow, and build.
Location & details#
- This is a full-time, on-site internship based at our office in New York, New York.
- The term runs for 10 weeks during Summer 2027, specifically from June 7 to August 13.
- This position is paid.
- Candidates must be authorized to work in the United States, as we do not provide sponsorship for this role.
About Perchwell
Perchwell provides a data and workflow platform for the residential real estate sector. Founded in 2015, the company operates out of New York City. It employs between 51 and 200 people. The firm builds tools for real estate agents, brokerages, and Multiple Listing Services to manage property data and deal workflows.
How to get in at Perchwell
Applying to Perchwell early gives you a distinct advantage because recruiters review applications as they arrive. Intern Insider sends an instant alert the moment a role matching your target is published, so you can submit your materials before the applicant pool grows. You gain a better chance of being seen when you are among the first to apply. Reaching out to the right person often yields better results than submitting to a general queue. Intern Insider surfaces the recruiters behind Perchwell roles so you can contact them directly to ask about the position or a referral. This approach improves your response rates and helps you stand out to the hiring team.
