Data Engineering & Operations Lead

Shelter Insurance; Columbia Township, Northern (MO, KY); Hybrid; USD 114,000 - 141,000; Full time

Benefits offered by this job

Health, Dental, Vision

401(k) Savings & Profit Sharing

Paid Time Off

Wellness program

Dress for Your Day

Flexible Scheduling

Job summary

Shelter Insurance is hiring a Data Engineering & Operations Lead in Columbia, Missouri. This on-site, full-time role focuses on the architecture, design, implementation, and ongoing maintenance of data warehouse operations, leveraging Snowflake, AWS, and Qlik to enable scalable analytics.

The position requires 7+ years in data engineering, a strong background in data modeling and ETL, and proficiency in SQL and Python scripting.

Qualifications

• Bachelor's or Master's degree in computer science, information systems, or a related field is preferred.
• 7+ years of experience as a Data Engineering Practitioner typically required.
• Proficiency in Qlik Replicate, Compose, 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.
• Knowledge of dbtLabs, Astronomer, Github is preferred.
• 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.

Responsibilities

• Architecture & design, implementation, and maintenance of data warehouse operations.
• Expertise in Snowflake, AWS and Qlik tools to ensure efficient and scalable data storage, processing, and analytics.
• Ability to perform the essential functions of the position, with or without a reasonable accommodation.

Skills

Snowflake

AWS

Qlik

SQL

Python

ETL

Data warehousing

dbtLabs

Astronomer

Github

Education

Bachelor's or Master's degree in computer science or related field

Tools

Qlik Replicate

Qlik Compose

DBTLabs

Astronomer

Github

Job description

A company built to serve you. It's your career, Shelter it! Data Engineering & Operations Lead $113,687 - $140,972 / year minimum starting pay Job Level: Supervisor Location: Columbia, Missouri (On-site, Full-time)

What You Will Be Doing:

• Responsible for architecture & design, implementation, and maintenance of data warehouse operations.
• Expertise in Snowflake, AWS and Qlik tools 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 (7+ years) as a Data Engineering Practitioner typically required.
• Proficiency in Qlik Replicate, Compose, 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.
• Knowledge of dbtLabs, Astronomer, Github is preferred.
• 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 the 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:

Shelter Employees enjoy such benefits as:

• 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

The Shelter Insurance® group of companies is a leader in the insurance industry, providing customers with exceptional insurance and financial products and services. Since opening our doors in 1946, we have become one of the most successful and financially-sound, super-regional insurance groups in the country. We provide a variety of insurance options for our customers including auto, home, life and business insurance. We exist to be a leader in our communities by providing daily value while we SHELTER what matters most. At Shelter Insurance, we value, celebrate, and invest in people. With over 75 years of success, we have built a strong foundation rooted in doing the right thing and making progress that truly matters - for our employees, our customers, and our communities. Our employees are the backbone of our success, which is why we are committed to fostering an inclusive environment, offering competitive benefits and meaningful opportunities for growth and development. We strive to honor our legacy, while innovating for a future full of opportunities. Shelter has a purpose driven culture that centers on: Involvement Within Our Communities Financial Strength & Stability Benefits This is your opportunity to be a part of an incredible company with people who encourage you and will help you grow personally and professionally. We champion diversity and strive to provide opportunities. Our family-oriented culture is one that promotes inclusion and positivity. Together we have achieved the winner of the Award for Best Places to Work since 2017! Shelter Insurance is proud to be Equal Opportunity Employers committed to creating a diverse and inclusive workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability, veteran status, or other legally protected classifications. If you have a disability and require reasonable accommodations for any part of the selection process, we're here to help you out.