Senior Data Engineer

Connect Search is working with a large manufacturer who is seeking multiple AWS Data Engineers with strong Python, Pandas, SQL, and ETL pipeline development experience. The ideal candidate will have a proven background building scalable data pipelines, performing complex data transformations, and working with large datasets in AWS cloud environments.

Key Responsibilities & Requirements

• Strong hands-on Python development experience, specifically using Pandas and DataFrames for data manipulation and transformation.
• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Experience with AWS cloud services such as S3, Lambda, Glue, and EC2.
• Strong SQL skills for querying, joining, and transforming large datasets.
• Develop data processing solutions involving data cleansing, validation, aggregation, and integration.
• Optimize Python and Pandas code for performance and efficiency.
• Troubleshoot and maintain production data pipelines.
• Collaborate with engineering teams to deliver reliable, high-quality data solutions.

Ideal Candidate

A true hands-on Python Data Engineer who has extensive experience writing Pandas-based transformations, working with DataFrames, and developing end-to-end ETL pipelines in AWS.

Must be able to work onsite in downtown Chicago 2 days per week.

For eligible employees, we offer medical, dental, and vision coverage as well as a 401(k) plan.”