Data Movement Engineer - New Haven, CT - Hybrid

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges.  We currently looking for Data Movement Engineer for a client based out in New Haven, CT. Please see the job description below for your reference.

Position Title: Data Movement Engineer (Snowflake Talend)

Location: New Haven, CT 06511 (Hybrid)

Duration: 6-12 Months

First priority should be given to locals.

Data Vault experience required

Tags: Snowflake, Data Engineering, ETL, Data Warehousing, SQL, Cloud Data Platforms, Python, Data modeling, Data Pipeline, Data Integration

ABOUT THE ROLE

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.

KEY RESPONSIBILITIES

• 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.

QUALIFICATIONS

• 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

HAVE A NICE DAY!

Joe Murphy (Yousuf)

Technical Recruiter.

Momento USA | Exceeding Customer Expectations…

440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031

Interstate Business Park

Direct: 856-452-7640  Ext 1023 ; Fax: (866) 605-1171

Email: Joe@MomentoUSA.com  (1) Joe Murphy | LinkedIn  Web: www.MomentoUSA.com

Minority Certified by SWAM
National Minority Certified by NMSDC

One of the fastest growing company in NJ
Awarded fastest growing Asian American business by Diversitybusiness.com
E-verified Company

Information transmitted by this e-mail is proprietary to Momento USA and/ or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.