Data Engineer Job at CarShield, Saint Peters, MO

  • CarShield
  • Saint Peters, MO

Job Description

Job Description

Job Description

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.

Job Tags

Work at office

Similar Jobs

Prime Healthcare

Monitor Tech Job at Prime Healthcare

 ...Job TitleMonitor TechJob DescriptionThe Monitor Tech is an unlicensed person who performs indirect care in the department setting. Monitors cardiac rhythms via direct cardiac monitors. Facilitates the communication needs of the department. Transcribes physician orders... 

kozmetickesluzby.vecnakraska.sk - Jobboard

Marketing Intern at Burger King Orange, VA Job at kozmetickesluzby.vecnakraska.sk - Jobboard

Job SummaryWe are a local communitybased QSR looking to boost engagement at the store level with the community. We are seeking a motivated and creative Marketing Intern to join our dynamic team. This internship offers an excellent opportunity for students or recent graduates...

Constellis

Firefighter/EMT Job at Constellis

 ...Firefighter/EMT PositionThe Firefighter/EMT performs duties, in both emergency and non-emergency situations, related to fire protection, emergency medical services, rescue services, hazardous materials response, and emergency management delivery at the Radford Army Ammunition... 

ReFocus Eye Health

Ophthalmic Technician Job at ReFocus Eye Health

 ...accurate diagnoses and personalized treatment plans. Master ophthalmic testing: Conduct thorough preliminary examinations, including...  ...experience as an Ophthalmic Technician. Knowledge of medical office procedures. Ability to perform indirect activities,... 

FOX Rehabilitation

Speech Language Pathologist Job at FOX Rehabilitation

FOX Rehabilitation is seeking a compassionate Speech Language Pathologist to provide evidence-based geriatric rehabilitation services. In this role, you will evaluate, diagnose, and treat speech, language, cognitive-communication, and swallowing disorders in older adults...