Snowflake Data Engineer

TEKsystems•New York, NY

1d•$60 - $80•Remote

About The Position

Our 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. A 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. The 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. We 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, and Azure technologies. The ideal candidate has proven experience building scalable cloud data solutions and enjoys solving complex enterprise data challenges in highly regulated environments.

Requirements

Snowflake
Matillion
HVR (High Volume Replication)
Strong understanding of Snowflake architecture and platform design.
Hands-on experience designing, developing, and optimizing Snowflake solutions.
Experience building and maintaining Matillion ELT pipelines.
Experience utilizing HVR for enterprise data replication.
Strong SQL development experience.
Strong analytical and troubleshooting skills.
Excellent communication and collaboration abilities.
Experience working within large enterprise environments.
U.S. Citizen
Snowflake Experience
Matillion Experience
HVR Experience
Strong SQL Skills
Enterprise Data Engineering Experience
Experience Building and Supporting Enterprise Data Pipelines

Nice To Haves

Git
CI/CD
DevOps
AWS
Azure
Data Modeling
ERWIN
Data Governance and Security
Large-Scale Data Ingestion Frameworks

Responsibilities

Design, develop, implement, and maintain enterprise data pipelines in Azure cloud environments.
Build and optimize Snowflake solutions including: SQL Stored Procedures, Views, Performance Tuning, Snowflake Streams for Change Data Capture (CDC).
Develop and support ELT pipelines using Matillion.
Utilize HVR 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.