Data Engineer

CarShield; Missouri; On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Group Insurance (Medical, Dental, Vision, Life)

401k with Employer Match

Discounted CarShield policies

Discounted Tuition at Lindenwood University

Professional development opportunities

On-site recreation including basketball

Fitness facilities with classes

Job summary

CarShield in St. Peters, MO is looking for a mid-level SQL Server Data Engineer. The role involves designing databases, troubleshooting issues, and enhancing performance. Candidates should have a Bachelor's degree in Computer Science and 4+ years of relevant experience.

Desirable skills include SQL, C# or Python, and familiarity with Business Intelligence tools. The position offers benefits such as medical insurance, professional development opportunities, and on-site fitness facilities.

Qualifications

• 4+ years experience as a SQL Server Data Engineer.
• Deep understanding of SQL, database design, and normalization.
• 2+ years of experience in ETL/ELT data pipelines.
• Experience with Business Intelligence tools is a plus.

Responsibilities

• Design new databases and write SQL queries.
• Troubleshoot and implement solutions for database issues.
• Performance tune slow queries and improve database design.
• Collaborate with Software Engineers and Data Scientists.

Skills

SQL

Database Design

Data Pipeline Management

C# or Python

Business Intelligence tools

Education

Bachelor's degree in Computer Science or equivalent experience

Job description

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 and 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!