Senior Data Engineer

 Position: Senior Data Engineer
 Location: Chicago, IL (Hybrid)
 Employment: Contract
 
 
 Job description:
We are looking for an experienced Data Engineer with strong expertise in MS SQL Server, Azure SQL, and Databricks. The candidate will be responsible for designing, developing, optimizing, and maintaining scalable database and cloud data solutions.

 Key Skills Required:
Strong hands-on experience in SQL Server and Azure SQL
Expertise in T-SQL, stored procedures, functions, views, and query optimization
Experience with Databricks, Apache Spark, Spark SQL, and PySpark
Knowledge of data warehousing, dimensional modeling, and Slowly Changing Dimensions (SCD)
Experience in ETL/ELT processes
Strong understanding of Azure cloud environment
Ability to troubleshoot production issues and guide junior team members
 
Responsibilities:
Develop and optimize complex SQL Server and Azure SQL databases
Improve database performance through tuning and indexing
Work on cloud-based data solutions using Azure and Databricks
Support data modeling, warehousing, and transformation processes
Collaborate with developers, BI teams, and stakeholders
Lead code reviews and maintain database development standards