SQL Server Developer / Data Engineer

SQL Server Developer / Data Engineer​​​​​​​ (Hybrid)
Oakbrook, IL: 3 days a week (ON-SITE)
Length: 6month contract
Rate: $60.00-65.00/HR w2

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:

1. 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.
2. 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.
3. 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.

1. 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.
2. Develop automated processes for data validation, error handling, auditing, and monitoring.
3. Troubleshoot and resolve production data integration and workflow issues.