Senior Snowflake Data Engineer
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
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
At Morningstar we believe people are at their best when they are at their healthiest. That's why we champion your wellness through a wide range of programs that support all stages of your personal and professional life. Here are some examples of the offerings we provide:
- 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) 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
- 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
Morningstar's hybrid work environment gives you the opportunity to collaborate in-person each week as we've found that we're at our best when we're purposely together on a regular basis. In most of our locations, our hybrid work model is four days in-office each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you'll have tools and resources to engage meaningfully with your global colleagues.
001_MstarInc Morningstar Inc. Legal Entity
Recommended Jobs
Correctional Officer - Up to $49,056.00 Recruitment Incentive - Direct Hire
Job Description Job Description:\n\n Summary Corrections professionals who foster a humane and secure environment and ensure public safety by preparing individuals for successful reentry into our …
Water Watcher- Lifeguard Certification Required
Welcome to Aqua-Tots! We are saving lives by teaching children all over the world how to become safe and confident swimmers for life. We are year-round and use Indoor heated 90-degree pools! If yo…
Dedicated CDL A Truck Driver - up to $150,000 (Glenview)
Hiring CDL-A Truck Drivers ~ CDL-A DEDICATED DRIVERS - Earn up to $3,000 per week ~ GENEROUS SIGN-ON PACKAGE - $500 orientation pay + up to $5,000 transition bonus ~ CONSISTENT HOME TIME - Get …
Service Advisor
This role requires a Service/Advisor at Gallery Ford of Pekin LLC in Pekin, IL. The responsibilities include basics Service Advisor tasks, along with calling previous day repairs to follow up on the q…
Service Technician
We are looking for a Ford Certified Service Technician to join our growing team! The right candidate will have a strong service technician background and Ford certified. The day-to-day duties include …
Warehouse Associate
Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you’re empowered to make decisions, find solutions and receive rewards…
Manual Machinist
Manual Machinist 1st Shift West Chicago, IL If a culture of excellence, innovation and ownership is what you’re searching for, consider putting your experience in motion at Flowserve. As an indiv…
Physician Assistant
HSHS Medical Group is recruiting a BC/BE Nurse Practitioner or Physician Assistant for our clinic specializing in geriatrics in Springfield, IL. HSHS Medical Group works in partnership with Hospital S…
Senior Data Architect
Xenith Solutions is seeking a detail-oriented and collaborative Senior Data Architect to deliver critical enterprise reference data to enhance command and control (C2), logistics, transportation, dep…
Lead Fire Alarm Technician
One of the Global Leaders in Security and Low Voltage solutions is expanding in the Central Illinois region, and has a new opening for a Lead Fire Alarm Specialist to lead the high-end install, serv…