Analytics Engineer II

Overview In this role you will drive data-driven decisions by building and maintaining the end-to-end data value chain. You align with a business department to act as a subject matter expert and lead key analytics initiatives. You will transform data requests into scalable pipelines, optimize data models, and empower teams with self-serve insights. This position offers the opportunity to shape Home Chef's data capabilities at scale and work closely with cross-functional partners. Compensation / BenefitsMedical, dental, vision, life and disability insurancePaid holidays, sick time and vacation time401k programFlexible spending accounts ResponsibilitiesTranslate business requests into code and frameworksDevelop and maintain data ingestion, cleaning, and transformation pipelines for a data warehouseMonitor performance and ensure data quality throughout the pipelineLeverage Looker for self-serve reporting and visualizationSupport non-technical teams with advanced analytics as neededOperationalize manual data processes when requiredEngage with stakeholders to understand department needs and communicate progressEnsure the data model is usable and explain trade-offs to business partners Key requirementsDegree in a related field with several years of experience in data modeling and database performanceStrong SQL proficiencyProficiency in PythonExperience building complex data transformationsAbility to troubleshoot and root-cause issues effectivelyAbility to influence stakeholders to drive data-driven decisionsHighly organized in work management and code qualityOpenness to using AI tools in daily work (some experience preferred)Stakeholder influenceStrong communicationProblem solving / root-cause analysisSQLPythonData modeling