14 days ago
Base Salary
$130k - $150k/yr
Responsibilities
- Design, build, and maintain scalable ELT/ETL pipelines and Snowflake data infrastructure.
- Implement dimensional, data vault, and medallion/lakehouse data models for analytics, BI, and ML use cases.
- Collaborate on architectural discussions and decisions with the team.
- Translate business requirements into reliable, well-documented technical data solutions with Analytics, Product, and Engineering teams.
- Establish data quality standards, automated validations, and observability frameworks for pipeline reliability.
- Contribute to data governance, documentation, data lineage, access control, and compliance practices.
- Monitor and optimize pipeline performance, compute costs, and data freshness.
- Evaluate Snowflake features and data tooling to improve engineering velocity and reduce costs.
- Use AI-assisted tools for pipeline development, code review, and documentation.
Requirements
- Degree in Computer Science, Engineering, or a related technical field.
- 5+ years of hands-on data engineering experience building production-grade pipelines and distributed computing frameworks.
- 3+ years of direct production experience with Snowflake.
- Experience architecting or contributing to a complete Snowflake data warehouse migration or rebuild.
- Advanced SQL proficiency and proficiency in at least one programming language, with Python preferred.
- Strong hands-on Snowflake experience, including performance optimization, warehouse configuration, access controls, and cost-efficient development.
- Strong command of modern ELT tools such as dbt, Fivetran, Airflow, or Prefect in a Snowflake-native environment.
- Experience integrating AI/ML tools into development, including AI-assisted coding, automated testing, or LLM-powered data workflows.
- Experience with version-controlled, CI/CD-driven data pipeline development, such as dbt with GitHub Actions.
- Familiarity with data governance, security, and compliance in cloud data warehouses, including column-level security, dynamic data masking, and audit logging.
- Ability to translate complex business requirements into scalable, documented technical solutions and collaborate across technical and non-technical teams.
Benefits
- Remote-first culture.
- Three weeks of vacation starting in year one.
- Wellness days and holidays.
- Parental leave and a benefits package.
- Monthly technology stipend.
- Recognition and career development opportunities.
- Inclusive, collaborative, high-growth work environment with learning opportunities.
About Celigo
Celigo builds an integration platform-as-a-service (iPaaS) that lets companies connect cloud applications, automate business processes, and manage APIs and data flows. Its subscription platform includes prebuilt integrations, AI-assisted workflows and agents, and tools for API management and data ingestion, used by thousands of companies. Founded in 2011 and headquartered in Redwood City, California, Celigo is privately held.