Data Engineering & Operations Specialist

Shelter Insurance Companies • Columbia, MO

2d • Onsite

About The Position

A company built to serve you. It's your career, Shelter it! Data Engineering & Operations Specialist $101,504 – 125,868 / year minimum starting pay Job Level: Individual Contributor Location: 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.

Requirements

• Proven experience (4+ years) as a Senior Data Engineer.
• Expertise in Qlik Replicate, Compose, and DBTLabs & Astronomer.
• Hands-on experience in Snowflake.
• Proficiency in Qlik Replicate, Compose, and Github, DBTLabs & Astronomer 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.

Responsibilities

• Design, implement, and maintain data pipelines, data integration solutions, and data architecture.
• Ensure efficient and scalable data storage, processing, and analytics using Snowflake.

Benefits

• Health, Dental, Voluntary Vision and Prescription Drug Insurance
• Savings and Profit Sharing
• 401(k)
• Paid Time Off for Sick and Personal Leave, Vacation and Holidays
• Vitality Wellness Program
• "Dress for Your Day" Dress Code
• Flexible Scheduling

What This Job Offers

• Job Type: Full-time
• Career Level: Senior