Data Movement Engineer

We are seeking a Data Movement Engineer to support the modernization of core data platforms for a mission-driven financial services organization. This role will focus on production support, optimization, and enhancement of Snowflake-based data environments and ETL pipelines. The ideal candidate is highly technical, detail-oriented, and comfortable working in complex enterprise data ecosystems while contributing to meaningful, purpose-driven work. This position is hybrid and requires local presence in the New Haven, CT area., * Support and optimize Snowflake-based data pipelines, models, and ETL/ELT processes.

• Manage end-to-end data movement operations including monitoring, troubleshooting, and performance tuning.
• Resolve data issues related to integrity, latency, failures, and system performance.
• Develop and optimize SQL queries, warehouse configurations, and data models for scalability.
• Support CDC (Change Data Capture), SCD Type 2, Data Vault, and dimensional modeling frameworks.
• Provide production support across Snowflake, IBM DB2, and orchestration tools (Airflow, ESP).
• Perform root cause analysis and implement long-term fixes for recurring data issues.
• Ensure data quality through validation, reconciliation, and consistency checks.
• Collaborate with architects, engineers, and stakeholders to translate requirements into solutions.
• Support data governance, including metadata management, lineage, and documentation.
• Maintain runbooks, documentation, and incident resolution procedures.
• Participate in on-call support and contribute to continuous improvement efforts.
• Provide technical guidance, code reviews, and mentorship to junior team members.

• 5+ years of experience in data warehousing, business intelligence, or data engineering.
• 3+ years of advanced SQL development across platforms such as Snowflake, Oracle, SQL Server, or DB2.
• Strong hands-on experience with Snowflake (development, optimization, security, and architecture).
• Experience with cloud data platforms and modern ETL/ELT processes.
• Proficiency in SQL and scripting languages (Python, Shell).
• Familiarity with orchestration tools (Airflow, ESP) and version control (Git).
• Experience with CI/CD and incident management tools (ServiceNow, Jira).
• Strong understanding of Data Vault, dimensional modeling, CDC, and SCD Type 2.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Ability to work independently in a fast-paced, production-support environment.
• Bachelor's degree in Computer Science, Information Systems, or related field preferred