Role: Snowflake Developer
Duration: 12 months with possibility of extension
Location: Chicago, IL or Tempe, AZ - 3 days onsite per week
 
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.
 
Experience Level: Senior Level - 3
 
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
 
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 from various sources
• Implement data transformation logic using Snowflake SQL, stored procedures, and Python integration Collaborate with data architects and analysts to understand business requirements and translate them 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
• Work closely with DevOps teams to implement CI/CD practices for data pipeline deployments

 
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

 
Preferred Qualifications:

• Snowflake certifications (SnowPro Core or Advanced certifications)
• 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

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 80.00/hr.