Sr. Snowflake Developer (AWS & Data Engineering)
Role summary
Seeking a Senior Snowflake Developer with 8+ years of experience in data engineering and AWS. This role focuses on modernizing enterprise data by building scalable data pipelines using Snowflake, AWS Glue, and Python. Responsibilities include designing data models, optimizing Snowflake performance, and leading offshore development teams. The ideal candidate will have strong SQL skills, experience with data warehousing concepts, and the ability to manage complex datasets. Experience with ERP migrations, particularly Oracle Fusion, is a plus.
We are seeking a highly skilled Senior Snowflake Developer 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