Data Engineer (Data Vault & Snowflake)

Job Title: Data Movement Engineer (Snowflake) Location: New Haven, CT (prefer hybrid but open for 100% remote for the right candidate) Responsibilities • Manage end-to-end Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelines. • Design, develop, and optimize Snowflake data pipelines, models, SQL queries, and warehouse configurations for performance and scalability. • Translate business requirements into Snowflake-based data movement and integration solutions. • Monitor and resolve data integrity, latency, and pipeline failures; perform root cause analysis and testing prior to production releases. • Implement best practices for data ingestion, transformation, security, and modeling, including CDC and SCD Type 2. • Support Data Vault and dimensional modeling frameworks. • Provide production support for Snowflake, IBM DB2, and orchestration tools (Airflow, ESP). • Ensure data quality through validation, reconciliation, governance, metadata, and lineage tracking. • Collaborate with cross-functional teams, provide technical leadership, code reviews, and mentor junior engineers. • Maintain documentation, support playbooks, incident procedures, and provide status reporting. • Participate in on-call or after-hours support as needed. Qualifications • 5+ years of experience in data warehousing, BI, and analytics; 3+ years of advanced SQL development. • Strong expertise in Snowflake development, data modeling, and security (Snowflake certification preferred). • Proficiency in SQL, Python, and/or shell scripting. • Experience with cloud data platforms, orchestration tools (Airflow, ESP), CI/CD, and version control (Git). • Hands-on experience with CDC, SCD Type 2, Data Vault, and dimensional modeling. • Strong analytical, problem-solving, and organizational skills; ability to work independently. Education • Bachelor’s degree in Computer Science, Information Systems, or related field.