Sr. Data Engineer

About Carrot

Carrot is the leading global fertility and family care platform, built on intelligent care orchestration: the right clinical guidance, at the right moment, in the context of each member’s life. More than a thousand multinational employers, health plans, and health systems trust Carrot to support millions of members across 195 countries – from pre-pregnancy through menopause and major life moments in between. Carrot's comprehensive clinical program delivers industry-leading cost savings for plan sponsors and award-winning experiences and improved outcomes for millions of people worldwide.

Carrot is widely regarded as a defining force in healthcare innovation as a recipient of several top-tier awards, including Fast Company's 'Most Innovative Companies' and CNBC's '100 Barrier Breaking Startups'. The company is regularly cited by leading global outlets — including The Economist, Bloomberg, The Wall Street Journal, NPR, ABC News, and Harvard Business Review — as a leading voice on digital health, the future of work, and family health. Learn more at get-carrot.com.

The Opportunity

Carrot is seeking a Sr. Data Engineer to lead the evolution, reliability, and scalability of our modern data infrastructure across analytics, reporting, and business intelligence. In this role, you will architect, build, and maintain robust, automated data pipelines, orchestrate workflows, integrate diverse data sources, and partner with stakeholders across the business to deliver secure, compliant, high-quality data solutions.

Your work will span the full data lifecycle, from architecting resilient ETL/ELT pipelines and developing real-time and batch data integrations to automating reporting, reducing technical debt, and enabling advanced analytics. Sr. Data Engineers at Carrot are operational stewards and technical mentors, driving improvements in system maturity, cost efficiency, automation, and collaborative practices.

You will join our Data Engineering team, which develops and optimizes scalable data pipelines and cloud infrastructure to enable secure, automated reporting and analytics across Carrot. The team collaborates closely with Business Intelligence, Product, Finance, Legal, and Commercial partners to deliver reliable integrations and self-serve solutions that drive business insights and operational efficiency.

What You’ll Own

In this role, you will:

• 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

What Success Looks Like

In your first 12–18 months, you will have:

• Taken end-to-end ownership of core pipelines and integrations, with measurable improvements in reliability, data recency, and cost efficiency

• Automated high-effort manual workflows, reducing operational risk and freeing capacity for higher-value engineering work

• Delivered secure, compliant data integrations that stakeholders across the business trust for decision-making

• Strengthened observability across the platform, including monitoring, alerting, and incident response for critical data workflows

• Established yourself as a technical mentor and a go-to partner for Business Intelligence, Product, and cross-functional teams

About You ✨

You likely have:

• 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

Nice to Have

⭐

While not required, we would be especially excited if you bring:

• 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

•