S

Serhant

Licensed New York real estate brokerage

Principal Data Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeRemote in USA$180k

About the Job

Requirements

  • At least 5 years of experience in data engineering, analytics engineering, or related roles.
  • Deep expertise in ClickHouse deployment, optimization, schema design, and materialized views.
  • Strong experience with Postgres and understanding of when to use transactional versus analytical databases.
  • Strong experience with lakehouse architecture patterns, including Delta Lake, Apache Iceberg, or Apache Hudi.
  • Proficiency building ETL/ELT pipelines with open-source tools such as Airflow, Dagster, dbt, or Prefect.
  • Hands-on experience with streaming and batch processing frameworks such as Kafka, Flink, or Spark.
  • Strong SQL skills and deep proficiency in Python.
  • TypeScript proficiency for integration with application services.
  • Demonstrated fluency with AI coding assistants such as Cursor, Copilot, or Claude as part of a daily workflow.
  • Experience using large language models for data transformation, validation, or pipeline generation.
  • Ability to document specifications before implementation, including contracts, schemas, and expected behaviors.
  • 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.
  • Candidates must currently be authorized to work in the United States without sponsorship now or in the future.
  • Candidates must live within the United States.

Responsibilities

  • 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 Postgres application databases with the ClickHouse analytics layer.
  • Partner with product and engineering to define data models serving 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.

Desired Qualifications

  • Be curious and investigate new tools and technologies, including those with limited documentation.
  • Take initiative to identify and drive work forward without detailed instructions.
  • Work productively with ambiguity and make emerging large language model tools useful without extensive guidance.
  • Work independently to identify and complete needed tasks.

About the Company

Serhant

Licensed New York real estate brokerage

Serhant LLC is a licensed New York real estate broker that handles buying, selling, renting, and development-related services. It works by helping clients navigate property transactions and related activities through its brokerage team, earning commissions on each deal when properties are bought, sold, or rented. The firm leverages its market knowledge, brand presence, and network to guide clients through a competitive New York real estate landscape and deliver transaction results. Its goal is to meet the evolving needs of buyers, sellers, developers, and renters in the New York market by providing comprehensive brokerage support and market insights.

Company size
1,001-5,000
Company stage
Seed
Total funding
$45M
Headquarters
New York City, New York
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Serhant

See more jobs