Staff Data Engineer, Analytics Platform

Afresh is on a mission to eliminate food waste and make fresh food accessible to all. Our first A.I.-powered solution optimizes ordering, forecasting, and store operations for fresh food departments in brick-and-mortar grocers. With our Fresh Operating System, regional and national grocery retailers have placed $1.6 billion in produce orders across the US and we've helped our partners prevent 34 million pounds of food from going to waste. Working at Afresh represents a one-of-a-kind opportunity to have massive social impact at scale by leveraging uncommonly impactful software – we hope you'll join us!

About the Role:

The goal of our analytics architecture is to allow teams across Afresh to read and write meaningful, consistent, and reliable metrics derived from our disparate data sources, and to use those metrics to track internal performance, power new reporting products, drive decision-making through experimentation, and alert on significant changes in performance.

In the next 6 months, we are releasing new products that build on top of our analytics architecture, namely a customer-facing product for reporting insights that will help our customers drive down food waste. As we venture into building more customer-facing products that leverage analytics insight, we’re looking to strengthen our analytics platform foundation.

The Data Science team sits under the larger Prediction, Optimization, and Planning (POP) team at Afresh. You will regularly interact with data engineers, applied scientists, data scientists, full stack engineers, and product managers in the course of your work.

As a staff data engineer on the Data Science team, you will own the ongoing development of our analytics platform. In this role, you will evolve our data warehouse schema, solidify our transform architecture, and establish data governance patterns to serve our internal and external analytics needs. Some of your responsibilities will include:

1. Improve and extend our data analytics architecture to enable consistent analytic results and easy access across multiple analytics use cases.
2. Collaborate with engineers, product managers, and data scientists to understand their data needs, and then build extensible dimensional models and semantic layer metrics that allow for consistent and reliable insights.
3. Evolve our existing data quality and data governance processes.
4. Mentor and up-skill other engineers.

This is a high-impact role with ownership of highly visible projects and a lot of room to grow in your scope.

Skills and Experience:

1. 6+ years of experience as a data engineer, analytics engineer, data warehouse engineer, or a similar role.
2. Strong understanding of advanced concepts in SQL.
3. Exceptional communication and leadership skills, with a proven ability to facilitate cross-team and cross-functional collaboration and information sharing.
4. 1+ years of experience working with SQL-driven transform libraries that support an ELT paradigm, like dbt or sqlmesh, at scale, including setting up CI/CD pipelines that ensure high quality transformations.
5. Expert knowledge about the differences between OLTP and OLAP database design.
6. Familiarity with the differences between data engineering concepts like Data Mesh, Data Lake, Data Warehouse, Data Fabric, and Data Lakehouse.
7. Experience with setting up a semantic layer defined with code (LookML, Cube.dev, AtScale, dbt semantic layer).
8. Technologies: SQL, Python, Airflow, dbt, Snowflake/Databricks/BigQuery, Spark.

About Afresh

Founded in 2017, Afresh is working on the #1 solution to curb climate change: reducing food waste. By combining human insight and transformative technology, we're helping grocers provide fresher food to customers at more affordable prices.

Afresh sits at an incredible intersection of positive social impact, rocket ship financial growth, and cutting-edge technology. Our best-in-class AI research has been published in top journals including ICML, and we've raised over $148 million in funding from investors including former co-CEO of Whole Foods Market Walter Robb and Eric Schmidt's Innovation Endeavors.

Fresh is the past, present, and future of our food system – the waste we create today will impact our planet for years to come. Join us as we continue to build a vibrant, diverse, and inclusive team that embodies our company’s values of proactivity, kindness, candor, and humility.

Afresh provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, sexual orientation, gender identity/expression, marital status, pregnancy or related condition, or any other basis protected by law.

Here at Afresh, many of our employees work remotely provided that they reside in one of the following states: AR, CA, CO, FL, GA, IL, KY, MA, MI, MT, MO, NV, NJ, NY, NC, OR, PA, TX, WA, WI. However, there may be key roles that will require a candidate/employee to be local to our San Francisco, CA office. In which case this requirement will be included in the job posting details under "Skills and experience" for reference.