Deerfield, ILremote

Salary
$160,555–$193,000from the description
Posted
Jul 7, 2026
Location
Deerfield, IL
Last confirmed open
Jul 21, 2026

What this job asks for AI summary

A senior data engineering role focused on administering a cloud data warehouse (such as Snowflake), designing scalable data architectures, and building and maintaining ETL/ELT pipelines. The work involves SQL and Python development, data transformation frameworks like dbt, CI/CD implementation, cost monitoring, and integrating data from APIs, SaaS platforms, and ERP systems. Suited to experienced data engineers with a strong background in cloud platforms and data operations.

Senior level · 5+ years · Remote · Bachelor's required · Full-time

Must have (9)
ETL/ELT pipelines · 5+ yrsSQL · 5+ yrsPython · 5+ yrsGit · 5+ yrsSnowflake, Redshift or BigQuery · 5+ yrsdbt · 5+ yrsCI/CD · 5+ yrsOracle or SapUnix

“or” means any one of them counts — you don't need all of them.

Posted 2 times — it's one opening, so apply once.

We read this from the posting text with AI. Skim the description below before ruling yourself out.

How this req sits in the market our data

Roughly 2,200 people nationally plausibly meet what this posting asks for (database architects). range 910–3,900

Applicant volume Moderate — A normal amount of company. The rare requirements below are what will separate a shortlisted application from the rest.

What won't set you apart
SQL90%Python55%CI/CD45%Unix45%Snowflake42%Oracle42%

Most people in this occupation already list these. Still required — just not what gets you shortlisted.

What the occupation pays Median $142,568 (middle half $111,775–$173,013). This posting is about at that midpoint.

Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Jul 28, 2026. It is a model, not a headcount.

Why we read it this way (8)

The title is 'Lead Data Engineer' but the posting carries no explicit seniority level word (Junior/Mid/Senior/Staff/Principal) in the title itself, so the title states no level; the 5-year requirement and scope (architecture design, cost governance, platform administration) support a Senior classification.

SOC is a close call between 15-1243 (Database Architects — pipeline/warehouse building, data modeling, dbt) and 15-1252 (Software Developers — Python, CI/CD, code-quality practices). The role's primary emphasis on cloud data warehouse administration, data architecture, and transformation modeling tips it to 15-1243, but 15-1252 is a credible runner-up.

The cloud data warehouse requirement names Snowflake, Amazon Redshift, and Google BigQuery as interchangeable options; Snowflake is listed first and is also called out separately in the job description narrative, so it is used as the primary skill name with the others as alternatives.

The ERP/API data loading requirement names Oracle and SAP as examples; these are treated as interchangeable alternatives for that single requirement.

All skills listed are drawn from the explicit 'Qualifications' / 'must also have' section and are therefore hard gates. The 5-year figure applies to each named requirement as stated ('5 years of experience in each of the following').

The caller has declared this a fully-remote, national-pool role; no metro is inferred despite the Deerfield, IL office address in the posting.

Ignored 1 non-technology phrase(s) as skills (responsibilities/concepts, not named tools): cloud cost optimization.

Caller marked this a fully-remote role — scored against the national candidate pool.

Read the full posting

The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.

Apply

Apply on employer site ↗