What are the responsibilities and job description for the Senior Data Engineer - Chicago, IL position at TechniPros, LLC?
Role: Senior Data Engineer
Location: Chicago, IL (Hybrid)
Long term Contract
Can do Only W2, No C2C
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.
Best Regards:
Tina
Phone:
Email: