[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. Celigo is a modern Integration and Automation Platform (iPaaS) on a mission to simplify how companies integrate, automate, and optimize processes. They are seeking a Senior Data Engineer to design and deliver scalable ELT pipelines and data models while ensuring data quality and governance across the organization.ResponsibilitiesDesign, build, and maintain scalable ELT/ETL pipelines and data infrastructure using Snowflake and modern toolingArchitect and implement data models — including dimensional, data vault, and medallion/lakehouse patterns — to support analytics, BI, and ML use casesCollaborate with Analytics, Product, and Engineering teams to translate business requirements into reliable, well-documented data solutionsEstablish and enforce data quality standards, automated validations, and observability frameworks to ensure high reliability across all pipelinesContribute to data governance practices, including documentation, data lineage, access control, and compliance standardsMonitor and optimize pipeline performance, compute cost efficiency, and data freshness across the warehouseEvaluate and implement emerging Snowflake features and data tooling to improve engineering velocity and reduce costsLeverage AI-assisted development tools (e.g., Claude Code, GitHub Copilot, Cursor, or equivalent) to accelerate pipeline development, code review, and documentationParticipate in code reviews, architectural discussions, and cross-functional technical planning sessionsSkillsDeep expertise in Snowflake architecture, including virtual warehouse configuration, clustering, data sharing, role-based access control, and cost governanceStrong command of modern ELT tooling such as dbt, Fivetran, Airflow, or Prefect in a Snowflake-native environmentHands-on experience integrating AI/ML tools into the development cycle, including AI-assisted coding, automated testing, or LLM-powered data workflowsProven ability to translate complex business requirements into scalable, well-documented technical solutionsStrong communication skills with the ability to collaborate effectively across technical and non-technical teamsDegree in Computer Science, Engineering, or a related technical field5+ years of hands-on experience in data engineering, specifically building production-grade pipelines and distributed computing frameworks3+ years working directly with Snowflake in a production capacityDemonstrated experience in architecting or contributing to at least one full data warehouse migration or rebuild on SnowflakeAdvanced 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)BenefitsThree weeks of vacation (starting year one)Wellness days and holidays to rechargeParental leave and a generous benefits packageMonthly tech stipendRecognition and career development opportunitiesRemote-first culture, built on trust, collaboration, and transparencyA high-growth, inclusive work environment where innovation thrives and ideas are implementedLightspeed learning opportunities to keep you at the leading edge of your fieldExceptional coworkers who challenge and inspire you dailyCompetitive compensation and benefitsCompany OverviewCeligo is the AI-driven integration platform(iPaaS) that allows applications to work together for both IT and business users. It was founded in 2011, and is headquartered in San Mateo, California, USA, with a workforce of 501-1000 employees. Its website is http://www.celigo.com.Company H1B SponsorshipCeligo has a track record of offering H1B sponsorships, with 9 in 2025, 6 in 2024, 7 in 2023, 6 in 2022, 6 in 2021, 8 in 2020. Please note that this does not guarantee sponsorship for this specific role.