Tech Stack
PythonAirflowETLSQL
Job Description, Responsibilities & Requirements
About the Position
Senior Data Engineer / Architect
Join Lemon.io as a Senior Data Engineer / Architect for remote contract roles with top product companies, specializing in modern data stacks and AI-aware pipelines.
Responsibilities
As a Senior Data Engineer / Architect, you will:
- Advise on optimal architecture and tech choices for full data pipeline revamps.
- Build or oversee chosen solutions for data extraction from standard APIs and non-API application sources.
- Tackle data extraction requiring browser automation/scraping.
- Build scalable ETL processes and evaluate Airflow vs. Databricks.
- Document the architecture and run knowledge-transfer sessions to upskill the internal team.
Requirements
- 3+ years of commercial Data Engineering experience.
- Strong fluency in Python and SQL.
- Production experience with at least one orchestrator (Airflow, Dagster, Prefect).
- Production experience with at least one warehouse (Snowflake, BigQuery, Redshift, Databricks).
- Fluency in modern transformation tooling (dbt strongly preferred).
- Experience with at least one cloud platform (AWS, GCP, Azure).
- Data ingestion / ELT tooling (Fivetran, Airbyte, custom Python ingestors).
- Strong schema design and data modeling judgment (dimensional, normalized, denormalized trade-offs).
- Experience with at least one streaming or message system (Kafka, Pub/Sub, SQS) is a strong plus.
- AI-aware data work (vector databases, LLM-driven preprocessing) is an emerging premium.
- Comfortable working async with US/EU teams.
- English: Upper-Intermediate or higher.
- Available for 20+ hours/week - part-time and full-time both supported.
We Offer
- Competitive hourly rate: $20-$50/hour.
- Long-term projects (average 9+ months).
- No bidding wars.
- Free to join - No fees ever.
- Pre-vetted companies.
- Continuous access to a pipeline of pre-vetted projects.
About the Company
Lemon.io is a developer talent marketplace connecting Data Engineers with funded product companies and SMBs for remote contract roles. Developers pass vetting once (5 days average) and get continuous access to a pipeline of pre-vetted projects. Lemon.io rejects 60% of applying companies based on funding stability, product clarity, technical specs, and engineering culture.