Manager of Data Analytics and Engineering - PERM - Hybrid - Naperville, IL

Resource 1; Naperville (IL); On-site; USD 15,000 - 180,000; Full time

Job summary

A leading company in the Food and Beverage Services sector is seeking a Lead Data Engineer to work onsite in Naperville, IL. The ideal candidate will have extensive experience with AWS and a strong technical background, transitioning from a hands-on engineering role to management responsibilities. This position offers a competitive benefits package, including health insurance and a 10% annual bonus, alongside significant opportunities for career growth and influence over enterprise data strategy.

Benefits

Health insurance (medical, dental and vision)

401(k) plan with company match

10% annual bonus

3 weeks of vacation

Employee stock ownership plan (ESOP)

Qualifications

• 8+ years of database experience including Oracle, MySQL, SQL Server or Redshift.
• Strong hands-on AWS data engineering experience with Python, PySpark, Glue, Athena.
• Recent experience in people management.

Responsibilities

• Support data engineering team on architecture solutions and people management.
• Drive the development of digital products in the Data Engineering and Analytics arena.
• Maintain and innovate the design of data warehouse and architecture.

Skills

AWS

Python

SQL

Data Integrity

Data Quality

Data Analytics

Project Management

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Resource 1, Inc.

Resource 1 has an open permanent/ direct hire position for a Lead Data Engineer with our client in Naperville, IL. Will be expected to work onsite in Naperville on Tuesdays, Wednesdays and Thursdays, so candidates must be local to the Chicagoland area. Our client offers a very competitive benefits package, including health insurance (medical, dental and vision), 401(k), 10% annual bonus, 3 weeks of vacation and an employee stock ownership plan (ESOP). The ideal candidate would be someone who recently transitioned to a management responsibilities from a Lead Data Engineer position, retaining their hands-on skills with AWS, Python and SQL, while building upon their people management experience.

Selected individual will be responsible for supporting the data engineering team on architecture solutions, people management/ oversight and some hands-on engineering work as needed. Will drive the development of digital products and platforms in the Data Engineering and Analytics arena. Will serve as the customer proxy responsible for working with Product teams and other stakeholders. Will work independently and partner closely with leadership to optimize and redefine the product vision and feature opportunities. Will be responsible for maintaining and innovating the design of the data warehouse and data/ information architecture. This position provides strategic enterprise data technical vision (3-5 years out) while directing immediate tactical data architecture initiatives. Additionally, the position will ensure the overall quality of technology data implementations across multiple domains, including data management, data integration, data quality, data reporting and data analytics.

Primary Responsibilities:

• Own solution architecture and ensure best practices and internal processes are followed.
• Create standards and templates to streamline data pipelines and engineering processes.
• Lead engineering teams in delivery of products, working with product and stakeholders.
• Provide data flow diagrams and document source-to-target mapping.
• Manage the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations, etc.
• Develop analytical insights including data integrity, analysis, test design, validation, etc.
• Proactively promote data quality/ security through recommended approaches and practices.
• Keep current with data trends and technological innovations.
• Execute on POCs with new technologies and drive innovation and new ideas.
• Manage AWS cost optimization and control, including resource utilization analysis, budgeting and implementing strategies to reduce cloud expenditure.

Required Experience/ Qualifications:

• 8+ years using databases, including Oracle, MySQL, SQL Server or Redshift.
• Recent experience in people management.
• Strong AWS data engineering experience, with expertise in Python, PySpark, Glue, Athena, Lambdas and Step Functions.
• Data modeling (conceptual, logical and physical model design) and experience with operational data stores, enterprise data warehouses and data marts.
• Experience with BI and data warehousing design including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions, etc.).
• Knowledge of SQL, Python and microservice/ cloud architectures/ pipelines.
• Passionate about technology, hungry to learn, driven to succeed and excellent communication skills.

Preferred Experience:

• Some knowledge of RPA technologies (e.g., Power Automate, UI Path, Automation Anywhere, etc.).
• Experience with automation using but not limited to Java, C#, Python or PySpark.
• Any AI-related experience could be useful for upcoming projects.
• Experience in supply chain/ operations/ transportation/ distribution industries.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology, Management, and Engineering

• Industries

  Food and Beverage Services and Transportation, Logistics, Supply Chain and Storage

Referrals increase your chances of interviewing at Resource 1, Inc. by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Paid maternity leave

Child care support

Pension plan

Paid paternity leave

Student loan assistance

Disability insurance

Tuition assistance

Get notified about new Data Engineer jobs in Naperville, IL.

Brookfield, IL $15,000.00-$180,000.00 4 weeks ago

Senior Data Engineer (Remote or Hybrid Available)

Naperville, IL $120,000.00-$140,000.00 1 day ago

Oak Brook, IL $111,000.00-$152,000.00 6 days ago

Rosemont, IL $98,000.00-$132,000.00 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.