A company built to serve you. It's your career, Shelter it!
Senior Data Architect
$127,330 - $157,889 / 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:
Design and implement the organization's data architecture to ensure efficient data management, data integration, and data governance. Play a critical role in defining and implementing a scalable and robust data infrastructure that supports the company's analytical and operational needs.
This position requires expertise in data modeling, database design, and a deep understanding of data management principles.
What We're Looking For:
- Bachelor's or master's degree in computer science, information systems, or a related field is preferred.
- Proven experience (10+ years) as a Data Architect or a similar role, with a focus on data architecture design and implementation typically required.
- Strong understanding of data modeling techniques, database design principles, and data management best practices.
- Proficiency in Snowflake, dbtLabs, Astronomer, Qlik Replicate and Relto is desired.
- Advanced Proficiency in data modeling tools and languages, such as ERwin, ER/Studio, SQL, and NoSQL databases.
- Experience with data integration technologies, such as ETL/ELT tools and data integration platforms.
- Knowledge of data governance principles, data quality management, and data lifecycle management.
- Strong understanding with cloud-based data platforms and technologies, such as AWS, Azure, or Google Cloud.
- Understanding of data security and privacy regulations, such as GDPR and CCPA.
- Excellent problem-solving and analytical skills, with the ability to design scalable and robust data architectures.
- Strong communication and collaboration skills, with the ability to work effectively with technical and non-technical stakeholders.
- 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:
09/17/2026Skills Required
- Bachelor's or master's degree in computer science, information systems, or a related field
- 10+ years of experience as a Data Architect or in a similar role focused on data architecture design and implementation
- Strong understanding of data modeling techniques, database design principles, and data management best practices
- Proficiency in Snowflake, dbtLabs, Astronomer, Qlik Replicate, and Relto
- Advanced proficiency in data modeling tools and languages, including ERwin, ER/Studio, SQL, and NoSQL databases
- Experience with data integration technologies, including ETL/ELT tools and data integration platforms
- Knowledge of data governance, data quality management, and data lifecycle management
- Strong understanding of cloud-based data platforms and technologies, such as AWS, Azure, or Google Cloud
- Understanding of data security and privacy regulations, including GDPR and CCPA
- Excellent problem-solving and analytical skills
- Strong communication and collaboration skills with technical and non-technical stakeholders
- Ability to perform essential job functions with or without reasonable accommodation
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.
