Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Engineer

Everytable

Data Engineer

Los Angeles, CA
Full Time
Paid
  • Responsibilities

    Everytable is on a mission to transform the food system to make fresh, nutritious food affordable and accessible to everyone, everywhere. We are a VC-backed social enterprise headquartered in Los Angeles and laying the foundation for rapid national expansion.

    Our innovative business model has been featured in The New York Times, CNBC, Shark Tank, Fast Company, Forbes, etc. because it’s unlike any other food business. It all starts with our central kitchen where chefs prepare meals efficiently and allow us to price our menu according to what each community can afford. Our ready-to-eat meals are then delivered through a variety of channels: grab-and-go storefronts, home-delivered subscriptions, SmartFridge vending machines, and institutional food service partnerships. We’re passionate about making a positive impact in the communities we serve through food access, as well as economic empowerment. Through our pioneering social equity franchise program, we fund and train disenfranchised business people from marginalized communities to open Everytable franchises. We’re looking for team members who are both mission and results-driven to help us make the world a more equitable place.

    As Everytable's Data Engineer, you will build, operate, maintain, and extend our entire data infrastructure. Everytable is investing heavily in technology and this role will bridge venture funding rounds driving us toward our goal of an IPO. Your ability to think strategically yet maintain an attention to detail will enable you to identify and solve the most important technical and business problems as part of a very collaborative team. This is an opportunity to join an entrepreneurial team focused on making the world a healthier, more equitable place.

    ROLES AND RESPONSIBILITIES

    Data Architecture and Administration

    Identify internal and external data sources, collaborating with department heads to determine their data storage and organizational needs and using the information to create and maintain our data infrastructure

    Determining the requirements for a new database

    Publishing and presenting design reports

    Identifying areas for improvement in current systems

    Coordinating with other team members to reach project milestones and deadlines

    Auditing database regularly to maintain quality

    Creating systems to keep data secure

    Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using cloud and SQL technologies

    Data Engineering

    Manage and execute our existing data warehouse and data pipelines

    Assembling large, complex sets of data that meet non-functional and functional business requirements

    Working with stakeholders including the Executive, Product, Data and Operations teams to support their data infrastructure needs while assisting with data-related technical issues

    Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes

    Analytics Engineering

    Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition

    Provide clean, transformed data ready for analysis

    Apply software engineering best practices to analytics code (eg version control, testing, and continuous integration)

    Maintain data documentation and definitions

    Train business users on how to use data visualization tools

    Be asking the right questions:

    Is it possible to build a single table that allows us to answer this entire set of business questions?

    What is the clearest possible naming convention for tables in our warehouse?

    What if I could be notified of a problem in the data before a business user finds a broken chart?

    What do analysts or other business users need to understand about this table to be able to quickly use it?

    How can I improve the quality of my data as it's produced, rather than cleaning it downstream?

    KNOWLEDGE, SKILLS AND EXPERIENCE

    3-5 years experience

    SQL, spreadsheets, a programming language

    Azure SQL Server, Google BigQuery, GCP, JavaScript, Python (preferred)

    Airflow, Fivetran, Census, dbt Cloud, Github, PySpark, Kafka, Cloud functions, APIs (preferred)

    Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions

    Data warehousing and data analysis skills

    Strong communication and interpersonal skills

    Fresh food manufacturing or manufacturing experience is a plus!

    You have skills across the software stack, with the ability to step back, see the big picture, and propose bold ideas to help our company continue to grow and improve our services

    Benefits

    Competitive salary commensurate with experience

    Health, vision and dental benefits

    Paid time off

    401K retirement account

    Free delicious Everytable meals daily

    Complimentary coffee, tea, prepared foods, fresh fruit, and other healthy snacks

    Everytable is proud to be an equal opportunity workplace. We are committed to equal employment opportunities regardless of race, color, ancestry, religion, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We encourage women, people of color and LGBTQ people to apply. Everytable is a Fair Chance employer and will consider qualified applicants with arrest and/or conviction records for employment.

    In accordance with Everytable’s duty to provide and maintain a workplace that is free of known health and safety hazards , the Company has adopted a mandatory COVID-19 vaccination policy to safeguard the health of its employees and its customers. As such, the Company requires that all employees be fully vaccinated against COVID-19 upon hire. For the purposes of this policy, “fully vaccinated” shall mean two weeks have passed since: (i) applicant obtained their second dose in a 2-dose series, such as the Pfizer or Moderna vaccines; or (ii) applicant has obtained a single-dose vaccine, such as Johnson & Johnson’s Janssen vaccine. Applicants shall submit proof of vaccination either with their application or as part of their onboarding process

    In the event that an applicant requires a reasonable accommodation due to a disability or a sincerely held religious belief, the Company will evaluate applicant’s reasonable accommodation request and will provide an accommodation to the extent it can if the applicant is hired. Accommodations requests are evaluated by the Company on a case-by-case basis, and accommodations will only be granted to those the Company determines are eligible for such.