Analytics Engineer II

Home Chef • Chicago, IL

3d • Onsite

About The Position

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 Analytics Engineer II 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 Analytics Engineer II independently leads much of the work for that department and provides guidance to others who pick up that work as well.

Requirements

• 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

Nice To Haves

• Some experience in the area preferred.
• Openness to utilize AI tools in day-to-day work.

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level