Data Movement Engineer (Snowflake + Talend) - Contractor
Location: REMOTE- (East coast preferred)
REQUIRED: Strong Talend and Snowflake experienceType: w2 (must work directly for Advantage Technical) contract, 6 months +OverviewWe are currently seeking a Data Movement Engineer who can provide production support to our existing and future ETL environments. This role will also lead the design, optimization, and support framework of Snowflake-based data solutions. The ideal candidate will possess strong technical expertise in Snowflake, data warehousing methodologies like Data Vault 2.0, and be comfortable leading complex projects and mentoring team members.
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
- Bachelors degree in computer science, Information Systems, or related field.
- 5+ years of experience in Snowflake, Talend development and data warehousing.
#Techjobs
#LI-DT1
The base pay range listed reflects what we reasonably expect to offer for this role. Actual pay may vary based on location, experience, and performance. Depending on the position, benefits may include medical, dental, and vision coverage; retirement and savings plans; paid holidays and time off; supplemental insurance; and additional wellness or incentive programs.
About UsAdvantage Technical connects top- talent in technology, engineering, and technical fields with forward-looking companies.
Advantage Technical is an equal opportunity employer. All applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other legally protected status. Advantage Technical offers reasonable accommodations for qualified individuals with disabilities; contact your local branch for inquiries. Advantage Technical is an E-Verify employer. See our Privacy Notice for Candidates and Employees/Contractors at By applying, you consent to receive AI-generated and non-AI-generated calls, texts, or emails from Staffmark Group, its affiliates, and partners. Frequency varies and message/data rates may apply. Reply STOP to cancel or HELP for help.
Never miss an opportunity! Create an alert based on the job you applied for.
