Staff Data Engineer (Python/Snowflake)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Location: New York, NY; must live within a 75-minute commute of the NYC office near Union Square and work in-office 4 days per week.
Salary: $175,000–$255,000 per year in target base compensation, with individualized pay based on location, experience, expertise, internal equity, and other business considerations. Additional compensation may include stock options and company-sponsored benefits.
Company
provides personalized virtual behavioral healthcare for people navigating mental health conditions, substance use disorders, and eating disorders.
What you will do
- Build, release, and maintain high-quality ELT and streaming pipelines focused on correctness, observability, and performance.
- Orchestrate complex workflows with Dagster, Airflow, and dbt, including monitoring and data quality assessments.
- Own areas of the Snowflake data warehouse by designing performant schemas and documenting data definitions and lineage.
- Resolve critical data issues, identify bottlenecks, and improve pipeline reliability and data availability.
- Contribute to architecture and technical design decisions, supporting analytics delivery through Hex and AI Agents.
- Mentor teammates, share technical knowledge, document systems, and participate in the on-call rotation.
Requirements
- Bachelor’s degree in Computer Science, Mathematics, or a related technical discipline, or equivalent practical experience.
- 7+ years of experience in data, including at least 4 years in data engineering.
- Advanced SQL skills, including CTEs, window functions, aggregation patterns, partitioning, clustering, and performance tuning.
- Strong Python proficiency and experience with common data engineering libraries.
- Hands-on experience with a modern data stack and the ability to own loosely defined problems through completion.
- Experience handling sensitive data in a regulated environment and availability for the required NYC office schedule.
Nice to have
- Healthcare experience.
- Airflow experience, including migrations.
- Kafka Streams experience.
- Experience using AI tools for development.
Culture & Benefits
- Comprehensive benefits for full-time, exempt employees.
- Potential stock options and other company-sponsored benefits.
- Values centered on connection, curiosity, evidence-based decisions, urgency, and perseverance.
- Opportunities to contribute to continuous improvement and technical craft.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →