Senior Data Engineer — Scalable Data Pipelines & Analytics

Carrot; New York (NY); On-site; USD 145,000 - 165,000; Full time

Job summary

Carrot, a global fertility and family care platform, is hiring a Sr. Data Engineer to lead data infrastructure design across analytics and BI. You will architect and maintain automated ETL/ELT pipelines, optimize Snowflake and cloud data platforms, and ensure secure data flows with APIs and external data sources.

You will collaborate with BI, Product, Finance, Legal, and Commercial teams to deliver reliable integrations, reduce technical debt, and improve data quality and observability at scale.

Qualifications

• Expert-level proficiency in Snowflake, dbt, and Python for data modeling, transformation, pipeline development, and advanced analytics.
• Advanced SQL skills for complex querying, large-scale data model design, and database optimization.
• Proven experience architecting, building, testing, deploying, and maintaining scalable, automated ETL/ELT pipelines using orchestration tools such as Prefect and Airflow.

Responsibilities

• Architect, build, test, deploy, and maintain scalable, automated ETL/ELT pipelines using Python, dbt, and orchestration tools such as Prefect and Airflow.
• Administer and optimize cloud-based data warehouse and lake platforms, including Snowflake, AWS (S3, Redshift), and Google Cloud, integrating new sources and tuning for performance and cost.
• Orchestrate data workflows with custom scheduling, alerting, dependency management, monitoring, and error resolution.
• Design and maintain secure external data flows through SFTP, Files.com, and APIs, focusing on reliability and compliance.
• Automate manual reporting and operational tasks, building robust, reusable pipeline components that reduce overhead.
• Partner with backend engineers to optimize production database schemas with analytics use cases in mind.
• Strengthen data quality, lineage, governance, and documentation across key data domains.
• Mentor teammates and reinforce best practices in version control and structured workflow management.

Skills

Snowflake

dbt

Python

SQL

Airflow

Prefect

Data modeling

Data pipelines

Git

Tools

AWS

Redshift

Google Cloud

S3

Snowflake

dbt

Job description

Carrot, a global fertility and family care platform, is hiring a Sr. Data Engineer to lead data infrastructure design across analytics and BI. You will architect and maintain automated ETL/ELT pipelines, optimize Snowflake and cloud data platforms, and ensure secure data flows with APIs and external data sources.

You will collaborate with BI, Product, Finance, Legal, and Commercial teams to deliver reliable integrations, reduce technical debt, and improve data quality and observability at scale.