Imperfect Foods was founded in 2015 with a mission to reduce food waste and build a better food system for everyone. We offer imperfect (yet delicious) produce, affordable pantry items, and quality meat and dairy. We deliver them conveniently to our customers’ doorsteps and pride ourselves on offering up to a 30% discount compared to grocery store prices. Our customers can get the healthy, seasonal produce they want alongside the grocery staples they rely on, without having to compromise their budget or values. We’re proving that doing the right thing for the planet doesn’t have to cost more, and that shopping for quality ingredients can support the people and resources that it takes to grow our favorite foods.

We're headquartered in San Francisco with operations all over the country. Check our website to see if there is an Imperfect near you!

We're looking for folks who are positive, motivated, and ready to change the world. If that sounds like you, drop us a line!

Imperfect is looking for an experienced Data Engineer to join our Business Intelligence team. Primary responsibilities will include the development, maintenance, and operational stability of scalable, resilient data pipelines and infrastructure. You’ll design and optimize data flows to be consumed by distributed systems, reporting, analytics, and machine learning. You'll architect solutions that enable robust and scalable data access and analysis, as our data volume and needs continue to grow at a rapid pace. You’ll develop sophisticated, accurate, and elegantly designed data models and support complex analyses. This role will involve taking business and technical requirements from concept and development through to the production environment. You’ll be enabling our fast-growing company to make better decisions, helping to deliver an ideal customer experience, and fighting food waste within our food system.

Responsibilities:

• Design, develop, and own ETL pipelines that deliver data with measurable quality and accuracy, allowing Imperfect to extract more insights from existing data and take advantage of new sources
• Write production-quality (i.e., accurate, performant, and maintainable) data transformation code to meet the needs of analysts, data scientists, and other business partners
• Support data analytics platforms and data science workflows, along with identifying ways to strengthen and scale our data infrastructure with Imperfect’s fast-paced growth, including exploring alternative data management and pipeline tools
• Design and maintain the architecture and organizational structure of our data warehouse, and keep it tidy by establishing and implementing a strategy for managing roles and permissions, monitoring usage, and cleaning up old objects
• Ensure quality of deliverables using development testing methods, documentation, code reviews, and user acceptance testing, and implement effective data tests and monitoring to ensure accuracy and reliability of data and ELT pipelines
• Work with stakeholders throughout the organization to understand and identify data needs and opportunities for utilizing data to drive business solutions, translating business requirements into efficient and well-documented data models to empower data-informed development

Skills & Qualifications:

• 4+ years of relevant experience in data analytics or engineering related field
• Experience working with sophisticated data problems, developing and implementing data strategy, and building high-quality end-to-end data solutions in an agile environment from requirements to production
• Fluency in SQL (CTEs, window functions, query optimization) and Python (numpy, pandas, airflow, pyspark, PEP8)
• Experience with and understanding of data modeling concepts and best practices, and writing production-quality ETL data transformation code with an eye towards performance, maintainability, and scalability (especially in dbt)
• Experience with data replication platforms (Stitch, Fivetran), cloud data warehouse technologies (Snowflake), job scheduling platforms (Dagster, Airflow), and deploying and maintaining data infrastructure in the cloud (Docker, AWS)
• Familiarity with data science acumen and common machine learning algorithms and an eagerness to continue to explore implementation
• Ability to communicate clearly about data to both technical and non-technical audiences
• Passion for structure, organization, and efficiency, down to the details (e.g. maintaining consistent naming conventions and coding style)

About You:

• You are a champion for data and data accuracy
• You’re just as comfortable debugging and working deep in technical minutia as you are conveying technical concepts to non-technical business partners
• You’re a self-starter with the ability to balance multiple projects at once and deliver end-to-end projects independently
• You’re excited to join a fast-paced startup environment
• You're passionate about our mission to eliminate food waste, and create a better food system for all

Details of the Position:

• Full-time, exempt position reports to the Director of Business Intelligence and is available immediately
• Candidate can be remotely located within the US
• Salary and stock options commensurate with experience
• Competitive benefits package including health care, paid vacation, 401K, paid parental leave, and recurring credit towards your Imperfect account

Physical Requirements:

• Sedentary work; involves sitting most of the time
• Occasional movement around the office may be necessary
• Regular work with computers, including keyboards, mouses, and screens
• Regular use of mobile devices, including smartphones and tablets

Individuals seeking employment at Imperfect Foods are considered without regard to race, color, religion, national origin, age, gender, marital status, ancestry, physical or mental disability, veteran status, or sexual orientation.

U.S. E-Verify Notice: Imperfect Foods participates in E-Verify in the United States. Imperfect will provide the U.S. Social Security Administration (SSA) and, if necessary, the U.S. Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization.

At Imperfect Foods, employee health and safety is our top priority. We have implemented processes and precautions to prevent the spread of COVID-19 in our facilities. We provide gloves, masks, and hand sanitizer to all essential employees who must report to work. Before entering our warehouse, employees have their temperatures checked. In addition, we take great care to ensure frequently touched surfaces are sanitized throughout the day and all warehouses are fully sanitized weekly.

We have also implemented an Emergency Sick Leave policy providing full-time and part-time employees 2 additional weeks of paid time off and up to 26 weeks paid leave if they have a confirmed case of COVID-19.