Data Engineer Job at CarShield, Missouri

dkpOOXhLY0xMa2l5VWRjbUZsdHc3dWVFcWc9PQ==
  • CarShield
  • Missouri

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.

PIfb26775104a9-30492-41446585

Job Tags

Work at office

Similar Jobs

Aerotek

Packaging Operator Job at Aerotek

 ...Job Description Job Description Packaging Operator Position, Start immediately, $22/hr - $23/hr, weekly pay Description: Effectively operate production lines and maintain change parts and tooling in base condition. Support the setup of production lines... 

Ping Identity

Senior Technical Writer Job at Ping Identity

 ...businesses think about cybersecurity, digital experiences, and identity and access management. We're looking for a Senior Technical Writer to join our extraordinary documentation team at Ping Identity. Reporting to one of the Technical Documentation Managers, you'... 

The VAM Group

Search Engine Answer Engine Optimization Specialist Job at The VAM Group

 ...offsite, and technical SEO, along with Answer Engine Optimization (AEO) and Generative Engine...  ...help our clients get discovered through search engines and AI-powered answers, then turn...  ...profiles and assess link quality.* Manage local listings and business profile consistency... 

surveymonkey

Search Engine Optimization Manager Job at surveymonkey

 ...experience to employee engagement, market research to payment and...  ...for As a leader in organic search and discovery, you will drive...  ...Strategy: Work alongside Manager of Growth Marketing to integrate...  .... Partner with technical and engineering teams to ensure all web properties... 

Coloplast A/S

Medical Records Specialist Job at Coloplast A/S

 ...Comfort Medical, a wholly owned subsidiary of Coloplast, has an exciting opportunity for Medical Records Specialist to join our growing team! This role is responsible for interacting...  ...by collecting pertinent and relevant information about customers, and uploading leads...