Data Analytics Engineering Intern

Perchwell • New York, NY

22h • $12,000 - $12,000 • Onsite

About The Position

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.

Requirements

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

Nice To Haves

• Coursework, projects, or prior internship experience with a cloud data warehouse such as Redshift, Snowflake, or BigQuery.
• Exposure to dbt or another transformation framework.
• An understanding of Python for working with data, such as pandas in coursework or personal projects.
• Familiarity with Git and version controlled workflows.
• Experience with a BI tool such as Looker, Tableau, Mode, or Metabase.
• Any project, academic or personal, where you took messy source data and made it usable.
• Demonstrated leadership skills developed during your college experience.

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Intern