Job Description

About the Role

We areseekinga highly experienced SnowflakeEngineerwith deepexpertisein Snowflake system optimization, enterprise data architecture, and scalable pipeline development.

This role willbe responsible forgoverning the Snowflake data architecture, fine-tuning system performance, and buildingscalabledata pipelines that power analytics and business intelligence across theMarketing and Sales Organizations

The ideal candidate combines hands-on engineeringexpertisewith 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 standardsand 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
• Optimizewarehouse sizing and workload management strategies
• Analyze query plans and improve performance using clustering, pruning, and micro-partition strategies
• Improve cost efficiency throughcomputeoptimization and storage management
• Implement monitoring frameworks for performance and usage tracking
• Tune ingestion processes
• Design, build, andmaintainscalable 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 optimizationexpertise
• 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
• Experiencedesigningdata 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