Data Analytics Engineering Intern

We need to output HTML fragment with sections: About the role? Actually we have "Who We Are", "About This Role", "What We’re Looking For", "What You’ll Do", "Why This Internship?", "Required For The Role", "Bonus Points for the Following", "Internship Information", "Salary Information", "Benefits". Need to follow rules: use

for section headings (e.g., About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Use

• for any list of duties/requirements/benefits, and

  for prose. Do NOT repeat the job title as a heading (the page already shows it) and do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short

  or drop it. Preserve ALL substantive information; do NOT invent or summarize away detail. Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. IMPORTANT: include a section ONLY when the posting has real, specific content for it — never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD") and never create Pay/Schedule/Benefits sections unless the posting actually states them. Prefer a few substantive sections over many thin ones. Output ONLY the HTML fragment — no /, no markdown code fences. We need to decide which sections to include based on content. The posting includes: - Who We Are (company description) - About This Role (role description) - What We’re Looking For (qualifications/requirements) - What You’ll Do (responsibilities) - Why This Internship? (benefits/perks) - Required For The Role (requirements) - Bonus Points for the Following (nice-to-have) - Internship Information (dates, deadline, offers) - Salary Information (pay) - Benefits (full-time benefits note) - Note about authorization to work in US (maybe minor metadata) We need to map to allowed headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can combine some. We must not repeat job title. We need to include sections only if there is real specific content. We have: - About the role: we have "Who We Are" and "About This Role". Could combine into About the role section. - Responsibilities: "What You’ll Do" (list of duties). Also maybe "Own a Project" etc. - Requirements/Qualifications/Skills: "What We’re Looking For" (qualities), "Required For The Role" (technical requirements), "Bonus Points for the Following" (nice-to-have). Could combine into Requirements or Qualifications and Skills. - Benefits: "Why This Internship?" includes perks (dedicated mentor, real ownership, fully in-person experience, showcase work, work on real data, NYC perks). Also "Benefits" note about full-time benefits (but note says for reference only for those who later join full-time). Should we include Benefits section? The posting does state benefits (though note says for reference only). It's still substantive content about benefits (flexible PTO, holidays, 401K, medical, etc). So we can include Benefits section. - Pay: Salary Information: $12,000 for 10 weeks. So we can include Pay section. - Schedule: Internship Information includes dates (June 7 - August 13, 2027), full-time in-office, five days a week. So we can include Schedule section. We must not include placeholder text. All content is specific. We need to use

  for each section heading. Inside sections, use

  for prose,

  • for lists. We must not include duplicated lines, boilerplate, application instructions (like "Apply now", "Note: At this time, we are only considering candidates who are authorized to work in the U.S." maybe minor metadata; we can fold into a short

    or drop it. The instruction says: do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short

    or drop it. The authorization note is minor metadata; we can include as a short

    maybe under Schedule or at end. We must remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The "Apply now and build something meaningful with us in Summer 2027!" is application instruction; we should remove. Also "Excited to launch your career with a tech startup in NYC? Apply now and build something meaningful with us in Summer 2027!" remove. Also "Internship Information" includes dates, deadline, offers; we need to keep substantive info: Internship Dates, Application Deadline, Offers timeline. Those are specifics. We'll keep them. We need to preserve ALL substantive information; do not invent or summarize away detail. Thus we need to extract details exactly. Let's parse the posting and extract each piece. **Who We Are**: "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. As consumer expectations and technology evolve, Perchwell remains focused on our core vision: empowering real estate professionals with the most intelligent, data-driven, and connected platform in the industry. Backed by leading venture capital firms including Lux Capital and Founders Fund, along with strategic partnerships with some of the country's top Multiple Listing Services (MLSs), Perchwell represents the first major new platform to enter the listings technology market in decades. This unique combination of institutional investment and deep industry alignment provides both the resources and market validation needed to transform the multi-trillion dollar residential real estate industry." **About This Role**: "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." **What We’re Looking For**: "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." **What You’ll 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." **Why This Internship?**: "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. Work on Real Data: Beyond your project, you'll contribute to models, tests, and dashboards running in production against live customer data. NYC Perks and Fun: From team dinners to museum trips, immerse yourself in the greatest city in the world while working with an awesome team." **Required For The Role**: "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." **Bonus Points for the Following**: "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." **Internship Information**: "Internship Dates: June 7 - August 13, 2027 Application Deadline: 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." We need to remove application instructions like "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." That's application instruction; we should remove that sentence. Keep the deadline date and offers date. **Salary Information**: "$12,000 for 10 weeks (minus applicable taxes and withholdings)" **Benefits**: "Note: Benefits package listed below is for reference only for those who later join Perchwell full-time. Strong Benefits Package 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" We should keep the benefits list. The note about reference only is minor metadata; we can include as short

    or drop. Probably include as a short

    before list. **Authorization note**: "Note: At this time, we are only considering candidates who are authorized to work in the U.S." That's minor metadata; we can include as short

    maybe at end. Now we need to decide sections. We have: - About the role: combine Who We Are + About This Role. - Responsibilities: What You’ll Do (list). - Requirements: Could combine What We’re Looking For (qualities) + Required For The Role (technical) + Bonus Points (nice-to-have). But we need