Hybrid SQL Server Data Engineer | Azure & Databricks

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

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.