Data Engineer Lead

Horizontal Talent
Chicago, IL, United States
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$106,080.0 - $185,120.0
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Cloud Database Profiling Data Discovery Information Engineering Data Infrastructure Data Integration Extract Transform Load (ETL) Data Structures Data Systems Document-Oriented Databases Python (Programming Language)
+12 more
NoSQL Performance Tuning SQL Databases Enterprise Data Management Cloud Platform System Azure Data Factory Data Lakes Pyspark AWS Glue Data Management Data Pipelines Databricks

Job description

  • Inventory priority source systems, data entities, identifiers, fields, relationships, and known data quality concerns.
  • Review source documentation, sample data structures, field inventories, and SME input to understand the current data landscape.
  • Assess data completeness, duplicates, freshness, conflicts, availability, lineage, and source reliability.
  • Support source-to-target mapping for a canonical marketing data model.
  • Translate identity rules, survivorship logic, source hierarchy, field ownership, account matching, and exception handling into engineering-ready inputs.
  • Document data gaps, dependencies, assumptions, risks, and open questions for the internal engineering team.
  • Help define acceptance criteria, data quality thresholds, and match-confidence considerations for the final handoff package.
  • Partner with strategy and architecture stakeholders to ensure outputs are actionable and ready for Databricks implementation.

Requirements

  • 5+ years of experience in data engineering, data platforms, or a related field.
  • Strong background in data discovery, profiling, mapping, and engineering handoff work.
  • Hands-on experience with Python and PySpark.
  • Strong Databricks experience.
  • Experience with SQL and NoSQL databases.
  • Experience working in enterprise data environments.
  • Knowledge of ETL/ELT processes, data integration, and data modeling.
  • Hands-on experience with AWS or another major cloud platform.
  • Strong analytical, problem-solving, and communication skills.

Preferred Skills

  • Experience with cloud data tools such as AWS Glue or Azure Data Factory.
  • Familiarity with modern data architecture principles, including data lakes or data mesh.
  • Exposure to governance, security, and compliance practices in data environments.
  • Experience with performance optimization and scalable data solutions.
  • Certifications in cloud data technologies are a plus.
  • Ability to work collaboratively in a hybrid, fast-moving environment.

Benefits & conditions

Please apply through this online posting or by visiting our Job Board at Applications will be accepted for 4 weeks. For those that join the team, we offer competitive compensation and benefits including medical, dental, vision, and retirement. Check out all we have to offer and how you can become part of the Horizontal Talent Team. The pay range for this role is $51 - $89 per hour based on qualifications and experience.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

55 sec

Validating data processing architectures via containerized events

Modood Alvi · WWC 2025

4:32 min

Harnessing Spark with Python using PySpark and Py4J

Ayon Roy · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:37 min

Scaling machine learning pipelines from prototypes to petabytes

Julian Joseph · LIVE

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all