About the position
We are seeking a highly experienced Snowflake Engineer with deep expertise in Snowflake system optimization, enterprise data architecture, and scalable pipeline development. This role will be responsible for governing the Snowflake data architecture, fine-tuning system performance, and building scalable data pipelines that power analytics and business intelligence across the Marketing and Sales Organizations. The ideal candidate combines hands-on engineering expertise with architectural vision and performance optimization experience in Snowflake environments. Location: Chicago, IL (Hybrid policy- 4 days onsite) What Success Looks Like A scalable, well-governed Snowflake architecture Optimized compute cost and improved query performance Reliable, observable data pipelines Clean, standardized, and business-aligned data models Strong cross-functional collaboration Creation of detailed & practical documentation for data-consumers
Responsibilities
• Design and implement enterprise-grade Snowflake architecture
• Define data modeling standards and Snowflake best practices
• Design scalable ingestion frameworks for structured and semi-structured data
• Architect solutions for performance, scalability, cost optimization, and governance
• Establish data lifecycle management, retention, and archival strategies
• Partner with analytics, BI, and data science teams to translate business requirements into scalable data solutions
• Maintain clear documentation for data lineage and architecture
• Optimize warehouse sizing and workload management strategies
• Analyze query plans and improve performance using clustering, pruning, and micro-partition strategies
• Improve cost efficiency through compute optimization and storage management
• Implement monitoring frameworks for performance and usage tracking
• Tune ingestion processes
• Design, build, and maintain scalable ETL/ELT pipelines
• Develop orchestration workflows using Airflow, dbt, or similar tools
• Support batch and near real-time data ingestion
• Implement data quality checks, validation rules, and observability
• Troubleshoot and resolve performance bottlenecks across pipelines
Requirements
• 5+ years of experience in Data Architecture
• Proven experience designing Snowflake data architecture at scale
• Advanced SQL and query optimization expertise
• Strong knowledge of data warehousing concepts and modeling techniques
• Experience with cloud platforms (AWS, Azure, or GCP)
• Experience building enterprise-grade ETL/ELT pipelines
Nice-to-haves
• Snowflake certification(s)
• Experience ingesting and cleaning Marketing, Salesforce, & Eloqua datasets
• Experience designing data governance frameworks and compliance standards
• Experience implementing multi-environment (dev/test/prod) Snowflake setups
• Experience with data streaming technologies (Kafka, Kinesis, etc.)
• Experience with cost optimization for large-scale cloud data platforms
Benefits
• 100% 401k match up to 6% of salary
• Stock Ownership Potential
• Company provided life insurance - 1x salary + commission
• Comprehensive health benefits (medical/dental/vision) including potential premium discounts and company-provided HSA contributions (up to $500-$2,000 annually) for specific plans and coverages
• Additional medical Wellness Incentives - up to $300-$600 annual
• Company-provided long- and short-term disability insurance
• Trust-Based Time Off
• 6-week Paid Sabbatical Program
• 6-Week Paid Family Caregiving Leave
• Competitive 8-24 Week Paid Parental Leave
• Adoption Assistance
• Leadership Coaching & Formal Mentorship Opportunities
• Annual Flex Stipend - $1000 annually to cover personal education & well-being expenses
• Tuition Reimbursement
• Charitable Matching Gifts program
• Dollars for Doers volunteer program
• Paid volunteering days
• 15+ Employee Resource & Affinity Groups
Apply Now
Apply Now