Snowflake Data Engineer

Snowflake Data EngineerLocation: Remote (U.S.)ðºð BEFORE APPLYING - PLEASE READTHIS POSITION IS ONLY OPEN TO U.S. CITIZENSThis is a firm client requirement and is non-negotiable.Candidates Must: Be a U.S. Citizen Be able to verify U.S. CitizenshipCandidates Cannot Be:Green Card holders H-1B visa holders TN visa holders OPT/CPT candidates Candidates requiring sponsorship now or in the future Any candidate working under visa or employment authorization sponsorshipIf you are not a U.S. Citizen and cannot verify U.S. Citizenship, the client will not be able to consider your application.Top RequirementsTo be considered, candidates must have: U.S. Citizenship Snowflake Experience Matillion ExperienceHVR and/or Fivetran Experience Strong SQL Development Experience Enterprise Data Engineering ExperiencePlease Note: Candidates who do not have hands-on experience with HVR and/or Fivetran for enterprise data replication, ingestion, or integration work will not be considered.About the CompanyOur client is a global leader in advanced aerospace, defense, engineering, and technology solutions. Their products and systems support commercial aviation, military operations, national security initiatives, advanced manufacturing, and mission-critical infrastructure around the world.With tens of thousands of engineers, technologists, and innovators worldwide, the organization continues to invest heavily in cloud modernization, artificial intelligence, advanced analytics, cybersecurity, and enterprise data platforms. Their data teams play a critical role in transforming how information is collected, integrated, governed, and leveraged across some of the most complex engineering and manufacturing environments in the world.As a Snowflake Data Engineer, you'll be joining a team responsible for modernizing enterprise-scale data platforms that support critical business operations, large-scale analytics initiatives, and next-generation digital transformation programs. This is an opportunity to work with massive datasets, modern cloud technologies, and highly skilled engineering teams while helping shape the future of data within a world-class technology organization.Non-Negotiable RequirementsU.S. Citizen Required Must Be Able to Verify U.S. Citizenship Snowflake Experience Matillion ExperienceHVR and/or Fivetran Experience (Required) Strong SQL Skills Enterprise Data Engineering Experience Experience Building and Supporting Enterprise Data PipelinesCandidates who do not meet all of the above requirements will not be considered.Potential Future Security Clearance OpportunityA Secret Security Clearance is NOT required for this role.However, because of the type of work this organization performs, the client may choose to sponsor a consultant for a Secret Security Clearance while they are on contract.There is no promise or guarantee that clearance sponsorship will occur. Any decision would be based on future project needs, business demand, program alignment, and overall fit.Because of this potential opportunity, the client is only considering U.S. Citizens for this position.Position OverviewWe are seeking a Snowflake Data Engineer to join a growing enterprise data team focused on cloud modernization and next-generation analytics initiatives. This individual will design, develop, implement, and maintain enterprise data pipelines using Snowflake, Matillion, HVR/Fivetran, and Azure technologies.The ideal candidate has proven experience building scalable cloud data solutions and enjoys solving complex enterprise data challenges in highly regulated enterprise environments.Required TechnologiesSnowflake | Matillion | HVR/Fivetran | SQL | AzureKey ResponsibilitiesDesign, develop, implement, and maintain enterprise data pipelines in Azure cloud environments.Build and optimize Snowflake solutions including:SQL Stored ProceduresViewsPerformance TuningSnowflake Streams for Change Data Capture (CDC)Develop and support ELT pipelines using Matillion.Utilize HVR and/or Fivetran to replicate SAP and other enterprise source systems into Snowflake.Troubleshoot data quality issues, integration failures, and pipeline performance bottlenecks.Work closely with business analysts, stakeholders, and technical teams to validate requirements and deliver scalable solutions.Support enterprise data governance, security, and compliance initiatives.Contribute to data architecture, performance optimization, and cloud modernization efforts.Required QualificationsStrong understanding of Snowflake architecture and platform design.Hands-on experience designing, developing, and optimizing Snowflake solutions.Experience building and maintaining Matillion ELT pipelines.Hands-on experience utilizing HVR and/or Fivetran for enterprise data replication and ingestion.Strong SQL development experience.Strong analytical and troubleshooting skills.Excellent communication and collaboration abilities.Experience working within large enterprise environments.Preferred QualificationsGitCI/CDDevOpsAWSAzureData ModelingERWINData Governance & SecurityLarge-Scale Data Ingestion FrameworksWhy Join?Work with industry-leading technologies including Snowflake, Matillion, HVR/Fivetran, Azure, and enterprise-scale cloud platforms.Join a world-class engineering and technology organization known for solving highly complex challenges.Support large-scale digital transformation and cloud modernization initiatives.Partner with experienced architects, engineers, and data leaders.Gain exposure to projects that support advanced aerospace, manufacturing, engineering, and government-facing programs.Potential future opportunity for client-sponsored Secret Security Clearance consideration based on program needs.Final ReminderTHIS POSITION IS ONLY OPEN TO U.S. CITIZENSCandidates must be able to verify U.S. Citizenship.No Green Card holders. No visa holders. No sponsorship available now or in the future.HVR and/or Fivetran experience is required. Candidates without hands-on experience supporting enterprise data replication using HVR or Fivetran will not be considered.Applications that do not meet these requirements cannot be considered.Job Type & LocationThis is a Contract position based out of New York, NY.Pay and BenefitsThe pay range for this position is $60.00 - $80.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 5, 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 We’re 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. We’re 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. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re 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-006298852Profession: Database Administrator