Snowflake Data Engineer: ELT Pipelines & AI Tools

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

Benefits offered by this job

Three weeks of vacation

Wellness days and holidays

Parental leave

Job summary

Celigo, a modern Integration and Automation Platform, is hiring a Data Engineer to build and scale our Snowflake-based data ecosystem. You will design scalable ELT pipelines, data models, and observability frameworks that power analytics, BI, and ML across the organization.

You'll partner with Analytics, Product, and Engineering, enforce data quality and governance, optimize for cost and freshness, and adopt AI-assisted tooling to accelerate development.

Qualifications

• Degree in Computer Science, Engineering, or a related technical field.
• 5+ years of hands-on experience in data engineering, specifically building production-grade pipelines.
• 3+ years working directly with Snowflake in a production capacity.
• Experience with data governance, security, and compliance considerations in a cloud data warehouse context.
• Advanced proficiency in SQL and at least one programming language (Python preferred).

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines and data infrastructure using Snowflake and modern tooling.
• Implement data models — including dimensional, data vault, and medallion/lakehouse patterns — to support analytics, BI, and ML use cases.
• Collaborate in architectural discussions and decisions with the team.
• 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.
• 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.

Skills

Snowflake

dbt

Airflow

Fivetran

Python

SQL

Data governance

Collaboration

Education

B.S. in Computer Science or related field

5+ years data engineering

Tools

GitHub Actions

Snowflake tooling

DBT tooling

Job description

Celigo, a modern Integration and Automation Platform, is hiring a Data Engineer to build and scale our Snowflake-based data ecosystem. You will design scalable ELT pipelines, data models, and observability frameworks that power analytics, BI, and ML across the organization.

You'll partner with Analytics, Product, and Engineering, enforce data quality and governance, optimize for cost and freshness, and adopt AI-assisted tooling to accelerate development.