Senior Data Engineer: Snowflake ELT & AI-Driven Pipelines

Celigo; Northern (KY); Hybrid; USD 130,000 - 170,000; Full time

Benefits offered by this job

Three weeks vacation

Wellness days

Parental leave

Monthly tech stipend

Competitive compensation

Job summary

Celigo is seeking a Senior Data Engineer to own the design and delivery of scalable ELT pipelines in a Snowflake-centric data ecosystem. You will architect data models and governance practices, partner with analytics, product, and engineering teams, and drive data quality, cost efficiency, and data freshness across the warehouse.

Join a remote-first, high-growth environment that values AI-assisted tooling, experimentation, and elegant data solutions.

Qualifications

• 5+ years of hands-on data engineering experience building production-grade pipelines.
• 3+ years with Snowflake in a production capacity.
• Advanced SQL and Python; CI/CD data pipelines (dbt + GitHub Actions).
• Experience with data governance, security, and cloud data warehouse considerations.

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines and data infrastructure using Snowflake and modern tooling.
• Architect and implement data models — including dimensional, data vault, and medallion/lakehouse patterns — to support analytics, BI, and ML use cases.
• Collaborate with Analytics, Product, and Engineering teams to translate business requirements into reliable, well-documented data solutions.
• Establish and enforce data quality standards, automated validations, and observability frameworks to ensure high reliability across all pipelines.
• Contribute to data governance practices, including documentation, data lineage, access control, and compliance standards.
• Monitor and optimize pipeline performance, compute cost efficiency, and data freshness across the warehouse.
• Evaluate and implement emerging Snowflake features and data tooling to improve engineering velocity and reduce costs.
• Leverage AI-assisted development tools to accelerate pipeline development, code review, and documentation.
• Participate in code reviews, architectural discussions, and cross-functional technical planning sessions.

Skills

Snowflake architecture

ELT/ETL tooling

SQL proficiency

Python

CI/CD data pipelines

Data governance & security

AI-assisted tooling

Cross-team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

dbt

Fivetran

Airflow

Prefect

GitHub Actions

Job description

Celigo is seeking a Senior Data Engineer to own the design and delivery of scalable ELT pipelines in a Snowflake-centric data ecosystem. You will architect data models and governance practices, partner with analytics, product, and engineering teams, and drive data quality, cost efficiency, and data freshness across the warehouse.

Join a remote-first, high-growth environment that values AI-assisted tooling, experimentation, and elegant data solutions.