Full-Time

Data Engineering & Operations Specialists

Posted on 1/31/2025

Shelter Insurance

Shelter Insurance

1,001-5,000 employees

Regional provider of various insurance products

Financial Services

Compensation Overview

$99.1k - $122.9kAnnually

Mid, Senior

Columbia, MO, USA

In-Office Position

Category
Data Engineering
Data & Analytics
Required Skills
PowerShell
Microsoft Azure
Python
SQL
AWS
Data Analysis
Snowflake

You match the following Shelter Insurance's candidate preferences

Employers are more likely to interview you if you match these preferences:

Degree
Experience
Requirements
  • Bachelor's or Master's degree in computer science, information systems, or a related field.
  • Proven experience (4+ years) as a Senior Data Engineer, with expertise in Qlik Replicate, Compose, and Enterprise Engineer, 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.
Responsibilities
  • Design, implement, and maintain data pipelines, data integration solutions, and data architecture.
  • Ensure efficient and scalable data storage, processing, and analytics using Snowflake.

Shelter Insurance provides a range of insurance products, including auto, home, life, and business insurance, primarily in the Midwestern and Southern United States. The company operates through a network of over 1,400 professional insurance agents who offer personalized service to meet the unique needs of individual clients, families, and small to medium-sized businesses. Shelter Insurance's business model involves selling insurance policies, where customers pay a premium in exchange for financial protection against potential losses. The company generates revenue from these premiums and invests them to create additional income. What sets Shelter Insurance apart from its competitors is its focus on personalized service through dedicated agents and its commitment to comprehensive training for its employees. The goal of Shelter Insurance is to provide reliable coverage while effectively managing risk and remaining profitable.

Company Stage

N/A

Total Funding

N/A

Headquarters

Columbia, Missouri

Founded

1946

Simplify Jobs

Simplify's Take

What believers are saying

  • Adoption of telematics allows for personalized auto insurance premiums.
  • AI in claims processing reduces times and improves accuracy, enhancing satisfaction.
  • Bundled insurance products offer discounts and increase cross-selling opportunities.

What critics are saying

  • Increased competition from insurtech companies offering cost-effective solutions.
  • Rising natural disasters in the Midwest and South may increase claims.
  • Talent shortages could affect recruitment and retention of skilled agents.

What makes Shelter Insurance unique

  • Shelter Insurance offers personalized service through a network of 1,400 agents.
  • The company operates in 14 states, focusing on the Midwest and Southern U.S.
  • Shelter Insurance emphasizes comprehensive training for its agents and employees.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

Dental Insurance

Vision Insurance

401(k) Company Match

Paid Vacation

Unlimited Paid Time Off

Vitality Wellness Program

Flexible Work Hours

Bonus Opportunities