Senior Snowflake Developer

Position Overview

We are seeking a Senior Snowflake Architect to lead the design, implementation, and optimization of a modern, cloud-based data architecture. This role is a key contributor within our Digital Metamorphosis initiative, focused on modernizing enterprise data platforms by leveraging Snowflake and cloud technologies across AWS and Azure.
The ideal candidate brings deep Snowflake expertise, strong cloud architecture skills, and experience building scalable, production-grade data ingestion and analytics solutions using both batch and real-time streaming patterns.

Key Responsibilities

• Architect, design, and govern enterprise-scale data solutions using Snowflake as the core cloud data platform
• Lead the migration of application data from on-premises Oracle environments to cloud-based architectures (Snowflake / Databricks)
• Design and optimize data ingestion frameworks supporting:
  • File-based batch loads
  • Micro-batching
  • Real-time and streaming data pipelines
• Develop and optimize advanced Snowflake components including:
  • Complex SQL transformations
  • Stored procedures
  • Performance tuning and cost optimization strategies
• Define and enforce data modeling standards, including dimensional and analytical models
• Collaborate with business stakeholders, data engineers, analytics teams, and architects to translate business requirements into scalable technical designs
• Implement and oversee data security, governance, and compliance best practices
• Partner with DevOps teams to implement CI/CD pipelines, version control, and automated deployments
• Monitor platform health, optimize performance, and ensure high availability and data quality
• Create and maintain technical documentation, architecture diagrams, and design standards

Required Qualifications

Core Technical Skills

• 3+ years of hands-on Snowflake experience, including advanced SQL, stored procedures, and performance tuning
• Strong cloud architecture expertise in AWS and/or Microsoft Azure
• Experience designing scalable data ingestion and transformation pipelines
• Proficiency with cloud services such as:
  • AWS: S3, Lambda, CloudWatch
  • Azure: Data Factory, Event Hubs, Blob Storage, Azure Functions
• Strong Python development skills for automation, transformations, and API integrations
• Solid understanding of data modeling, analytics, and warehouse design patterns
• Deep knowledge of data security, access control, and governance frameworks

Job Type & Location
This is a Contract position based out of Chicago, IL.
Pay and Benefits
The pay range for this position is $80.00 - $100.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Chicago,IL.
Application Deadline
This position is anticipated to close on Apr 24, 2026.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.