SQL Data Engineer

Job Description

Job Description

Apply now: SQL Data Engineer, location is Remote. The start date is ASAP for this permanent position.

Job Title: SQL Data Engineer
Location-Type: Remote (EST/CST Preferred)
Start Date Is: ASAP
Duration: Permanent
Compensation Range: $125,000 – $140,000 annually
Benefits: Eligible for Health, Dental, Vision, 401K, PTO
Must be authorized to work in the U.S. This position is not eligible for sponsorship .

Job Description:
The SQL Data Engineer will be responsible for investigating, remediating, migrating, and validating production data across enterprise-scale systems. This role focuses heavily on SQL Server, data migrations, ETL processes, XML data handling, and troubleshooting complex data integrity issues within mission-critical applications.

Day-to-Day Responsibilities:

• Investigate and resolve data integrity issues within large production databases.
• Write and execute complex SQL queries across highly relational data models.
• Develop validation scripts and reporting to identify impacted records and data anomalies.
• Design, test, and execute data correction and remediation scripts.
• Lead and support data migration initiatives, including schema mapping and transformation logic.
• Perform ETL activities, data mapping, and data quality validation.
• Analyze and reconstruct missing or corrupted data when necessary.
• Collaborate with Product, QA, DevOps, and Engineering teams to understand application data flows.
• Optimize database performance and troubleshoot production issues.
• Maintain migration runbooks, playbooks, and technical documentation.
• Participate in Agile ceremonies, code reviews, and deployment planning.

Minimum Requirements:

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
• 5 years of professional experience working with relational databases.
• Expert-level SQL Server experience.
• Advanced SQL skills including complex JOINs, CTEs, window functions, query optimization, and indexing strategies.
• Experience writing and executing safe bulk UPDATE, INSERT, and DELETE scripts in production environments.
• Proven experience with data migration projects, schema mapping, transformation logic, and validation processes.
• Experience working with XML data and querying XML within SQL environments.
• Strong ETL and data quality validation experience.
• Experience working with Git/GitHub and Jira.
• Familiarity with cloud platforms, preferably Azure.
• Ability to quickly learn and navigate large, unfamiliar database schemas.
• Strong troubleshooting and problem-solving skills.
• Self-starter capable of working independently with limited documentation and guidance.
• Strong attention to detail and commitment to data accuracy.

• Experience with data reconstruction and forensic data investigation.
• Experience within tax, government, financial services, or other regulated industries.
• Familiarity with Azure SQL Managed Instance.
• Exposure to VB.NET, ASP.NET, C#, Entity Framework, Dapper, or ADO.NET.
• Experience with SQL Server Reporting Services (SSRS).
• Experience supporting SaaS or hosted application environments.
• Understanding of CI/CD pipelines and deployment automation.