Lead Data Engineer

Role: Lead Data EngineerLocation: Chicago, IL (Locals Only)Experience: 10+ YearsJob Type: Contract/W2Duration: Long TermInterview: Video + Final In-Person InterviewWhat We Do NOT Want:Candidates without real-time Data Vault implementation experienceProfiles with only support/maintenance work and no hands-on developmentNo strong experience in Snowflake, SQL, Python/PySparkNo experience with Kafka/EventHub streamingCandidates lacking Azure data platform experience (ADF, ADLS, Databricks)No experience in query optimization/performance tuningOnly theoretical knowledge of DBT, Snowpipe, Tasks/TriggersNon-local candidates or candidates unwilling to attend in-person final interview in ChicagoLess hands-on coding, more managerial/coordination profilesCandidates without CI/CD automation exposureWeak understanding of Snowflake architecture concepts (Virtual Warehouse vs Serverless Compute)Required Skills:Strong experience with:Snowflake / SnowpipeSQLPython / PySparkHands-on experience in:Data EngineeringData Modeling techniquesData Vault implementation (real project experience required)Experience with:Kafka streamingAzure Event HubStreaming data pipelinesStrong Azure stack knowledge:ADLSADFDatabricksCI/CD automationKnowledge of:Snowflake Triggers & TasksVirtual Warehouse vs Serverless ComputeQuery OptimizationDBT and its advantages over other toolsResponsibilities:Lead development of Azure-based data platformsBuild and optimize scalable data pipelinesWork on real-time/streaming data solutionsImprove performance and query efficiencyLooking forward to qualified local submissions only. Thanks & RegardsNikhila Gujjarlamudingujjarlamudi@tror.aiLinkedIn: linkedin.com/in/nikhilagujjarlamudiWebsite: https://tror.aiAddress: 401 Ronan Way, Spring Hill, TN 37174