SERHANT is a real-estate brokerage that also operates media and education divisions and is now developing technology products for agents and salespeople.
<h4><span data-contrast="auto">About SERHANT.</span><span data-ccp-props="{"134233118":false,"335559739":0}"> </span></h4> <p><span data-contrast="none">SERHANT. is the most followed real estate brand in the world, calibrated for the marketplace of tomorrow, delivering proven results for buyers, sellers, and developers. SERHANT. revolutionizes the traditional brokerage model by innovating through media and content creation and is powered by a full-service in-house film studio as well as an amplification platform that puts our properties in front of more people than anyone else.</span> <span data-ccp-props="{"134233118":false,"335559739":0}"> </span></p> <h4><span data-contrast="auto">About the Role</span><span data-ccp-props="{"134233118":false,"335559739":0}"> </span></h4> <p><span data-contrast="none">We’re looking for a Senior Data Engineer who builds data infrastructure with velocity and precision. You’ll design pipelines, architect lakehouse solutions, and create the foundation that powers our products—leveraging modern AI tools to move faster without sacrificing quality. You bring deep experience with ClickHouse, open-source data tooling, and modern lakehouse patterns.</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559731":1,"335559737":17,"335559738":0,"335559739":0}"> </span></p> <h4><span data-contrast="none">Our Stack</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559731":1,"335559737":17,"335559738":0,"335559739":0}"> </span></h4> <ul> <li><span data-contrast="none">Analytics Database: ClickHouse</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Primary Database: Postgres</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Languages: Python, TypeScript</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Infrastructure: Azure, event-driven architecture</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> </ul> <h4><span data-contrast="none">Responsibilities</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559731":1,"335559737":17,"335559738":0,"335559739":0}"> </span></h4> <ul> <li><span data-contrast="none">Design and implement lakehouse architecture using open-source technologies</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Build and optimize ClickHouse deployments for high-performance analytical workloads</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Develop custom data transforms and ETL/ELT pipelines using well-supported open-source tools</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Create data models that bridge our Postgres application databases with ClickHouse analytics layer</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Partner with product and engineering to define data models that serve both analytical and operational needs</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Write specifications before writing code—defining contracts, schemas, and expected behaviors upfront</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Use AI-assisted coding tools daily to accelerate development and reduce toil</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Establish data quality frameworks and observability across the pipeline</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Optimize for performance, cost, and reliability at scale</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="auto">*The company reserves the right to add or change duties at any time.</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> </ul> <h4><span data-contrast="auto">Qualifications</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559685":0,"335559737":17,"335559738":0,"335559739":0}"> </span></h4> <ul> <li><span data-contrast="none">5+ years of experience in data engineering, analytics engineering, or related roles</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Deep expertise with ClickHouse - deployment, optimization, schema design, and materialized views</span><span data-ccp-props="{"134233117":false,"134233118":false,"335559737":17,"335559738":0,"335559739":0}"> </span></li> <li><span data-contrast="none">Strong experience with Postgres and understanding of when to leverage transactional vs. analytical databases</span><span data-ccp-props="{"13423