A company built to serve you. It's your career, Shelter it!
Business Data 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.
What You Will Be Doing:
Extract, analyze, and interpret complex data sets to generate valuable insights and support data-driven decision-making. Collaborating with cross-functional teams, play a crucial role in providing actionable insights and recommendations that drive business growth and operational efficiency.
What We're Looking For:
- Bachelor's or Master's degree in a quantitative field such as mathematics, statistics, economics, computer science, or a related discipline is preferred.
- Proven experience (4+ years) as a Data Analyst or Insurance Business Analyst or a similar role, with a focus on analyzing complex data sets and providing actionable insights typically required.
- Strong proficiency in SQL for data extraction and manipulation.
- Experience with data analysis and visualization tools such as Tableau, Power BI, Qlik, or similar tools.
- Proficiency in statistical analysis and modeling techniques, such as regression analysis, time series analysis, clustering, or classification.
- Familiarity with programming languages such as Python or R for data analysis and scripting.
- Knowledge of data warehousing concepts and data modeling principles.
- Excellent problem-solving and critical-thinking skills, with the ability to analyze complex problems and derive practical solutions.
- Strong attention to detail and ability to work with large and complex data sets.
- Effective communication skills, with the ability to present complex findings and insights to both technical and non-technical stakeholders
- Expertise with insurance industry practices and metrics, in one or more areas (underwriting, claims, agencies, sales, actuarial, financial operations)
- Experience with Github, dbtLabs is desired.
- Experience with Data Catalog & lineage tool is desired.
- Ability to perform 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:
07/20/2026Skills Required
- Bachelor's or Master's degree in a quantitative field (preferred)
- Proven experience (4+ years) as a Data Analyst, Insurance Business Analyst, or similar role
- Strong proficiency in SQL for data extraction and manipulation
- Experience with data analysis and visualization tools such as Tableau, Power BI, or Qlik
- Proficiency in statistical analysis and modeling techniques (regression, time series, clustering, classification)
- Familiarity with programming languages for data analysis such as Python or R
- Knowledge of data warehousing concepts and data modeling principles
- Excellent problem-solving and critical-thinking skills
- Strong attention to detail and ability to work with large, complex data sets
- Effective communication skills for presenting findings to technical and non-technical stakeholders
- Expertise with insurance industry practices and metrics (underwriting, claims, agencies, sales, actuarial, financial operations)
- Experience with GitHub and dbtLabs
- Experience with Data Catalog and lineage tools
What We Do
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 15 states— Arkansas, Colorado, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Mississippi, Missouri, Nebraska, Nevada, 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.
