Enterprise Data Engineer

Shelter Insurance; Columbia Township (MO); On-site; USD 80,000 - 99,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) savings and profit sharing

Paid time off

Job summary

Shelter Insurance is hiring an Enterprise Data Engineer in Columbia, Missouri (on-site). The role focuses on designing, implementing, and maintaining data pipelines and architecture with a strong emphasis on Snowflake for storage, processing, and analytics.

Candidates should have a 2+ year track record as a Data Engineer, with hands-on work in Snowflake, Qlik Replicate, Compose, and DBTLabs, Astronomer, and GitHub, plus solid SQL and scripting skills (Python/PowerShell).

Qualifications

• Bachelor's or Master's degree in computer science, information systems, or a related field preferred.
• 2+ years of Data Engineer experience with Snowflake, ETL/ELT, and data warehousing.
• Proficiency in SQL and scripting languages (Python, PowerShell) for data manipulation and automation.
• Experience with data integration, replication, and transformation using tools like Qlik Replicate, Compose, DBTLabs, Astronomer & GitHub.

Responsibilities

• Design, implement, and maintain data pipelines and data architecture.
• Ensure Snowflake-based storage, processing, and analytics are efficient and scalable.
• Collaborate with cross-functional teams to manage data quality, governance, and lifecycle.

Skills

SQL

Python

PowerShell

ETL

Data warehousing

Education

Bachelor's or Master's in CS/IS or related field

Tools

Snowflake

Qlik Replicate

Compose

DBT Labs

Astronomer

GitHub

AWS

Azure

Job description

A company built to serve you. It's your career, Shelter it!Enterprise Data Engineer$79,518 - $98,581 / year minimum starting payJob Level: Individual ContributorLocation: Columbia, Missouri (On-site, Full-time)Shelter maintains broad salary ranges for its roles in order to account for variations in geographic location, education, training, skills, relevant work experience, business needs and market demands. Please remember that this range is the starting base pay only and does not consider other components that make up the total rewards package for the position.What You Will Be Doing:Design, implement, and maintain data pipelines, data integration solutions, and data architecture. Expertise in Snowflake is required to ensure efficient and scalable data storage, processing, and analytics.What We're Looking For:Bachelor's or Master's degree in computer science, information systems, or a related field is preferred.Proven experience (2+ years) as a Data Engineer, with expertise in Qlik Replicate, Compose, and DBTLabs, Astronomer & Github, combined with hands-on experience in Snowflake typically required.Proficiency in Qlik Replicate, Compose, and Enterprise Engineer for data integration, replication, and transformation.Strong understanding of data engineering principles, data modeling, ETL processes, and data warehousing concepts.Expertise in Snowflake, including data ingestion, storage, performance optimization, and security.Experience with cloud platforms, such as AWS or Azure, and working with cloud-based data solutions and services.Familiarity with data quality, data governance, and data lifecycle management practices.Solid programming skills in SQL and scripting languages (e.g., Python, PowerShell) for data manipulation and automation.Strong problem-solving and troubleshooting abilities, with the ability to diagnose and resolve data engineering issues.Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams and stakeholders.Ability to perform essential functions of the position, with or without a reasonable accommodation.Shelter's uncompromising commitment to excellence doesn't stop with our customers. We recognize our employees are what make us a premier organization in the insurance industry. Shelter Employees enjoy such benefits as:Health, Dental, Voluntary Vision and Prescription Drug InsuranceSavings and Profit Sharing 401(k)Paid Time Off for Sick and Personal Leave, Vacation and HolidaysVitality Wellness Program\"Dress for Your Day\" Dress CodeFlexible SchedulingAnd much more!If interested, please apply by:10/12/2026