Senior Data Warehouse Engineer at

| Santa Monica
!Sorry, this job was removed at 12:58 p.m. (PST) on Wednesday, October 23, 2019
Apply now
Who You Are

You are a Senior DW Engineer who dreams data. You will hit the ground running on day one but will be humble enough to learn, too. You will work with hundreds of millions of records and be able to organize and make it easily available for consumption. You are a regular Van Gogh when it comes to data. Our DW Engineers work very closely with Product, Engineering, and Marketing to figure out ways to acquire new users, retain existing users, and optimize the all around user experience for our customers. You will be working with the latest technology available and use your experience to influence product decisions for our customers.

What You’ll Do
  • Manage data warehouse plans for a product vertical or a group of products
  • Design, build and launch new data models in our data warehouse
  • Design, build and launch new data extraction, transformation and loading processes in our data warehouse.
  • Build data expertise and own data quality for allocated areas of ownership
  • Interface with engineers, product managers and product analysts to understand Fair’s data needs
  • Create and implement a Master Data Management strategy to ensure data quality, data governance and provide a single source-of-truth for data analysis
  • Partner with business functions to define and implement business metrics and KPI
What You Have
  • 4+ years experience in the data warehouse space (Snowflake, Redshift, Big Query).
  • 4+ years experience with schema design and dimensional data modeling.
  • 4+ years experience in writing SQL statements.
  • 4+ years experience in custom ETL design, implementation and maintenance (Airflow, Luigi, DigDag).
  • Experience with Python (Pandas, Numpy)
  • Experience with BI Tools (Tableau, Looker, Mode)
  • Communication skills including the ability to identify and communicate data driven insights.
  • Ability to analyze data to identify deliverables, gaps and inconsistencies.
What You'll Get:
  • 100% coverage of medical, dental & vision benefits for employees AND their families
  • Equity incentives (it’s only Fair that we are all owners of the company)
  • Unlimited vacation package
  • Daily catered lunch and fully stocked kitchen
  • Cellphone reimbursement
  • 401(k)
  • Green commuter benefits (1 block from Light rail)
  • Paid parking
  • Employee referrals rewards
  • Diverse & inclusive culture
  • Leadership & mentorship programs
  • Discount on Fair cars
Read Full Job Description
Apply now

Technology we use

  • Engineering
    • GolangLanguages
    • JavaLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • SwiftLanguages
    • ReactLibraries
    • FlaskFrameworks
    • Ruby on RailsFrameworks
    • TensorFlowFrameworks
    • PostgreSQLDatabases


1500 feet to the Santa Monica Pier. 1000 feet to the Downtown Santa Monica Metro stop. Views of the ocean (if you're standing in the right spot).

What are Perks + Benefits Benefits Overview

Our name pretty much says it all. It’s our culture. It’s the way we treat our customers, our network of dealers and our fast-growing family of employees. We believe in hard work, and we believe hard work should be rewarded. That’s why we offer equity incentives, 100% coverage of medical, vision and dental premiums for employees and their families, 100% paid parental leave for 4 months, cellphone reimbursement, 401(k) retirement plans and free lunch 5 days a week for every employee. The way we see it, better to be more than fair than not to live up to our name.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
100% coverage for employees, including their spouse/domestic partner and children.
Vision Benefits
100% coverage for our employees, including their spouse/domestic partner and children.
Health Insurance Benefits
100% coverage for our employees, including their spouse/domestic partner and children.
Wellness Programs
Santa Monica employees receive a 20% discount at neighboring yoga studio.
Retirement & Stock Options Benefits
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
We offer unlimited PTO for regular, full-time employees.
Generous PTO
We offer 3 weeks vacation for hourly, full-time employees.
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Free Daily Meals
Fair offers delicious, healthy catered lunches Monday through Friday. Our menus are vegan and vegetarian-friendly!
Game Room
Stocked Kitchen
Happy Hours
Relocation Assistance
Relocation assistance offered depending on the role.
Professional Development Benefits
Job Training & Conferences

Additional Perks + Benefits

Underground employee parking. Outdoor patio space for lunching al fresco.

More Jobs at Fair.com6 open jobs
All Jobs
Dev + Engineer
Santa Monica
Santa Monica
Santa Monica
Santa Monica
Santa Monica
Santa Monica
Apply now
Save jobView's full profileSee more jobs