Über
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
Required Qualifications
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
Preferred Qualifications
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
Compensation And Benefits
Financial Health
100% 401k match up to 6% of salary
Stock ownership potential
Company‑provided life insurance – 1x salary + commission
Physical Health
Comprehensive health benefits (medical/dental/vision)
Potential premium discounts and company‑provided HSA contributions (up to $500‑$2,000 annually)
Additional medical wellness incentives – up to $300‑$600 annually
Company‑provided long‑term and short‑term disability insurance
Emotional Health
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
Social Health
Charitable matching gifts program
Dollars for Doers volunteer program
Paid volunteering days
15+ employee resource & affinity groups
Total Cash Compensation Range $114,100.00 – 193,975.00 USD annual (inclusive of annual base salary and target incentive)
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.