Snowflake Data Engineer (HVR REQUIRED)

Snowflake Data Engineer (HVR REQUIRED) - U.S. Citizens OnlyU.S. CITIZENS ONLYNO SPONSORSHIP NOW OR IN THE FUTURENO H1BNO OPTNO CPTNO C2CNO THIRD-PARTY CANDIDATESMUST HAVE - READ BEFORE APPLYINGThis is NOT a general Snowflake Data Engineer position.HVR (High Volume Replication / Fivetran HVR) is the primary requirement for this role.The hiring team is specifically seeking engineers who have hands-on experience utilizing HVR to replicate enterprise data into Snowflake environments.Candidates without direct HVR experience will not be considered.About the CompanyOur client is a global aerospace and defense organization undergoing a large-scale enterprise data modernization initiative. The company is investing heavily in cloud-based analytics, reporting, and enterprise data platforms to support critical business operations across a complex global environment.As part of this transformation, the organization is building and expanding its Snowflake ecosystem while leveraging HVR for large-scale data replication and ingestion. This role will support key initiatives involving enterprise source systems, cloud data warehousing, analytics enablement, and data platform modernization.Position OverviewWe are seeking a Snowflake Data Engineer to join a highly visible enterprise data engineering team responsible for designing, developing, and supporting scalable cloud-based data solutions.This individual will work closely with architects, data engineers, business analysts, and stakeholders to deliver modern Snowflake solutions capable of supporting large volumes of enterprise data. The ideal candidate has experience building performant data pipelines, optimizing Snowflake environments, troubleshooting complex data integration issues, and utilizing HVR to support enterprise replication requirements.Key ResponsibilitiesDesign, develop, and support enterprise Snowflake solutions.Configure and maintain HVR replication processes and data integrations.Develop and optimize ELT and ETL pipelines supporting enterprise analytics initiatives.Create and maintain SQL stored procedures, views, and Snowflake data structures.Utilize Snowflake Streams and Change Data Capture (CDC) methodologies to support enterprise data movement.Partner with business analysts and stakeholders to gather requirements and validate results.Monitor and troubleshoot data quality issues, replication failures, and performance bottlenecks.Support large-scale cloud migration and data modernization initiatives.Improve platform reliability, scalability, and performance across Snowflake environments.Collaborate with cross-functional technical teams to deliver enterprise data solutions.Required QualificationsStrong understanding of Snowflake architecture and platform design.Hands-on experience designing, developing, and optimizing Snowflake solutions.Advanced SQL development skills.Experience creating and supporting stored procedures, views, and performance tuning activities within Snowflake.Experience utilizing Snowflake Streams and CDC methodologies.Experience building enterprise data warehouses and data pipelines.Strong analytical and problem-solving abilities.Experience troubleshooting complex data integration and data quality issues.Excellent communication and stakeholder engagement skills.HVR REQUIREMENTHVR experience is mandatory.Candidates should be able to discuss:HVR architectureReplication designSource-to-target integrationsChange Data Capture processesData validation and reconciliationPerformance optimizationProduction support and troubleshootingThe team is specifically looking for engineers who have used HVR to replicate enterprise data into Snowflake environments as part of large-scale modernization initiatives.Preferred QualificationsMatillionFivetrandbtAirflowAWSAzure Data FactoryData ModelingEnterprise Data WarehousingLarge-scale data migration initiativesNice to HaveExperience using Matillion for:ELT pipeline developmentOrchestration jobsTransformation jobsVariables and parameterizationConnector configurationMedallion data architecture and modelingIdeal CandidateThe ideal candidate comes from a large enterprise environment and has supported Snowflake modernization efforts at scale. They should have extensive experience with Snowflake engineering, strong SQL skills, and a proven track record utilizing HVR for enterprise data replication and integration.Screening QuestionDescribe a Snowflake project where you utilized HVR. What systems were involved, what challenges did you encounter, and what was your role in designing, supporting, or optimizing the replication process?Job Type & LocationThis is a Contract position based out of New York, NY.Pay and BenefitsThe pay range for this position is $70.00 - $78.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)Workplace TypeThis is a fully remote position.Application DeadlineThis position is anticipated to close on Oct 12, 2026.About TEKsystemsWe're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.About TEKsystems and TEKsystems Global Services Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.Job SummaryJob number: JP-006315488Profession: Database Administrator