Data Engineering & Operations Lead
Shelter Insurance Companies · Greater Columbia, Missouri Area · 2 mo ago
Management$114k–$141k/yrFull-time
About the role
Responsible for architecture & design, implementation, and maintenance of data warehouse operations. Expertise in Snowflake, AWS and Qlik tools is required to ensure efficient and scalable data storage, processing, and analytics.
Responsibilities
- Architecture & design of data warehouse operations
- Implementation of data warehouse operations
- Maintenance of data warehouse operations
Qualifications
- Bachelor's or Master's degree in computer science, information systems, or a related field is preferred
- Proven experience (7+ years) as a Data Engineering Practitioner typically required
- Proficiency in Qlik Replicate, Compose, DBTLabs & Astronomer 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
- Knowledge of dbtLabs, Astronomer, Github is preferred
- 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 the essential functions of the position, with or without a reasonable accommodation
Benefits
- 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!