Data Engineer in St. Peters, Missouri at CarShield

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.

• 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

• 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
• Experience with C# or Python preferred
• 2+ years of experience with Business Intelligence (BI) tools preferred

Pay Rate and 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).
• And more!