Posted 14h ago

Data Engineer

@ CarShield
St. Peters, Missouri, United States
OnsiteFull Time
Responsibilities:designing databases, troubleshooting issues, performance tuning
Requirements Summary:Onsite in St. Peters, MO 5 days/week. Bachelor's in CS/MIS or equivalent, 4+ years as a SQL Server Data Engineer, deep SQL and database design knowledge, 2+ years ETL/ELT pipeline experience; C# or Python and BI experience preferred.
Technical Tools Mentioned:SQL Server, Transact-SQL (T-SQL), C#, Python
Save
Mark Applied
Hide Job
Report & Hide
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/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!