Data Engineer

CarShield • St. Peters, MO

5d • Onsite

About The Position

We are seeking a mid-level SQL Server Data Engineer who understands the intricacies of handling data at scale. These are some of the duties you will be expected to perform.

Requirements

• Must be able to work in-office in St. Peters, MO, 5 days a week (this position is fully on-site)
• Bachelor's degree in Computer Science, MIS or equivalent work experience
• 4+ years of experience as a SQL Server Data Engineer
• Deep understanding of SQL, database design, normalization
• Good understanding of Database Engine internals such as buffer pool, parallelism, execution plans, indexing
• 2+ years of experience creating, managing and monitoring data pipelines (ETL/ELT)
• Positive attitude, with a strong desire to learn and excel

Nice To Haves

• Experience with C# or Python preferred
• 2+ years of experience with Business Intelligence (BI) tools preferred

Responsibilities

• Design new databases, enhance existing ones, write SQL queries and Transact-SQL (T-SQL) stored procedures
• Troubleshoot issues when tickets come in, find/document and implement elegant solutions
• Performance tune slow queries by re-writing, indexing and improving database design
• Work closely with Software Engineers and Data Scientists to improve data flow from collection to reporting
• Gather requirements from stakeholders when needed, document and implement them
• Maintain a positive, can-do attitude and a strong desire to learn and excel
• Monitor our databases, and take action when any system fails
• Learn new skills required for your job

Benefits

• Salary commensurate with experience
• Group Insurance (Medical, Dental, Vision, Life, etc.)
• 401k with Employer Match
• Discounted CarShield policies
• Discounted Tuition at Lindenwood University
• Professional development opportunities
• Basketball, and other recreation available on-site
• Fitness facilities, with the option to take classes led by on-staff personal trainer (at St. Peters headquarters)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level