Senior Engineer - Data Warehouse (Los Angeles) at sweetgreen

| Culver City
Sorry, this job was removed at 11:18 a.m. (PST) on Wednesday, September 9, 2020
Find out who's hiring in Los Angeles.
See all Data + Analytics jobs in Los Angeles
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Senior Data Warehouse Engineer

Who We Are

Sweetgreen is on a mission to build healthier communities by connecting people to real food. We passionately believe that real food should be convenient and accessible to everyone. Every day in each Sweetgreen restaurant, our 4,000+ team members make food from scratch, using fresh farm-to-table ingredients and produce delivered that morning. And in our local communities, we’re committed to leaving people better than we found them. We’re in the business of feeding people, and we’re out to change what that means. Our people are our most valuable ingredient - the heart of our company, the face of our brand, and what truly makes the Sweetgreen experience special and unique.

The Position

At Sweetgreen, our Senior Data Warehouse Engineer will play a crucial role in working with our Enterprise Data Warehouse Architect to build our next generation EDW in Snowflake.  They are our data warehouse gatekeeper and an advocate for data driven business decisions.  They will be working with business partners to help define this next generation EDW, identify and create efficient data models, as well as define and implement data pipelines from various sources, in order to ultimately provide the most comprehensive data reporting abilities, business intelligence and self-service analytics in order to drive the company’s success.

Top Goal - Deliver and continually improve upon the Sweetgreen nextgen EDW in Snowflake - including an updated data model, ELT ingest frameworks, and semantic/reporting layers for approximately five of Sweetgreen’s most critical data domains (e.g. sales, customer, inventory).  Additionally, they will play a significant role providing standards for managing data governance to maintain a clean and secure EDW.  To accomplish this, you will work with Business Intelligence and Technology teams to ensure the models for these data domains are finely calibrated for reporting and self-service analytics, while also iteratively delivering value over time.

Your Impact

  • Collaborate and Evaluate: Work with the lead data warehouse architect and data engineering manager to understand the current EDW model and ELT infrastructure,  so that you can actively contribute to the minimum viable product (MVP) for Sweetgreen’s nextgen EDW in Snowflake.  This includes continuing the work of recent positive improvements to the EDW, and working in tandem with the Business Intelligence team to migrate core reporting from decentralized data sources to a centrally managed reporting/semantic layer in Snowflake.
  • Empower Speed and Accuracy: You will collaborate to standardize ingest methods and data modeling practices, for both fast lane (less structured) and core (EDW) data, in order to empower both ad hoc self-service analytics as well as more structured business reporting.  Additionally, you will drive data governance standards and compliance to ensure data cleanliness and accuracy.  This will require defining multiple ELT/ETL paths with rationale for each based on complexity, data models, security, and prioritized reporting.
  • Drive Core EDW Standards and Practices: You will drive standards for your architectural designs and management practices for Sweetgreen’s nextgen EDW in Snowflake.  This plan includes DevOps and Cybersecurity approved Identity and Access Management practices, as well as the approach for decommissioning uncertified data in legacy data stores.
  • Enable Ongoing Monitoring and Administration: You will be actively managing all architecture decisions and delivery mechanisms for EDW updates and management.  This includes concepts such as setting up resource monitors, role-based access controls, virtual warehouse sizing, query performance tuning, zero copy cloning, and Snowflake time travel.  You will build and guide processes to support efficient data transformation, data structures, metadata/data dictionaries, and workload management.
  • Raise The Bar: At Sweetgreen, we dedicate a portion of our attention to matters that may not be immediately customer facing, but instead allow for us to work smarter, faster, or simply reduce friction in the analytics experience.  You ll work with the data architect to manage the EDW’ s specific backlog that is focused on operational excellence, and are expected to produce and evangelize this work across teams.

Your Accomplishments

  • Experience with modern data platforms (e.g.  AWS, Snowflake, SQL, Airflow, Python)
  • Experience with business analysis, statistical modeling, presenting insights via visualization tools (e.g. Tableau, Looker)
  • Demonstrated ability to troubleshoot and collaborate through constructive teamwork.
  • Knowledge and experience with AGILE methodology
  • Experience supporting retail or large scale restaurant operations is a HUGE plus, given our unique industry and customer engagement model
  • Not afraid to constructively provide new solutions to the team
  • Strong understanding of best practices relating to frontend architecture
  • A strong desire to experiment with technology and understand relating market trends
  • Strong problem solving, communication, and creative skills

Benefits

  • Three different medical plans to suit your and your family's needs
  • Dental and Vision insurance 
  • Flexible PTO plan
  • 401k; company match of 50% up to 3% of employee contribution
  • 5 months paid family leave; we believe in fully supporting new parents
  • Employee HSA and FSA
  • Complimentary greens
  • An opportunity to make a real impact on the people around you, both by growing them and by connecting them to real food
  • To live the sweetlife and celebrate your passion + purpose
  • A collaborative family of people who live our core values and have your back
  • A clear career path with opportunities for development, both personally and professionally
  • Free sweetgreen swag
Engineering Culture

At sweetgreen we are focused on building a great experience for our customers and we look to constantly enhance that through empowerment of our teams to build innovative solutions. We believe that it’s a mix of individual skill and collaboration that leads to successful outcomes. There is no standard definition of what an Engineer is or does, and depending on where you’re coming from things might look a little different.

Come join the sweetlife!

sweetgreen is on a mission to build healthier communities by connecting people to real food. We passionately believe that real food should be convenient and accessible to everyone. Every day in each sweetgreen restaurant, our 4,000+ team members make food from scratch, using fresh ingredients and produce delivered that morning. And in our local communities, we’re committed to leaving people better than we found them. We’re in the business of feeding people, and we’re out to change what that means. Our people are our most valuable ingredient - the heart of our company, the face of our brand, and what truly makes the sweetgreen experience special and unique.

sweetgreen provides equal opportunities for everyone that works for us and everyone that applies to join our team, without regard to sex or gender, gender identity, gender expression, age, race, religious creed, color, national origin, ancestry, pregnancy, physical or mental disability, medical condition, genetic information, marital status, sexual orientation, any service, past, present, or future, in the uniformed services of the United States (military or veteran status), or any other consideration protected by federal, state, or local law.

sweetgreen participates in the federal government's E-Verify program to determine employment eligibility. To learn more about the E-Verify program, please click here.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • GrailsLanguages
    • GraphQLLanguages
    • ReactLibraries
    • AngularJSFrameworks
    • DjangoFrameworks
    • Ember.jsFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks

Location

Our office is positioned in the centerpiece for LA's newest creative generation, PLATFORM and directly across the street from the Metro Station.

What are sweetgreen Perks + Benefits

sweetgreen Benefits Overview

sweetgreen is committed to offering a benefit package with flexibility and options to help you live your sweetlife. Our suite of benefits includes the core options of medical, dental, and vision as well as other voluntary benefit options to help you create the benefit package that best meets the needs of you and your family.

We believe that our employees are the most important ingredients in our restaurants and aim to support you throughout your journey at sweetgreen. FAMILY FUND

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 5 months of parental leave for the primary caretaker. We believe in fully supporting new parents.
Flexible Work Schedule
sweetgreen provides employees with a flexible work schedule that includes flexible start and end times. Do what you love on *and* off the clock.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Our employees Give back with 5 paid volunteering hours per year.
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
Fitness Subsidies
Sweetgreen has partnered with Classpass to offer a different kind of gym membership. All benefits-eligible employees receive a subsidy per month to use towards your membership.
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
sweetgreen hosts lunch and learn meetings once per month.
Cross functional training encouraged
Promote from within

Additional Perks + Benefits

FAMILY FUND

The family fund provides emergency financial aid to employees experiencing financial hardship caused by catastrophic events outside of your control, like a natural disaster or life altering personal crisis.

Every person in the sweetgreen family can elect to donate part of their paycheck to the family fund pool of money. This is the money that will be distributed to individuals who apply for funds that will help them cope with an unfortunate situation.

With your continued support, we can truly make an impact in the lives of our sweetgreen family members who are experiencing hardship.

More Jobs at sweetgreen22 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Project Mgmt
Content
HR
new
Culver City
Operations
new
Culver City
Content
new
Los Angeles
HR
new
Culver City
Finance
new
Culver City
Data + Analytics
new
Culver City
Operations
new
Culver City
Design + UX
new
Culver City
Operations
new
Culver City
Marketing
new
Culver City
HR
new
Culver City
Developer
new
Culver City
Operations
new
Culver City
Operations
new
Culver City
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView sweetgreen's full profileSee more sweetgreen jobs