SQL Data Engineer - Onsite in MO | ETL & Performance

KellyMitchell Group; Saint Peters (MO); On-site; USD 62,000 - 90,000; Full time

Benefits offered by this job

ESOP

401K

Onsite amenities

Job summary

KellyMitchell is seeking an experienced SQL Data Engineer in St. Peters, MO to design, develop, maintain, and optimize SQL Server databases and data pipelines. You will collaborate with Software Engineers and Data Scientists to ensure data is reliable and accessible for reporting and analytics.

The role is fully onsite five days per week with a direct hire. Qualified candidates have 4+ years of SQL Server experience, strong T-SQL skills, and a track record of query optimization and scalable data

Qualifications

• Bachelor's degree in Computer Science, MIS, or equivalent work experience.
• 4+ years of experience as a SQL Server Data Engineer.
• 2+ years of experience creating, managing, and monitoring data pipelines using ETL/ELT processes.
• Strong hands-on experience with Microsoft SQL Server, SQL, and Transact-SQL (T-SQL).
• Demonstrated experience creating, managing, and optimizing stored procedures.
• Deep understanding of database design, normalization, and relational database concepts.
• Good understanding of SQL Server Database Engine internals, including buffer pool, parallelism, execution plans, and indexing.
• Strong experience troubleshooting database issues and optimizing slow-running queries.
• Ability to work onsite in St. Peters, MO, five days per week.

Responsibilities

• Design new databases, enhance existing databases, and develop complex SQL queries and T-SQL stored procedures.
• Troubleshoot database issues, investigate tickets, identify root causes, document findings and implement fixes.
• Optimize slow-running queries through indexing, execution plans, and design improvements.
• Apply database design principles to build reliable and efficient data solutions.
• Analyze internals and performance to improve SQL Server efficiency.
• Design, build, monitor, and maintain data pipelines using ETL/ELT processes.
• Collaborate with Software Engineers and Data Scientists to improve data flow for reporting and analytics.
• Gather requirements and translate business needs into technical solutions.
• Monitor database health and performance and take action when systems fail.
• Ensure data is accurate, accessible, reliable, and structured for BI.
• Identify opportunities to improve database reliability, maintainability, performance, and operational efficiency.
• Maintain a positive, collaborative, and proactive approach to problem-solving and continuous learning.

Skills

SQL query optimization

Data troubleshooting

Analytical thinking

Onsite collaboration

Education

Bachelor's degree in CS / MIS

Tools

SQL Server

T-SQL

Stored procedures

ETL/ELT pipelines

Python

C# / .NET

Job description

KellyMitchell is seeking an experienced SQL Data Engineer in St. Peters, MO to design, develop, maintain, and optimize SQL Server databases and data pipelines. You will collaborate with Software Engineers and Data Scientists to ensure data is reliable and accessible for reporting and analytics.

The role is fully onsite five days per week with a direct hire. Qualified candidates have 4+ years of SQL Server experience, strong T-SQL skills, and a track record of query optimization and scalable data