Tech Lead Developer- Snowflake

Senior Snowflake Lead (AWS & Data Engineering)
Type: Contract
Location: Remote

Overview
We are seeking a highly skilled Senior Snowflake Lead with strong experience in AWS-based data engineering, including AWS Glue and Python. This role will support enterprise data modernization initiatives by building scalable data pipelines, optimizing Snowflake environments, and enabling seamless integration across multiple systems.

This position requires a hands-on lead who can drive technical solutions while also coordinating with offshore teams, ensuring high-quality and timely delivery. Experience working on ERP migrations, particularly with Oracle Fusion, is a strong plus.

Key Responsibilities

• Design, develop, and optimize data pipelines using Snowflake, AWS Glue, and Python
• Build and maintain ETL/ELT workflows for data ingestion, transformation, and loading into Snowflake
• Develop scalable data models, schemas, and Snowflake objects such as tables, views, streams, and tasks
• Lead and coordinate offshore development teams, including task planning, code reviews, and delivery tracking
• Integrate data from multiple sources including ERP systems, APIs, and legacy platforms
• Support data migration initiatives from legacy systems to modern cloud environments
• Optimize Snowflake performance including query tuning, warehouse sizing, and cost efficiency
• Collaborate with data architects, BI developers, and business stakeholders to deliver data solutions
• Implement data quality, validation, and monitoring processes
• Troubleshoot and resolve data pipeline and performance issues
• Participate in Agile ceremonies and ensure alignment across distributed teams

Required Qualifications

• 8+ years of experience in data engineering or data development
• Strong hands-on experience with Snowflake, including data modeling and performance optimization
• Experience with AWS services, especially AWS Glue for ETL development
• Proficiency in Python for data processing and pipeline development
• Strong SQL skills and deep understanding of data warehousing concepts
• Proven experience in a lead or senior role, driving delivery and mentoring team members
• Experience working with offshore/onshore delivery models
• Ability to work with large and complex datasets

Preferred Qualifications

• Experience with ERP data migration projects, especially Oracle Fusion
• Familiarity with legacy systems such as PeopleSoft or DataStage and modernization efforts
• Experience with data orchestration and scheduling tools
• Exposure to Power BI or other BI tools
• Understanding of data governance, security, and access control

Key Skills

• Snowflake Data Engineering
• AWS Glue and Cloud Data Pipelines
• Python for Data Processing
• ETL/ELT Development
• Data Modeling and Performance Optimization
• ERP Data Integration and Migration
• SQL and Data Warehousing

Additional Expectations

• Ability to coordinate across time zones and work closely with offshore teams
• Flexibility to support extended hours when needed for critical deliverables
• Strong communication and stakeholder management skills