Senior Data Engineer: Scale Data Pipelines & Analytics

Coinscapture; Northern (KY); Hybrid; USD 145,000 - 165,000; Full time

Job summary

Carrot is seeking a Sr. Data Engineer to lead evolution of our data infrastructure across analytics, reporting, and BI. You will architect, build, and maintain automated data pipelines, integrate diverse sources, and partner with stakeholders to deliver secure, high-quality data solutions.

Your work spans ETL/ELT, real-time and batch integrations, and automation of reporting to reduce technical debt. You will mentor teammates and improve data quality, governance, and observability.

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.

Responsibilities

• Architect, build, test, deploy, and maintain scalable 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.

Skills

Snowflake

dbt

Python

Advanced SQL

ETL/ELT pipelines

Prefect

Airflow

Cloud data administration

Git

Jira

Tools

Snowflake

dbt

Python

Job description

Carrot is seeking a Sr. Data Engineer to lead evolution of our data infrastructure across analytics, reporting, and BI. You will architect, build, and maintain automated data pipelines, integrate diverse sources, and partner with stakeholders to deliver secure, high-quality data solutions.

Your work spans ETL/ELT, real-time and batch integrations, and automation of reporting to reduce technical debt. You will mentor teammates and improve data quality, governance, and observability.