Senior Data Architect — Build Scalable Data Infrastructure

Shelter Insurance; Columbia Township (MO); On-site; USD 127,000 - 158,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) Savings and Profit Sharing

Paid Time Off

Wellness program

Dress for Your Day

Flexible Scheduling

Job summary

Shelter Insurance in Columbia, Missouri is seeking a Senior Data Architect to design and implement the organization's data architecture, ensuring efficient data management, integration, and governance.

The ideal candidate will have 10+ years of data architecture experience, strong data modeling and database design skills, and proficiency with Snowflake, dbtLabs, Astronomer, and related tools, plus cloud platforms and data security knowledge.

Qualifications

• Bachelor's or master's degree in computer science, information systems, or a related field preferred.
• Proven experience (10+ years) as a Data Architect or similar role with focus on 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 is desired.
• Advanced proficiency in data modeling tools and languages (ERwin, ER/Studio, SQL, NoSQL).
• Experience with ETL/ELT data integration tools and platforms.
• Knowledge of data governance, data quality, and data lifecycle management.
• Understanding of cloud-based data platforms (AWS, Azure, GCP).
• Knowledge of GDPR and CCPA data privacy regulations.
• Excellent problem-solving and collaboration skills to work with stakeholders.

Responsibilities

• Design and implement the organization's data architecture for efficient data management, integration, and governance.
• Define a scalable and robust data infrastructure supporting analytical and operational needs.
• Apply data modeling, database design, and data management best practices across environments.

Skills

Data architecture

Data modeling

Database design

Cloud platforms

Data governance

ETL/ELT

Data security

Education

Bachelor's or master's degree in computer science, information systems, or a related field

Tools

Snowflake

dbtLabs

Astronomer

Qlik Replicate

Relto

Job description

Shelter Insurance in Columbia, Missouri is seeking a Senior Data Architect to design and implement the organization's data architecture, ensuring efficient data management, integration, and governance.

The ideal candidate will have 10+ years of data architecture experience, strong data modeling and database design skills, and proficiency with Snowflake, dbtLabs, Astronomer, and related tools, plus cloud platforms and data security knowledge.