Databricks Engineer || Chicago,IL

Job Summary (List Format)

• Serve as a Senior Data Engineer, designing and delivering scalable cloud-based data solutions.
• Develop, optimize, and maintain complex SQL Server and Azure SQL databases.
• Write and optimize advanced T-SQL queries, stored procedures, functions, and views.
• Perform query tuning, indexing, and performance optimization on large datasets.
• Ensure database security, integrity, and reliability using best practices.
• Build and manage data solutions in Azure SQL Database and Databricks (Apache Spark).
• Support data transformations, analytics, and large-scale processing using Databricks, Spark SQL, Delta Lake, and PySpark/SQL.
• Design and maintain relational and dimensional data models for data warehousing.
• Implement data warehousing patterns such as Slowly Changing Dimensions (SCD).
• Support ETL/ELT processes and collaborate with data engineering and BI teams.
• Partner with stakeholders to gather and understand data requirements.
• Mentor junior developers, conduct code reviews, and enforce database standards.
• Troubleshoot production issues and perform root cause analysis.
• Work in Azure cloud and hybrid data environments.
• Require 10+ years of experience in database development and related roles.
• Must possess strong skills in SQL Server, Azure SQL, T-SQL, Databricks, Apache Spark, and data warehousing concepts.
• Strong analytical, problem-solving, and communication skills required.
• Engineering degree and technical certifications are desirable.