Senior Snowflake Data Engineer

• 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

• 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

• 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

• 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

• 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-$2000 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

What We Do

At Morningstar we believe in building great products in-house in a highly collaborative agile environment where we focus on technical excellence the user experience and continuous improvement. Our technologists represent a range of skills and experience levels but they all view their work as a craft and push technology’s boundaries.

Why Work With Us

Imagining big things is in our blood -- it's transformed us from a company with just a few employees in 1984 to a leading independent investment research company with a worldwide presence today. As of April 2020 we acquired Sustainalytics to drive long-term meaningful outcomes for investors in the ESG space. Join us on this exciting journey!

Gallery