Logo for Carrot Fertility

Senior Data Engineer

Roles & Responsibilities

  • 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 data lake platforms (Snowflake, AWS S3/Redshift, Google Cloud) including integration of new sources and performance optimization.

Requirements:

  • Architect, build, and maintain robust, automated data pipelines and oversee data orchestration across analytics, reporting, and BI.
  • Integrate diverse data sources, support real-time and batch data integrations, and automate reporting while optimizing for performance and reliability.
  • Drive improvements in data infrastructure maturity, automation, cost efficiency, and governance; mentor junior engineers and promote best practices.
  • Partner with stakeholders across business lines to deliver secure, compliant, high-quality data solutions and enable self-serve analytics.

Job description

About Carrot:

Carrot is a global, comprehensive fertility and family care platform, supporting members and their families through many of life's most memorable moments. Trusted by many of the world’s leading multinational employers, health plans, and health systems, Carrot’s proven clinical program delivers exceptional outcomes and experiences for members and industry-leading cost-savings for employers. Its award-winning products serve all populations, from preconception care through pregnancy, IVF, male factor infertility, adoption, gestational carrier care, and menopause. Carrot offers localized support in over 170 countries and 25 languages. With a comprehensive program that prioritizes clinical excellence and human-centered care, Carrot supports members and their families through many of the most meaningful moments of their lives. Learn more at get-carrot.com.

The Role: 

The Senior Data Engineer leads the evolution, reliability, and scalability of the modern data infrastructure across analytics, reporting, and business intelligence. This role is responsible for architecting, building, and maintaining robust, automated data pipelines, orchestrating workflows, integrating diverse data sources, and partnering with stakeholders across the business to deliver secure, compliant, high-quality data solutions. Hands-on responsibilities span the full data lifecycle, from architecting resilient ETL/ELT pipelines and developing real-time and batch data integrations to automating reporting, optimizing technical debt, and enabling advanced analytics. Senior Data Engineers are operational stewards and technical mentors, driving improvements in system maturity, cost efficiency, automation, and collaborative practices.

The Team: 

Our Data Engineering team develops and optimizes scalable data pipelines and cloud infrastructure to enable secure, automated reporting and analytics. We collaborate closely with partner, product, finance, and legal teams to deliver reliable integrations and self-serve solutions that drive business insights and operational efficiency. The team leads technical incident management, data governance, and ongoing improvements while supporting cross-functional mentorship and stakeholder needs.

Minimum Qualifications: 

  • 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—Snowflake, AWS (S3, Redshift), Google Cloud—including integration of new sources and performance optimization.
  • Strong understanding of secure external data flows through SFTP, Files.com: Next-Generation MFT, SFTP & File Sharing , 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.
  • Demonstrated ability to automate and simplify complex manual tasks, building robust, reusable pipeline components that reduce operational overhead.
  • Depth in orchestrating workflows with custom scheduling, alerting, dependency management, monitoring, and error resolution.
  • Dependability, adaptability, and a strong collaborative approach to engineering, thriving in dynamic and ambiguous environments.

Preferred Qualifications:

  • Extensive hands-on experience in dynamic, fast-paced settings, including startup or rapid-growth environments, delivering technical solutions under shifting priorities.
  • Direct background supporting cross-functional teams—business intelligence, analytics, and data science—by enabling large-scale integrations, multi-tenant reporting, and advanced analytics tooling.
  • Familiarity with both batch and event-driven ingestion paradigms, including building near-real-time data pipelines utilizing Snowflake, dbt, and Python.
  • Experience automating complex operational, financial, or compliance-driven workflows within cloud data environments.
  • Exposure to audit, privacy, and compliance frameworks (SOC, HIPAA, GDPR, ISO, SOX), particularly in implementing robust data governance and secure access controls.
  • Experience working with regulated industries such as healthcare, healthtech, or SaaS environments.

 

Compensation: 

Carrot offers a holistic Total Rewards package designed to support our employees in all aspects of their life inside and outside of work, including health and wellness benefits, retirement savings plans, short- and long-term incentives, parental leave, family-forming assistance, and a competitive compensation package. The starting base salary for this position will range from $155,000.00 - $195,000.00. Actual compensation may vary from posted base salary depending on your confirmed job-related skills and experience. 

 

Fraud and Security Notice: Please note that all communication regarding job opportunities at Carrot will come exclusively from an @get-carrot.com email address. If you receive messages from any other domain, please disregard them and report the incident to: securityreporting@get-carrot.com

Why Carrot?

Carrot has received national and international recognition for its pioneering work, including Fast Company's Most Innovative Companies and World Changing Ideas, Inc. Power Partners, and Modern Healthcare’s Innovators. Carrot’s global workforce has been acknowledged with several accolades, including Fortune’s Best Workplaces in Healthcare, Great Place to Work, and Age-Friendly Employer certifications. Carrot is regularly featured in media reporting on issues related to the future of work, women in leadership, and healthcare innovation, including MSNBC, The Economist, Bloomberg, The Wall Street Journal, CNBC, National Public Radio, Harvard Business Review, and more. Learn more at carrotfertility.com. 

 

Data Engineer Related jobs

Other jobs at Carrot Fertility

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.