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. 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

Requirements

• Must be able to work in-office in St. Peters, MO, 5 days a week
• 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 databases
• 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