Data Engineer
Summary
Mid-level SQL Server Data Engineer on CarShield's Data Services team designing and tuning databases, writing T-SQL stored procedures, and building/monitoring ETL and ELT pipelines at scale.
CarShield is seeking a mid-level SQL Server Data Engineer to join its Data Services team. In this role, you will design and improve databases, develop reliable data solutions, optimize performance, and help maintain data flow from collection through reporting in an environment that handles data at scale.
In this role, you will:
- Design new databases and enhance existing database structures.
- Write SQL queries and Transact-SQL stored procedures to support business and technical requirements.
- Create, manage, and monitor data pipelines supporting ETL and ELT processes.
- Troubleshoot incoming issues, document root causes, and implement durable solutions.
- Improve database performance through query rewriting, indexing, and database design.
- Monitor database health and respond appropriately when systems or processes fail.
- Collaborate with software engineers and data scientists to improve data flow from collection through reporting.
- Gather, document, and implement requirements from business stakeholders.
- Continuously develop the technical knowledge and skills required for the role.
- Perform other duties as assigned.
Compensation and Benefits
- Salary commensurate with experience.
- Group insurance, including medical, dental, vision, and life coverage.
- 401(k) with employer match.
- Discounted CarShield policies.
- Discounted tuition at Lindenwood University.
- Professional development opportunities.
- On-site basketball and other recreation.
- On-site fitness facilities and classes led by a staff personal trainer at the St. Peters headquarters.