Data Engineer

Carshieldcareers; Saint Peters, Northern (MO, KY); Hybrid; USD 90.000 - 120.000; Vollzeit

Benefits dieser Stelle

Medical, dental, vision

401(k) with employer match

Tuition discount Lindenwood University

Professional development

On-site fitness facilities

On-site recreation

Zusammenfassung

CarShield is seeking a mid-level SQL Server Data Engineer to join its Data Services team in St. Peters, MO. The role focuses on designing and optimizing databases, building reliable data solutions, and ensuring data flows from collection to reporting at scale.

You will design databases, write T-SQL, and maintain ETL/ELT pipelines while collaborating with engineers and data scientists. On-site at the St. Peters headquarters, a strong drive to learn and excel is expected.

Qualifikationen

• Four+ years of experience as a SQL Server Data Engineer.
• Strong understanding of SQL, database design, normalization, and internals.
• Experience creating, managing, and monitoring ETL/ELT pipelines.
• Experience with BI tools is a plus.

Aufgaben

• Design new databases and enhance existing structures.
• Write SQL/T-SQL queries and stored procedures to support needs.
• Create, monitor, and optimize data pipelines (ETL/ELT).
• Troubleshoot issues, document causes, and implement durable solutions.
• Improve performance via indexing, design improvements, and query rewriting.
• Monitor database health and respond to failures.
• Collaborate with software engineers and data scientists to optimize data flow.
• Gather, document, and implement stakeholder requirements.
• Continuously develop technical knowledge for the role.

Kenntnisse

SQL

Data modeling

ETL/ELT

Performance tuning

C# or Python

BI tools

Ausbildung

Bachelor's degree in Computer Science or MIS

Tools

SQL Server

Jobbeschreibung

Description

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.

Requirements

• Ability to work fully on-site at CarShield's St. Peters, Missouri, office five days per week.
• Bachelor's degree in Computer Science or Management Information Systems, or equivalent practical experience.
• At least four years of experience as a SQL Server Data Engineer.
• Deep understanding of SQL, database design, and normalization.
• Strong understanding of database engine internals, including buffer pools, parallelism, execution plans, and indexing.
• At least two years of experience creating, managing, and monitoring ETL or ELT data pipelines.
• Positive, proactive attitude and strong desire to learn and excel.
• Experience with C# or Python preferred.
• At least two years of experience with business intelligence tools preferred.