Data Movement Engineer(Snowflake + Talend)

US citizens, Green Card Holders, and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1B candidates at this time Job Title: Data Movement Engineer(Snowflake + Talend) Location: New Haven, CT (Hybrid) Duration: Contract 6+ Months Job Description: We are seeking a Data Movement Engineer with strong Snowflake and ETL experience to design, optimize, and support enterprise data pipelines. This role combines hands‑on development, production support, and data architecture, ensuring high data quality, performance, and reliability. Key Responsibilities • Design and optimize Snowflake data pipelines, models, and SQL queries • Support ETL workflows, including monitoring, troubleshooting, and performance tuning • Implement CDC, SCD Type 2, and Data Vault / dimensional models • Perform root cause analysis for data issues and ensure data accuracy and integrity • Manage data quality checks, validations, and reconciliations • Support production systems (Snowflake, DB2, Airflow/ESP) • Collaborate with stakeholders to deliver scalable data solutions • Maintain documentation, runbooks, and support processes Required Skills • 5+ years in data engineering / data warehousing • Strong Snowflake experience (development & data modeling) • Advanced SQL + scripting (Python / Shell) • Experience with ETL tools & orchestration (Airflow, ESP) • Knowledge of CDC, SCD Type 2, Data Vault / dimensional modeling • Familiarity with CI/CD, Git, ServiceNow/Jira Nice to Have • Snowflake certification • Experience with enterprise or real‑time data environments