SERHANT.
The first real estate company designed for the marketplace of tomorrow.
Senior Data Engineer
Location
United States
Posted
31 days ago
Salary
Not specified
Bachelor Degree5 yrs expEnglishAirflowApacheETLKafkaPostgresPythonSparkSQLType Script
Job Description
• 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
Job Requirements
- 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
Benefits
- Health insurance
- Professional development opportunities
- Flexible work hours
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer31 days ago
Full TimeRemoteTeam 201-500Since 2006H1B No Sponsor
GCP Data Engineer designing scalable data platforms on Google Cloud
AirflowApacheBigQueryCloudGoogle Cloud PlatformPythonSQL
United States
Data Engineer31 days ago
ContractRemoteTeam 201-500Since 1991H1B No Sponsor
Data Architect/Metadata Specialist defining governance requirements for federal agencies
ApachePostgresPythonSQL
Virginia
Data Engineer31 days ago
Remote
Senior AI Data Engineer (Agentic Systems)Location: USA / Europe / Israel - with a 5hour overlap with EST hoursCompensation: $130K - $150KWe build the technology that powers safer, more accessible financial markets. Our risk management systems,...
United States
Data Engineer31 days ago
Full TimeRemoteTeam 11-50Since 2002H1B No Sponsor
Azure Data Engineer developing data pipelines and analytics solutions
AzureCloudETLSQL
Mississippi