Senior Data Architect

Shelter Insurance Companies; New York (NY); On-site; USD 127,000 - 158,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

PTO

Wellness program

Dress code

Flexible scheduling

Job summary

Shelter Insurance Companies 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. This role focuses on scalable, robust data infrastructure to support analytics and operations.

Candidates should have a 10+ year track record in data architecture, strong data modeling skills, and expertise with Snowflake, dbtLabs, and ETL/ELT tools.

Qualifications

• 10+ years of experience in data architecture design and implementation.
• Strong data modeling and database design skills.
• Experience with cloud-based data platforms (AWS/Azure/GCP).
• Familiarity with data governance, data quality and lifecycle management.
• Proficiency with ETL/ELT tools and data integration.
• Excellent communication with technical and non-technical stakeholders.

Responsibilities

• Design and implement the organization's data architecture.
• Ensure efficient data management, integration, and governance.
• Define scalable, robust data infrastructure to support analytics and operations.

Skills

Data architecture

Data modeling

ETL/ELT tools

SQL

NoSQL

Data governance

Data security

Cloud platforms

Stakeholder comms

Data quality

Education

Bachelor's degree

Tools

Snowflake

dbtLabs

Astronomer

Qlik Replicate

Relto

Job description

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!