SQL Server Developer / Data Engineer

ZealHire Inc.; Villa Park (IL); Hybrid; USD 110,000 - 150,000; Full time

Job summary

ZealHire Inc. is seeking an experienced SQL Server Developer / Data Engineer to design, develop, and support enterprise data solutions. The role focuses on SQL Server objects, ETL/ELT pipelines, data warehousing, and data integration, with exposure to Azure and Databricks.

The position offers hybrid work (Oakbrook, IL) with 3 days onsite. Strong T-SQL, data warehousing, and cloud experience are highly valued. Collaboration with business and technical teams is essential.

Qualifications

• Design, develop, and optimize SQL Server database objects (stored procedures, views, functions, triggers, and T-SQL).
• Design, develop, and maintain ETL/ELT processes and data integration pipelines.
• Experience with Databricks, Spark SQL, Delta Lake and Azure is preferred.
• PowerShell scripting and automation is preferred.
• SQL Server administration, security, backup/recovery, and maintenance is preferred.
• Develop automated data validation, error handling, auditing, and monitoring.
• Salary range is not shown on the candidate portal.

Responsibilities

• Design, develop, maintain, and optimize SQL Server database objects.
• Design, develop, and maintain ETL/ELT processes and data ingestion pipelines.
• Develop automated data validation, error handling, auditing, and monitoring.
• Troubleshoot and resolve production data integration and workflow issues.
• Collaborate with business and technical stakeholders to deliver reliable, scalable data solutions.

Skills

T-SQL development

Data modeling

Query optimization

Team collaboration

Tools

Azure Databricks

Azure DevOps

PowerShell

Spark SQL

Delta Lake

MS Azure

Job description

SQL Server Developer / Data Engineer | JPC-9076

Work permits accepted: US Citizen - Greencard Holder

Location: Oakbrook, IL 60523 (Hybrid - 3 days a week onsite) – local candidates

Interview: Video

Overview:
We are seeking an experienced SQL Server Developer / Data Engineer to design, develop, and support enterprise data solutions that drive business operations and reporting. This role will be responsible for SQL Server database development, ETL/ELT processes, data warehouse initiatives, and data integration solutions. The ideal candidate will have strong expertise in T‑SQL development, enterprise data warehousing, and data engineering practices, with exposure to modern cloud technologies such as Azure and Databricks.
This position will also provide secondary support for SQL Server administration activities, contribute to performance optimization efforts, and collaborate closely with business and technical stakeholders to deliver reliable, scalable, and high-quality data solutions.

Requirements:

A. Design, develop, maintain, and optimize SQL Server database objects including stored procedures, views, functions, triggers, and advanced T‑SQL solutions.

• Develop complex queries and implement database solutions that support operational and analytical business requirements.
• Perform query tuning, index optimization, schema refinement, and performance troubleshooting.

B. Design, develop, and maintain ETL/ELT processes supporting enterprise data integration and transformation initiatives.

• Build and support data ingestion pipelines, incremental load processes, reconciliation routines, and data quality frameworks.
• Support database code deployment, version control, and release management processes using Azure DevOps or similar tools.

C. Data Integration & ETL/ELT Development including experience with :

• SQL Server performance tuning, indexes, index management, and optimization is preferred.
• Databricks, Spark SQL, Delta Lake, and modern cloud data platforms is preferred.
• PowerShell scripting and automation is preferred.
• SQL Server administration, security, backup/recovery, and maintenance is preferred.
• MS Azure is preferred.

D. Design, develop, and maintain ETL/ELT processes supporting enterprise data integration and transformation initiatives.

• Build and support data ingestion pipelines, incremental load processes, reconciliation routines, and data quality frameworks.

E. Develop automated processes for data validation, error handling, auditing, and monitoring.

F. Troubleshoot and resolve production data integration and workflow issues.

Salary Range:

$000,000 – $000,000 Salary range is not shown on the candidate portal