Senior Enterprise Data Engineer
Shelter Insurance Companies · Greater Columbia, Missouri Area · 1 mo ago
Information Technology$91k–$112k/yrFull-time
Responsibilities
- Design, implement, and maintain data pipelines, data integration solutions, and data architecture using Qlik Replicate, Compose, and DBTLabs.
- Ensure efficient and scalable data storage, processing, and analytics with expertise in Snowflake.
- Work with Astronomer, Airflow, and Github for data integration, replication, and transformation.
- Apply strong understanding of data engineering principles, data modeling, ETL processes, and data warehousing concepts.
- Focus on Snowflake data ingestion, storage, performance optimization, and security.
- Utilize cloud platforms (AWS or Azure) and cloud‑based data solutions.
- Ensure data quality, governance, and lifecycle management practices.
- Manipulate and automate data using SQL and scripting languages (Python, PowerShell).
- Diagnose and resolve data engineering issues; communicate and collaborate with cross‑functional teams.
Requirements
- Bachelor’s or Master’s degree in computer science, information systems, or a related field (preferred).
- 3+ years of proven experience as a Data Engineer.
- Expertise in Qlik Replicate, Compose, and DBTLabs, with hands‑on experience in Snowflake.
- Proficiency in Astronomer, Airflow, and Github for data integration/replication/transformation.
- Strong grasp of data engineering principles, data modeling, ETL, and data warehousing.
- Experience with cloud platforms (AWS/Azure) and cloud‑based data solutions.
- Familiarity with data quality, governance, and lifecycle management.
- Solid SQL and scripting (Python, PowerShell) skills.
- Problem‑solving, troubleshooting, and excellent communication abilities.
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!
Pay
The starting base pay range is $90,646 – $112,382 per year. Shelter maintains broad salary ranges to account for geographic location, education, training, skills, relevant work experience, business needs, and market demands. This range reflects starting base pay only and does not include other components of the total rewards package.
Schedule
On‑Site, Full‑Time position located in Columbia, Missouri.