Senior Data Engineer: Snowflake ELT & AI-Powered Pipelines

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

Benefits offered by this job

Three weeks of vacation (starting year

Wellness days and holidays

Parental leave

Monthly tech stipend

Career development opportunities

Job summary

Celigo seeks a Data Engineer to design, build, and maintain scalable ELT/ETL pipelines using Snowflake, enabling analytics, BI, and ML use cases.

You will implement data models (dimensional, data vault, medallion) and collaborate across Analytics, Product, and Engineering to translate business requirements into reliable data solutions. Emphasis on governance, quality, and cost efficiency.

Qualifications

• Degree in Computer Science, Engineering, or a related technical field.
• 5+ years of hands-on experience in data engineering with production-grade pipelines.
• 3+ years working directly with Snowflake in production.
• Experience with data governance, security, and compliance in cloud DW contexts.

Responsibilities

• Design, build, and maintain scalable ELT/ETL pipelines and data infrastructure using Snowflake and modern tooling.
• Implement data models—dimensional, data vault, and medallion/lakehouse patterns—for analytics/ML.
• Collaborate in architectural discussions with team and with Analytics, Product, and Engineering.
• Translate business requirements into reliable, well-documented data solutions.
• Establish data quality standards, automated validations, and observability frameworks.

Skills

Snowflake

dbt

Airflow

Prefect

SQL

Python

AI-assisted tooling

Education

CS/Engineering degree

Tools

dbt

GitHub Actions

Fivetran

Airflow

Job description

Celigo seeks a Data Engineer to design, build, and maintain scalable ELT/ETL pipelines using Snowflake, enabling analytics, BI, and ML use cases.

You will implement data models (dimensional, data vault, medallion) and collaborate across Analytics, Product, and Engineering to translate business requirements into reliable data solutions. Emphasis on governance, quality, and cost efficiency.