Perchwell · 7 hours ago
Senior Data Analyst
New York, NY
Full-time
Onsite
Senior Level
$140K/yr - $170K/yr
6+ years expPerchwell is a modern real estate listings platform that empowers agents with intelligent, data-driven solutions. They are seeking a Senior Data Analyst to enhance their data integration strategies, establish data quality KPIs, and lead a team of junior analysts to meet customer needs.
Data VisualizationReal EstateSoftware
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
Qualification
Required
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
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
Benefits
Equity
Benefits
Full health benefits
401(k)
Flexible PTO
Commuter benefits
Company
Perchwell
Perchwell is the premier technology platform for residential real estate
51-200 employees
H1B Sponsorship
Perchwell has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (1)
2022 (3)
Funding
Current Stage
Growth StageTotal Funding
$40MKey Investors
Lux CapitalFounders Fund
2024-07-30Series B· $25M
2021-12-08Series A· $15M
Leadership Team
Brendan Fairbanks
Founder / CEO
Recent News
2025-09-12
HousingWire.com
2025-07-11
Company data provided by crunchbase