Analytics Engineer II New Chicago, IL

Home Chef; Chicago, Northern (IL, KY); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, vision, life and disa

401k program

Paid holidays, sick time and vacation

Flexible spending accounts

Promo code PEOPLE30 for first order

Job summary

Home Chef in Chicago seeks a Level 2 Analytics Engineer to lead end-to-end data projects, align with a business department, and serve as a subject matter expert within the analytics team.

You will transform business requests into data pipelines, maintain a data warehouse, and enable self-serve reporting with Looker while guiding teammates on data quality and governance.

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 to create 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, gotchas, etc.
• Communicate progress and gather feedback on projects with the business.

Skills

SQL

Python

Data modeling

ETL/Transformations

Stakeholder communication

Problem solving

Code organization

Education

Four-year degree

Tools

Looker

Job description

Founded in 2013, Home Chef is the leading meal solutions company with both a retail and online presence. Available online athomechef.com and in retail at more than 2,100 Kroger grocery stores, Home Chef is committed to inspiring and enabling more people to cook simple, delicious meals, no matter how busy they are.

In 2023, Home Chef introduced a new brand, Tempo ! Tempo features a rotating selection of ready-to-heat meals delivered directly to your door. These meals are better-for-you versions of familiar favorites, designed to save you time and reduce stress while maintaining a healthy lifestyle. Our Tempo menu includes options that are protein-packed, fiber-rich, calorie and carb conscious, keto-friendly, and dietitian-approved.

Similar to our recipes, we recognize that variety is the spice of life, and therefore, our employees also bring their uniqueness and color to our fantastic team. We're eager to work with humble team players and pragmatic next-level thinkers to innovate on Home Chef's offerings.

The Analytics Engineer leads technical work and projects which enable Home Chef to make more and better data-driven decisions. With the broader team, the engineer is responsible for the creation and maintenance of the end-to-end data "value chain." This encompasses capturing the correct data, designing a data model that fits the needs of our data consumers, and building analytics on top of that data.

The Level 2 Analytics Engineer will align with a certain business department to understand the needs of that department. This role is considered a subject matter expert for that department within the analytics team. The Level 2 Analytics Engineer independently leads much of the work for that department and provides guidance to others who pick up that work as well.

Detailed Responsibilities

Technical:

• Convert business requests to code and frameworks
• Build ingestion, cleaning, and transformation jobs to create 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

Responsibility Area: Non-Technical

• 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, gotchas, etc.
• Communicate progress and gather feedback on projects with the business

This position requires 0% travel.

Qualifications

The requirements listed below are representative of the knowledge, skill, ability, and/or other characteristics needed for this role. Reasonable accommodations may be made to enable individuals with disabilities.

• 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.

More About Us

Perks and benefits

• Candidates can experience Home Chef as a customer - enter promo code PEOPLE30 for $30 off your first order!
• Medical, dental, vision, life and disability insurance available
• Paid holidays, sick time and vacation time
• 401k program
• Flexible spending accounts for qualified medical, dependent care, parking, or transit expenses

How We Work Together

We are humble team players.
We are warm and gracious with team members and customers. We seek feedback to improve ourselves - and respectfully listen to and accept input.

We are pragmatic next-level thinkers.
We come up with novel and unique ideas. We explore new strategies to avoid being constrained by conventional thinking.

We take ownership.
We approach ambiguous problems, prepared to dive in, get curious, and learn more. We are results-driven, always challenging ourselves to exceed goals.

We all show up authentically at Home Chef. Our team includes individuals with a variety of identities, backgrounds, and perspectives. You can trust that you'll be able to bring your whole self to an inclusive and enjoyable workplace.

We welcome people of all races, colors, religions, national origin or ancestry, sex (including sexual identity), age, physical or mental disabilities, pregnancy, veteran or military status, unfavorable discharge from military service, genetic information, sexual orientation, marital status, order of protection status, citizenship status, arrest record or expunged/sealed convictions, or any other legally recognized protected basis under federal, state, or local law.

Home Chef is committed to the full inclusion of all qualified individuals. As part of this commitment, Home Chef will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, or to receive other benefits and privileges of employment, please contact our People team [e-mail] .

Home Chef offers the base salary range as posted below, with the exact offer depending on factors such as geographic location, experience, skills, and internal equity. While compensation is within the provided range, it is not typical for offers to be made at the upper end. In addition to base salary, Home Chef provides a comprehensive benefits package, including healthcare coverage, 401k match, and paid time off.