SI
Data Engineering & Operations Lead
full-time•Columbia•$113k - $140k
About this role
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)
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:
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:
- 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
- And much more!
If interested, please apply by:
02/01/2026What you'll do
- The Data Engineering & Operations Lead is responsible for the architecture, design, implementation, and maintenance of data warehouse operations. This includes ensuring efficient and scalable data storage, processing, and analytics.
About Shelter Insurance Companies
Shelter Insurance® is a property casualty insurance company offering auto and home insurance in addition to several other insurance products, including:
Life Insurance
Renters Insurance
Motorcycle Insurance
RV Insurance
ATV Insurance
Boat Insurance
Umbrella Insurance
Personal Articles/Inland Marine Insurance
Farm Insurance
Business Insurance
Shelter Insurance® products are sold by agents in 14 states— Arkansas, Colorado, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Mississippi, Missouri, Nebraska, Ohio, Oklahoma and Tennessee. We consistently receive high ratings from A.M. Best Company (a national firm that rates the financial strength and operating performance of insurance companies) and we are a mutual insurance company, which means we are owned by our policyholders rather than stockholders, and governed by a Board of Directors.
We believe integrity and a commitment to continuous improvement are essential, and we make customer service one of our top priorities. Our primary goal is to be a benefit to our customers, communities, employees and our nearly 1,400 licensed agents as we find ways to maintain our strong financial position and protect our policyholders. That view has served us well throughout our company’s history, and we expect it to carry us well into the future.
The Past to the Present
We opened our doors in 1946, but in those days, we were MFA Mutual Insurance® and we only offered auto insurance. We also only operated in Missouri. Through the years, the Shelter Insurance Group of Companies has expanded to 21 states and offers far more products than we did in 1946. The Group of Companies includes Shelter Life Insurance Company, Shelter Reinsurance® and AmShield Insurance®.
Our Vision
Redefine value in the insurance industry.
Our Mission Statement
Be a leader in our communities by providing daily value while we SHELTER what matters most.
Ready to join Shelter Insurance Companies?
Take the next step in your career journey
Frequently Asked Questions
What does Shelter Insurance Companies pay for a Data Engineering & Operations Lead?
Shelter Insurance Companies offers a competitive compensation package for the Data Engineering & Operations Lead role. The salary range is USD 114k - 141k per year. Apply through Clera to learn more about the full compensation details.
What does a Data Engineering & Operations Lead do at Shelter Insurance Companies?
As a Data Engineering & Operations Lead at Shelter Insurance Companies, you will: the Data Engineering & Operations Lead is responsible for the architecture, design, implementation, and maintenance of data warehouse operations. This includes ensuring efficient and scalable data storage, processing, and analytics..
Is the Data Engineering & Operations Lead position at Shelter Insurance Companies remote?
The Data Engineering & Operations Lead position at Shelter Insurance Companies is based in Columbia, Missouri, United States. Contact the company through Clera for specific work arrangement details.
How do I apply for the Data Engineering & Operations Lead position at Shelter Insurance Companies?
You can apply for the Data Engineering & Operations Lead position at Shelter Insurance Companies directly through Clera. Click the "Apply Now" button above to start your application. Clera's AI-powered platform will help match your profile with this opportunity and guide you through the application process.