Data Engineer

Carshieldcareers; Saint Peters (MO); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical Insurance

Dental Vision Life

401k with Match

Tuition Discount

Professional Development

On-site Fitness

On-site Recreation

Job summary

Carshieldcareers is seeking a mid-level SQL Server Data Engineer to design databases, write SQL/T-SQL, and optimize data pipelines for scale. This onsite role in Saint Peters, MO collaborates with software engineers and data scientists to improve data flow from collection to reporting.

You will troubleshoot issues, tune performance, and document requirements. A BS in CS or MIS and 4+ years of SQL Server experience are required; C# or Python and Power BI experience are preferred.

Qualifications

• 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.
• Knowledge of buffer pool, parallelism, execution plans, indexing.
• 2+ years experience creating, managing and monitoring data pipelines (ETL/ELT).
• Experience with C# or Python preferred.
• 2+ years experience with BI tools preferred.

Responsibilities

• Design new databases and write SQL/T-SQL stored procedures.
• Troubleshoot tickets and implement elegant solutions.
• Tune slow queries with indexing and better design.
• Collaborate with software engineers and data scientists on data flow from collection to reporting.
• Gather requirements from stakeholders and document them.
• Maintain a positive attitude and eagerness to learn.
• Monitor databases and take action when systems fail.
• Learn new skills required for the job.

Skills

SQL Server

T-SQL

Data modeling

ETL/ELT pipelines

Python

C#

BI tools

Education

Bachelor's degree in CS/MIS

Tools

SSMS

Power BI

Job description

Overview

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.

Responsibilities

• 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

Qualifications

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