Data Engineer

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

At Celigo, we believe integration should empower — not exhaust — innovation. As a modern Integration and Automation Platform (iPaaS), we’re on a mission to simplify how companies integrate, automate, and optimize processes. Powered by game-changing technology like runtime AI and prebuilt, mission-critical integrations, Celigo is redefining how businesses connect their world.

Celigo is looking for a Data Engineer to contribute to the development, scaling, and maintenance of our Snowflake-based data ecosystem. You will implement and deliver scalable ELT pipelines, production-grade data models, and the observability frameworks that keep them reliable — translating business requirements into well-documented, high-performance data solutions that power analytics, BI, and ML across the organization. Partnering closely with Analytics, Product, and Engineering, you will help enforce data quality standards, align with governance practices, and continuously optimize for cost efficiency and data freshness. You'll bring strong Snowflake experience, a modern dbt-native development mindset, and a fluency with AI-assisted tooling to accelerate your own velocity and collaborate effectively with the team around you.

What would you do if hired?

• 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 discussion and decision making with 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 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 (e.g., Claude Code, GitHub Copilot, Cursor, or equivalent) to accelerate pipeline development, code review, and documentation.

Who are we looking for?

Skills & Abilities

• Strong hands-on experience with Snowflake, including performance optimization, warehouse configuration, access controls, and cost-efficient development practices.
• Strong command of modern ELT tooling such as dbt, Fivetran, Airflow, or Prefect in a Snowflake-native environment.
• Hands-on experience integrating AI/ML tools into the development cycle, including AI-assisted coding, automated testing, or LLM-powered data workflows.
• Proven ability to translate complex business requirements into scalable, well-documented technical solutions.
• Strong communication skills with the ability to collaborate effectively across technical and non-technical teams.

Education & Experience

• Degree in Computer Science, Engineering, or a related technical field.
• 5+ years of hands-on experience in data engineering, specifically building production-grade pipelines and distributed computing frameworks.
• 3+ years working directly with Snowflake in a production capacity.
• Demonstrated experience in architecting or contributing to at least one full data warehouse migration or rebuild on Snowflake.
• Advanced proficiency in SQL and at least one programming language (Python preferred).
• Experience with version-controlled, CI/CD-driven data pipeline development (e.g., dbt + GitHub Actions or equivalent).
• Familiarity with data governance, security, and compliance considerations in a cloud data warehouse context (e.g., column-level security, dynamic data masking, audit logging).

Celigo reasonably expects to pay a base salary between $130,000 and $150,000 per year for this position. Actual starting base pay will be determined by skills, experience, geographic location, and other non-discriminatory factors permitted by law. Total compensation may also include variable incentives, benefits, or other perks as outlined in any formal employment offer made.

Celigo is proud to be

• A 2025 Gartner Customers’ Choice for iPaaS. The only vendor to receive this award.
• Celigo is a Visionary in the Gartner Magic Quadrant for iPaaS for the second consecutive year
• Celigo is ranked #1 iPaaS on G2 for multiple quarters and named a Leader in both B2B/EDI and API Management.
• Celigo is a leading intelligent automation platform that puts the power of automation in the hands of every team, unifying workflows from the predictable to the fully agentic in a single platform.
• Remote-first culture, built on trust, collaboration, and transparency
• A high-growth, inclusive work environment where innovation thrives and ideas are implemented
• Lightspeed learning opportunities to keep you at the leading edge of your field
• Exceptional coworkers who challenge and inspire you dailyCompetitive compensation and benefits, including:
• Three weeks of vacation (starting year one)
• Wellness days and holidays to recharge
• Parental leave and a generous benefits package
• Monthly tech stipend
• Recognition and career development opportunities

Diversity, Equity, Inclusion, and Accessibility

As a company, one of the values we hold most dear is fostering a safe, collaborative environment to bring out the best in us, so we created our Taking a Stand Initiative. Our TAS initiative is a volunteer committee open to all Celigans, with representation from underrepresented voices within our company. We believe, unequivocally, that everyone deserves to be in a place where they feel welcome as they are. Learn more about Taking a Stand .

Celigo is proud to be an equal-opportunity workplace. We are committed to equal employment opportunities regardless of race, color, ancestry, national origin, religion, creed, age, disability, sex, gender, sexual orientation, gender identity, gender expression, medical condition, genetic information, marital status, military and veteran status, or any other characteristic protected by applicable law. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.