Comprehensive Resources Inc.

Comprehensive Resources Inc.

Data Engineer

Chicago, Illinois, USA · full-time, part-time, third party, contract

Sponsorship not specifiedDetected 41 days ago
Code ReviewSQLDatabricksAzureSparkData EngineeringLeadershipCommunicationCollaborationProblem SolvingMentoring

About the role

  • Role: Data Engineer Location: Chicago, IL (3days onsite) Experience: Min. 10+ Years Client Interview - in-person in Chicago, IL. Must be strong on Complex sql queries and Databricks Seeking a Senior Data Engineer with deep expertise in SQL Server, Azure SQL, and Databricks to design, optimize, and deliver scalable cloud-based data solutions supporting
  • analytics and enterprise data platforms Roles and Responsibilities - Database Development & Optimization: Design, develop, 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 strategies, and performance optimization for large-scale

Responsibilities

  • Design, develop, 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 strategies, and performance optimization for large-scale datasets.
  • Implement best practices for database security, data integrity, and reliability.
  • Design and maintain relational and dimensional data models.
  • Implement Slowly Changing Dimensions (SCD) and other data warehousing patterns.
  • Support ETL/ELT processes and collaborate with data engineering teams.

Requirements

  • Engineering Degree - BE/ME/BTech/MTech/BSc/MSc.
  • 10+ Years Client Interview - in-person in Chicago, IL.
  • Engineering Degree

Skills

  • Integrate Azure SQL with Databricks using Delta Lake, Spark SQL, and PySpark/SQL where applicable.
  • Support cloud-based data architectures and hybrid data environments.
  • Provide guidance and mentoring to junior developers.
  • Participate in code reviews and enforce database development standards.
  • Troubleshoot production issues and provide root cause analysis
Apply directly at Comprehensive Resources Inc. →Create a free account for alerts like thisView Comprehensive Resources Inc. immigration profile

This listing is sourced directly from Comprehensive Resources Inc.'s careers page and normalized into a canonical job model.