Senior Data Engineer

Stack

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
• ▹In the first 12-18 months: take end-to-end ownership of core pipelines and integrations, with measurable improvements in reliability, data recency and cost efficiency
• ▹In the first 12-18 months: strengthen observability across the platform, including monitoring, alerting and incident response for critical data workflows

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

Soft skills

What we offer

• ▹Competitive compensation, equity and comprehensive benefits
• ▹Flexible Time Off and a culture that encourages employees to recharge
• ▹Comprehensive parental leave and family-forming benefits
• ▹Collaborative, inclusive, values-driven culture
• ▹High-growth environment where leaders are empowered to shape strategy
• ▹Health and wellness benefits, retirement savings plans, short- and long-term incentives

About the company

Carrot is a leading global fertility and family care platform that serves more than a thousand multinational employers, health plans and health systems, supporting members in 195 countries through different stages of family building.