Senior Data Analyst

Posted 2 Hours Ago
New York, NY
In-Office
140K-170K Annually
Senior level
Mobile • Real Estate • Software • Database • Analytics
Perchwell is the modern data and workflow platform for residential real estate.
The Role
Lead data integration strategies, ensure data quality, develop BI improvements, and manage junior analysts to meet customer analytics needs.
Summary Generated by Built In

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.

What we're looking for

Perchwell is rapidly expanding across the US to new MLS clients with both unique data sources that must be integrated into our data layer and sophisticated analytics requirements. Robust data management and analytics capabilities are therefore key to our future success. We are looking for a senior data analyst to propel our data integration strategies forward, establish and maintain data quality KPIs at scale, and lead a team of junior analysts to meet our customers’ needs.

What you’ll do

  • Deliver MLS implementations and onboard customer data into our data layer, partnering cross-functionally to ensure smooth launches.

  • Build validation frameworks to ensure customer data is complete, accurate, and consistent.

  • Improve our BI layer by strengthening semantic models, metric definitions, and query performance to power trusted dashboards and reporting.

  • Partner with Analytics Engineering to refine, document, and test dbt models, supporting QA and transformation validation.

  • Investigate ingestion anomalies and proactively surface data quality issues before they affect downstream reporting.

  • Work with internal and customer-facing teams to translate reporting needs into scalable data models and actionable visibility.

  • Standardize dashboards and reporting patterns, balancing customer-specific requests with reusable solutions.

  • Support planning and scaling of the Data Analytics team.

Required for the role

  • 6+ years of experience in a data analyst or analytics engineering role, preferably working with third-party data sources or customer integrations.

  • Advanced SQL expertise, including complex joins, window functions, and efficient use of CTEs and nested subqueries to create readable, performant, and reusable query logic.

  • Intermediate Python skills for data validation, automation, or light scripting (e.g., pandas, data profiling).

  • Strong attention to detail and a passion for data quality, integrity, and repeatable processes.

  • Experience working in a modern data warehouse (e.g., Redshift, Snowflake, BigQuery) and tools like dbt.

  • Ability to work cross-functionally to translate ambiguous requirements into structured workflows.

  • Strong communication skills, including the ability to explain data issues to non-technical stakeholders.

Preferred Qualifications

  • Experience mapping external schemas into internal data models during customer onboarding.

  • Familiarity with version-controlled analytics workflows (Git), JIRA/ticketing systems, and collaborative documentation tools.

  • Exposure to data observability tools (e.g., Monte Carlo, Great Expectations, or custom logging frameworks).

  • Understanding of dimensional modeling and data warehouse best practices.

  • Apply best practices in data modeling and semantic layer design to support scalable reporting and self-service analytics.

Salary Information

To provide greater transparency to candidates, we share base salary ranges for all US-based job postings regardless of state. Our ranges are based on function and level benchmarked against similar stage growth companies. Final offer amounts are determined by multiple factors including skills, job-related knowledge and depth of work experience.

The base compensation range for this position is expected to be between $140,000-$170,000/year + equity + benefits.

Why Join Us

  • Join a collaborative, data-driven team focused on data quality, analytics excellence, and impactful product development across a $50B+ industry

  • Work from our beautiful office in Soho, Manhattan with a stocked kitchen, catered breakfast and lunch once per week, happy hours and meet-ups

  • Competitive salary and equity

  • Full health benefits, 401(k), flexible PTO, commuter benefits, and more

Top Skills

BigQuery
Dbt
Python
Redshift
Snowflake
SQL

What the Team is Saying

Alex
Hollie
Davis
Adrian
Devki
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York City, NY
58 Employees
Year Founded: 2015

What We Do

Built on a state-of-the-art data engine, Perchwell empowers real estate professionals to do their best work, provide differentiated service to their clients, and close more deals.

Backed by Lux Capital, Founders Fund and some of the country’s leading MLSs, Perchwell is scaling its best-in-class solution to become the nation’s most powerful real estate platform for agents, brokerages and MLSs.

Mission: At Perchwell, our goal is to empower real estate professionals to provide best in class service to their clients. Our platform combines the best of clean data and intelligent software into a single platform. Perchwell helps innovative real estate professionals get work done.

Why Work With Us

Perchwellians are eager learners, conscientious collaborators, and supportive teammates who are obsessed with keeping our customers at the heart of everything we do.

If you’re curious, low-ego, outcome oriented, and operate with a bias to action, we’re very interested in working with you.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Perchwell Offices

OnSite Workspace

Typical time on-site: None
HQNew York, NY

Similar Jobs

Perchwell Logo Perchwell

Engineering Manager

Mobile • Real Estate • Software • Database • Analytics
In-Office
New York, NY, USA
58 Employees
175K-235K Annually

Perchwell Logo Perchwell

Senior Software Engineer

Mobile • Real Estate • Software • Database • Analytics
In-Office
New York, NY, USA
58 Employees
160K-200K Annually

Perchwell Logo Perchwell

Director of Product

Mobile • Real Estate • Software • Database • Analytics
In-Office
New York, NY, USA
58 Employees
175K-225K Annually

Perchwell Logo Perchwell

Staff Software Engineer

Mobile • Real Estate • Software • Database • Analytics
In-Office or Remote
New York, NY, USA
58 Employees
200K-245K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account