Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Equity
- Flexible Time Off and a culture that actively encourages employees to recharge.
- Comprehensive parental leave and family-forming benefits.
- Health and wellness benefits
- Retirement savings plans
- Short- and long-term incentives
- Parental leave
- Family-forming assistance
- Remote work
Company Overview
Company H1B Sponsorship