Job Title: Sr Data Movement Engineer (Talend &
Snowflake)
Location: New Haven, CT 06473 (Remote for EST/CST)
Duration: 06+ months contract - will go long term
(Potential to be contract to hire)
Summary of Job:
Required: Talend, Snowflake, BODI, ETL, SQL, Data architecture, data
vault, DB2, SAP BODI (nice to have), (Snowflake certification - preferred),
Job Description
Overview
- Organization is embarking
on the modernization of its core data platforms.
- We are currently seeking a
Data Movement Engineer who can provide production support to our
existing and future ETL environments.
- This role will also lead
to the design, optimization, and support framework of Snowflake-based data
solutions.
- The ideal candidate will
possess strong technical expertise in Talend, Snowflake, data warehousing
methodologies like Data Vault 2.0, and be comfortable leading complex
projects and mentoring team members.
Core Responsibilities
- Manage
the full lifecycle of Snowflake data operations, including monitoring,
troubleshooting, and optimizing data pipelines.
- Proactively
identify and resolve issues related to data integrity, latency, and
pipeline failures to maintain smooth operations.
- Translate
stakeholder requirements into Snowflake-specific solutions for data
movement.
- Develop
and optimize SQL queries, warehouse configurations, and data models for
performance, reliability, and scalability.
- Design,
develop, and optimize Snowflake data pipelines and models.
- Recommend
and implement best practices for data ingestion, transformation, storage,
security, and data modeling.
- Support
advanced features like Change Data Capture (CDC)and Slowly
Changing Dimensions (SCD Type 2).
- Support
frameworks like Data Vault and dimensional modeling in Snowflake.
- Monitor
and troubleshoot data pipeline failures and performance issues in ETL and
Snowflake environments.
- Thoroughly
test all production solutions prior to implementation.
- Perform
root cause analysis of data discrepancies, latency, and integrity issues.
- Provide
production support for IBM DB2, Snowflake, and orchestration tools
(Airflow, ESP).
- Collaborate
with other teams to implement fixes and preventive measures.
- Perform
data quality analysis, report issues, and propose solutions.
- Ensure
data accuracy, completeness, and consistency across systems.
- Implement
validation and reconciliation checks within pipelines.
- Support
data governance initiatives including metadata management and lineage
tracking.
- Lead
the design, development, and maintenance of Snowflake processes.
- Provide
technical leadership, code reviews, and mentorship to junior developers.
- Coordinate
with business stakeholders, data architects, and application teams to
gather requirements and deliver solutions.
- Communicate
issue status, impact, and resolution timelines effectively.
- Maintain
comprehensive documentation for all Snowflake-related issues, fixes, and
scripts, ensuring they are version-controlled and aligned with data
architecture and security standards.
- Develop
and maintain production support playbooks and detailed ticket resolution
procedures to enable consistent and efficient incident handling.
- Prepare
effort estimations and contribute to architectural decisions.
- Provide
regular updates and reports on issue trends and improvement initiatives.
- On-call
and/or after-hours work required.
Skills Qualifications
- Minimum
of 5 years of relevant experience in data warehousing, business
intelligence tools, and data analysis.
- Minimum
of 3 years of SQL query development across multiple database platforms
(Snowflake, Oracle, SQL Server, DB2).
- Strong
expertise in Snowflake (development, data modeling, security).
Snowflake certification preferred.
- Strong
proficiency in SQL and scripting languages (e.g., Python, Shell).
- Experience
with cloud database technologies.
- Familiarity
with orchestration tools (ESP, Airflow) and version control
systems (Git).
- Experience
with incident management tools (e.g., ServiceNow, Jira) and
CI/CD practices.
- Expertise
in CDC and SCD Type 2implementations using SQL.
- Solid
understanding of data architecture, dimensional modeling, and frameworks
like Data Vault.
- Ability
to solve problems using analytical thinking skills.
- Must
work well independently and be inquisitive.
- Strong
organizational and time management skills.
Education & Experience
- Bachelors
degree in computer science, Information Systems, or related field.
- 5+ years of experience in Talend & Snowflake development and data warehousing.
A reasonable, good faith estimate of the minimum and
maximum hourly wage for this position is $70to $80/hr.
Benefits of our contractor
At Harvey Nash, we know that great technology professionals deserve great support. That’s why we offer a comprehensive benefits package designed to help you thrive—professionally and personally. From company-contributed medical, dental, and vision plans to a 401(k), we invest in your health and future. You’ll also enjoy perks like referral bonuses, commuter savings, a mobile payroll app for easy access to your pay and benefits, and a variety of voluntary insurance options to fit your lifestyle. Join a global IT leader that values your expertise, rewards your contributions, and supports your well-being every step of the way.
* The pay range listed above reflects the expected
starting salary /Pay rate for this role. This range may be adjusted based on
market conditions, location, and other relevant factors. The Company will
determine the final starting salary/Pay rate in consultation with the selected
candidate(s), in full compliance with applicable laws
