Senior Snowflake Developer

Job Title: Senior Snowflake Developer Location: Chicago, Illinois (Hybrid) Duration: 12+ Month Contract (If performance is good, it may extend for another 12 months) Interview Process: • Video Questionnaire Screening (Client + Vendor) • 2 Rounds of Video Interview Experience • Minimum 12+ years of IT experience • Minimum 6+ years of Data Engineering experience • Minimum 4+ years of Snowflake Development experience Position Overview We are seeking an experienced Snowflake Developer to join our data engineering team. The ideal candidate will have strong expertise in Snowflake data platform capabilities, with proven experience in designing and implementing robust data ingestion solutions across both file-based and streaming architectures on AWS and Azure cloud platforms. Required Qualifications – Technical Skills • 3+ years of hands-on experience with Snowflake data platform, including advanced SQL, stored procedures, and performance optimization • Strong experience with data ingestion patterns including bulk loading, micro-batching, and streaming data processing • Proficiency with AWS services such as S3, Lambda, and CloudWatch • Experience with Azure data services including Data Factory, Event Hubs, Blob Storage, and Azure Functions • Solid Python programming skills for data processing, API integrations, and automation scripts • Experience with data modeling concepts and dimensional modeling techniques • Understanding of data security, governance, and compliance best practices Preferred Qualifications • Snowflake certifications (SnowPro Core or Advanced) • Experience with Infrastructure as Code tools (Terraform, CloudFormation) • Knowledge of containerization technologies (Docker, Kubernetes) • Familiarity with data visualization tools and business intelligence platforms • Experience with data quality frameworks and monitoring tools Professional Experience • Bachelor’s degree in Computer Science, Information Systems, or related technical field • Minimum 4+ years of experience in data engineering or related roles • Proven track record of delivering production-ready data solutions at scale • Experience with version control systems (Git) and collaborative development practices Tasks & Responsibilities • Design, develop, and maintain scalable data pipelines using Snowflake as the core data warehouse platform • Build and optimize data ingestion processes for both batch file-based loads and real-time streaming data • Implement data transformation logic using Snowflake SQL, stored procedures, and Python integration • Collaborate with data architects and analysts to translate business requirements into technical solutions • Monitor and troubleshoot data pipeline performance, ensuring high availability and data quality • Develop and maintain documentation for data processes, data models, and system architecture