Data Engineer Lead
Horizontal Talent
Chicago, IL, United States
6 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
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.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
EM
Eli McGarvie
about 3 years ago
BB
Benedikt Bischof
Making Data Warehouses Fast: A Developer’s Story
about 4 years ago
DS
Dhannush Subramani
Top Big Data Technologies That You Need to Know
about 4 years ago
EM
Eli McGarvie
Highest Paying Tech Companies for Developers
over 3 years ago
LM
Luis Minvielle
The Most Popular IT Jobs on the Market
over 2 years ago
EM
Eli McGarvie
Data Analyst Salary in the UK
about 3 years ago