Hiring: Sr. Data Engineer Company: Carrot Location: New York, NY Job Posted Time: 2026-09-17 13:39:59 Target Skills & Keywords : AWS, Airflow, Data Pipeline, Data Warehouse, ELT, ETL, Event-Driven, GCP, GDPR, Git, GitHub, HIPAA, Jira, Prefect, Python, Redshift, S3, SOC 2, SQL, SaaS, Snowflake, dbt About the job Required Skills: •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 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, 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 •Applied hands-on capability 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 Compensation: •$145,000 - $165,000 / year Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!