Lead Data Engineer

Tror AI for everyone
Chicago, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 130K

Job location

Chicago, United States of America

Tech stack

Azure
Cloud Computing
Continuous Integration
Information Engineering
Data Vault Modeling
Python
Performance Tuning
Query Optimization
Azure
Standard Sql
Salesforce
SQL Databases
Data Streaming
Azure
Snowflake
PySpark
Real Time Data
Kafka
Data Management
Data Pipelines
Serverless Computing
Databricks

Job description

  • Lead development of Azure-based data platforms
  • Build and optimize scalable data pipelines
  • Work on real-time/streaming data solutions
  • Improve performance and query efficiency

Requirements

  • Candidates without real-time Data Vault implementation experience
  • Profiles with only support/maintenance work and no hands-on development
  • No strong experience in Snowflake, SQL, Python/PySpark
  • No experience with Kafka/EventHub streaming
  • Candidates lacking Azure data platform experience (ADF, ADLS, Databricks)
  • No experience in query optimization/performance tuning
  • Only theoretical knowledge of DBT, Snowpipe, Tasks/Triggers
  • Non-local candidates or candidates unwilling to attend in-person final interview in Chicago
  • Less hands-on coding, more managerial/coordination profiles
  • Candidates without CI/CD automation exposure
  • Weak understanding of Snowflake architecture concepts (Virtual Warehouse vs Serverless Compute)

Required Skills:

  • Strong experience with:

  • Snowflake / Snowpipe

  • SQL

  • Python / PySpark

  • Hands-on experience in:

  • Data Engineering

  • Data Modeling techniques

  • Data Vault implementation (real project experience required)

  • Experience with:

  • Kafka streaming

  • Azure Event Hub

  • Streaming data pipelines

  • Strong Azure stack knowledge:

  • ADLS

  • ADF

  • Databricks

  • CI/CD automation

  • Knowledge of:

  • Snowflake Triggers & Tasks

  • Virtual Warehouse vs Serverless Compute

  • Query Optimization

  • DBT and its advantages over other tools

About the company

Leidos + Chicago, IL + $92,300-166,850 per year Description About Leidos Leidos is a Fortune 500 company aimed at embracing and solving some of the world's most pressing challenges. Through science and technology, Get fam…, © 2026 Careerjet All rights reserved

Apply for this position