Data Architect - Lakehouse & ClickHouse (Remote)

Serhant; États-Unis; À distance; USD 180 000 - 230 000; Plein temps

Résumé du poste

SERHANT. is seeking a Principal Data Engineer to build fast, scalable data infrastructure powering our modern real estate products. You will design lakehouse architectures, optimize ClickHouse deployments, and craft data models bridging Postgres with analytics layers.

Join a team that leverages AI tools for rapid development while maintaining data quality, observability, and real-time analytics. Remote-friendly with US-wide eligibility.

Qualifications

• 5+ years of experience in data engineering, analytics engineering, or related roles.
• Deep expertise with ClickHouse - deployment, optimization, schema design, and materialized views.
• Strong experience with Postgres and understanding of when to leverage transactional vs. analytical databases.
• Strong experience with lakehouse architecture patterns (Delta Lake, Apache Iceberg, Apache Hudi).
• Proficiency building ETL/ELT pipelines with open-source tools (Airflow, Dagster, dbt, Prefect, or similar).
• Hands‑on experience with streaming and batch processing frameworks (Kafka, Flink, Spark).
• Strong SQL and deep proficiency in Python.
• TypeScript proficiency for integration with application services.
• Demonstrated fluency with AI coding assistants (Cursor, Copilot, Claude, etc.) as part of your daily workflow.
• Experience using LLMs for data transformation, validation, or pipeline generation.
• A spec‑first mindset - you document what you’re building before you build it.
• Experience with real‑time analytics and sub‑second query requirements.
• Familiarity with data contracts, schema registries, and data mesh principles.
• Contributions to open‑source data projects.
• Background working in cross‑functional product teams.

Responsabilités

• Design and implement lakehouse architecture using open-source technologies.
• Build and optimize ClickHouse deployments for high-performance analytical workloads.
• Develop custom data transforms and ETL/ELT pipelines using well-supported open-source tools.
• Create data models that bridge our Postgres application databases with ClickHouse analytics layer.
• Partner with product and engineering to define data models that serve both analytical and operational needs.
• Write specifications before writing code—defining contracts, schemas, and expected behaviors upfront.
• Use AI-assisted coding tools daily to accelerate development and reduce toil.
• Establish data quality frameworks and observability across the pipeline.
• Optimize for performance, cost, and reliability at scale.
• The company reserves the right to add or change duties at any time.

Connaissances

Python

SQL

TypeScript

AI coding assistants

Cross-functional collaboration

Outils

ClickHouse

Postgres

Delta Lake

Apache Iceberg

Apache Hudi

Airflow

Dagster

dbt

Prefect

Kafka

Flink

Spark

Description du poste

SERHANT. is seeking a Principal Data Engineer to build fast, scalable data infrastructure powering our modern real estate products. You will design lakehouse architectures, optimize ClickHouse deployments, and craft data models bridging Postgres with analytics layers.

Join a team that leverages AI tools for rapid development while maintaining data quality, observability, and real-time analytics. Remote-friendly with US-wide eligibility.