Analytics Engineer II: Data-Driven Insights

Home Chef; Chicago (IL); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision, life and 장애?—

Disability insurance

Paid holidays, sick time and vacation

401k program

Flexible spending accounts

Job summary

Home Chef is seeking an Analytics Engineer II in Illinois to lead the end-to-end data value chain and align with the analytics team. This role designs data models and oversees data capture, quality, and delivery to support data-driven decisions.

You will build ingestion, cleaning, and transformation jobs for a robust data warehouse, monitor performance, and enable self-serve reporting with Looker while collaborating with stakeholders.

Qualifications

• Completion of a four-year degree program in a related field.
• Multiple years of experience with data modeling and database performance.
• Ability to build complex data transformations and understanding to discern when that is needed.
• Can effectively problem-solve and get to the root cause when troubleshooting issues.
• Ability to influence business stakeholders to help drive more data-driven decision making throughout the company.
• Highly organized both in terms of work management and written code.
• Highly proficient in SQL.
• Skilled in Python.
• Openness to utilize AI tools in day-to-day work. Some experience in the area preferred.

Responsibilities

• Convert business requests to code and frameworks.
• Build ingestion, cleaning, and transformation jobs for a useful integrated data warehouse.
• Regularly monitor and maintain the performance of these jobs.
• Create processes to ensure data quality and cleanliness throughout the pipeline.
• Utilize business intelligence tools (such as Looker) to provide business teams with more self-serve reporting and visualization.
• Support non-technical teams with more advanced analytics as necessary.
• Productionalize manual data processes as necessary.
• Engage with stakeholders to truly understand the needs of the departments.
• Ensure business teams can effectively utilize the data model and are aware of trade-offs.

Skills

SQL

Python

Data modeling

ETL / data transformation

BI tools

Troubleshooting

Stakeholder communication

Organization

AI tools

Education

Four-year degree

Tools

Looker

Job description

Home Chef is seeking an Analytics Engineer II in Illinois to lead the end-to-end data value chain and align with the analytics team. This role designs data models and oversees data capture, quality, and delivery to support data-driven decisions.

You will build ingestion, cleaning, and transformation jobs for a robust data warehouse, monitor performance, and enable self-serve reporting with Looker while collaborating with stakeholders.