Sr. Data Engineer

Carrot is a global fertility and family care platform providing clinical guidance and support to members worldwide. Carrot is seeking a Senior Data Engineer to evolve, operate, and scale its data infrastructure by building automated pipelines, integrating data sources, optimizing cloud platforms, and enabling secure, reliable analytics and reporting.

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, with a focus on reliability and compliance
• Automate manual reporting and operational tasks, building robust, reusable pipeline components that reduce operational overhead
• Partner with backend product engineers to optimize production database schemas with analytics use cases in mind
• Strengthen data quality, lineage, governance, and documentation practices across key data domains
• Mentor teammates and reinforce best practices in version control, code review, and structured workflow management

Requirements:

• 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 modern orchestration tools such as Prefect and Airflow
• Hands-on administration of cloud-based data warehouse and lake platforms, including Snowflake, AWS (S3, Redshift), and Google Cloud
• A strong understanding of secure external data flows through SFTP, Files.com, and APIs, with a focus on reliability and compliance
• Mastery of version control (Git, GitHub) and structured workflow management (Jira) for code review, audit trails, and operational transparency
• A demonstrated ability to automate and simplify complex manual tasks, building robust, reusable pipeline components
• Dependability, adaptability, and a collaborative approach to engineering, thriving in dynamic and ambiguous environments
• Hands-on experience in startup or rapid-growth environments, delivering technical solutions under shifting priorities
• A background supporting business intelligence, analytics, and data science teams through large-scale integrations and multi-tenant reporting
• Familiarity with both batch and event-driven ingestion paradigms, including near-real-time pipelines built on Snowflake, dbt, and Python
• Experience automating operational, financial, or compliance-driven workflows within cloud data environments
• Exposure to audit, privacy, and compliance frameworks such as SOC 2, HIPAA, GDPR, ISO, and SOX, particularly in data governance and secure access controls
• Experience in regulated industries such as healthcare, healthtech, or SaaS