Description
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 (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!