Senior Data Analyst
About The Position
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. 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.
Requirements
- 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.
Nice To Haves
- 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.
Responsibilities
- 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.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
51-100 employees
