Sr. Data Engineer
Carrot Fertility
Skill Required
Key highlights
- Salary: $145,000-$165,000 base
- Experience: Senior level (Sr. Data Engineer)
- Key Benefit: Flexible Time Off and comprehensive family-forming benefits
- Notable Requirement: Expert proficiency in Snowflake, dbt, and Python
Role overview
Carrot is seeking a Sr. Data Engineer to lead the evolution, reliability, and scalability of its 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. Joining the Data Engineering team, you will develop and optimize scalable data pipelines and cloud infrastructure to enable secure, automated reporting and analytics. 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, while serving as an operational steward and technical mentor.
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
- Take end-to-end ownership of core pipelines and integrations, with measurable improvements in reliability, data recency, and cost efficiency
- Automate high-effort manual workflows, reducing operational risk and freeing capacity for higher-value engineering work
- Deliver secure, compliant data integrations that stakeholders across the business trust for decision-making
- Strengthen observability across the platform, including monitoring, alerting, and incident response for critical data workflows
- Establish yourself as a technical mentor and a go-to partner for Business Intelligence, Product, and cross-functional teams
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
Nice to have
- 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
- Competitive compensation, equity, and comprehensive benefits
- 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
- Family-forming assistance
Additional details
- Interview Process: Recruiter Screen (30 mins), Hiring Manager Interview (30–45 mins), Cross-Functional Panel Interviews (45 mins), Executive Leadership Conversation (30 mins), Hiring Manager Wrap-Up (15 mins)
- Fraud and Security Notice: All communication regarding job opportunities at Carrot will come exclusively from an @get-carrot.com email address.
- Note on AI: Carrot values people who are curious and excited to thoughtfully incorporate AI into their day-to-day work to improve quality and efficiency.
- Company Recognition: Recipient of Fast Company's 'Most Innovative Companies', CNBC's '100 Barrier Breaking Startups', Fortune’s Best Workplaces in Healthcare, Great Place to Work, and Age-Friendly Employer certifications.