Data Engineer – Snowflake, ETL & Cloud Pipelines

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

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).