Senior BI Engineer at FabFitFun, Inc.

| Greater LA Area
Sorry, this job was removed at 11:37 a.m. (PST) on Tuesday, July 16, 2019
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.

FabFitFun is dominating the women's lifestyle marketplace through our curated subscription boxes, FFF branded products including makeup and accessories, as well as a video streaming platform featuring live and licensed content. Our 1 Million+ members provide us with a significant amount of valuable data that allows us to anticipate their needs, and curate our products, content and services to create personalized experiences. To keep up with the rapid pace of our business growth, we are scaling our Engineering, Product, Data Science and BI Teams to keep up with this hyper growth. Accordingly, we are seeking a Senior BI Engineer, reporting into our Business Intelligence Architect, to be at the core of our BI team, implement BI frameworks, and analyze the business impact of various initiatives in partnership with Data Engineering, Engineering, DevOps, and Business teams.

What We’re Like:

  • A collaborative learning culture: we work as a team to figure out solutions to the technological challenges of the day
  • We focus on improving our customer’s experience every day, all the while taking the time necessary to make sure we do things the best we can
  • We celebrate innovation and want every member at FFF to have the power to experiment and find novel, effective solutions

What You'll Do:

  • Perform requirements gathering and thoroughly analyze the requirements. In-depth dive analysis of business requirements and existing reporting solutions to maintain a reusable and shareable BI platform.
  • Develop and maintain various reports, dashboards, and visualizations in Looker and other reporting tools.
  • Design and develop practical solutions for complex reporting needs. Apply data modeling techniques and standard practices to implement BI self-service and automated reporting.
  • Write, understand and debug complex SQL statements. Understand and analyze data using SQL and identify the data discrepancies and performance bottlenecks.
  • Work with various department stakeholders to assist and resolve reporting issues. Apply debugging and problem-solving skills to address the data issues and document the process quickly. Fine tune the reports and dashboards for performance.
  • Heavily involved in reporting programming quality and delivery integrity by paying attention to solution planning, follow-ups, thoroughness, and details.
  • Develop and maintain advanced analytic models and processes.
  • Train internal & business teams on Looker and other reporting tool features. Prepare training materials. Ensure proper data and tool usage among multiple groups.
  • Develop a knowledge base by documenting the business processes, requirements, analyses, data workflow, and training materials.
  • Proactively build a scalable BI reporting solution that drives data discovery self-service and more profound data insights.
  • Build and continue to refine back end schema layer to tie all the data structures from different brands and departments to provide a single view of data.
  • Continually participate in improving reporting architecture, data quality, standardization of data management processes and quality of service to the business.

What You'll Bring:

  • BS computer science, Information Technology or related discipline.
  • 5+ years of experience in developing complex reporting solutions on enterprise BI reporting platforms like MicroStrategy, Looker, Cognos, Business Objects, Tableau, etc.
  • 5+ years of proven success in delivering impactful insights & data visualization using Looker or other BI reporting tools including Tableau, Pentaho, or MicroStrategy.
  • 5+ years of experience with relational databases (MySQL, Oracle, etc.), cloud data platform (Redshift) or similar MPP databases like Snowflake, Teradata, etc.
  • Expert in understanding and writing SQL queries, and analyzing multiple data sets quickly.
  • A self-starter with little guidance on development activities. Able to understand and elaborate the one-liner business requirements and proactively follow-up on requirements.
  • Experienced in documenting and articulating the findings, analyses, and processes effectively using different collaboration tools.
  • Should be an excellent communicator, and should possess excellent debugging skills and problem-solving skills.
  • Understanding of e-commerce or subscription business models. Experience in handling financial and marketing reports.
    • Experience working with Python, R & similar tools for data mining is a plus!

What You'll Get:

  • Daily impact on one of the fastest growing companies in the US that are revolutionizing e-commerce
  • Assist in helping FabFitFun achieve personalization through data science and analytics
  • Full health-care coverage as well as dental and vision coverage and 401k
  • Flexible PTO and generous holiday schedule
  • Catered meals, kitchen stocked with great snacks and drinks
  • Free FabFitFun subscription and and quarterly credit in the Add-Ons store
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
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • MySQLDatabases
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • AsanaManagement
    • WrikeManagement
    • SalesforceCRM
    • IterableEmail


In the heart of West Hollywood! Close to many staples of the LA area including The Beverly Center, The Grove and popular restaurants and bars.
Out of the Box: How Subscription Box Service FabFitFun Experiments to Innovate

An Insider's view of FabFitFun, Inc.

How would you describe the company’s work-life balance?

After being at this company for a few years, balancing work and life has never been a concern for me. Between the flexibility to work from home when necessary, to traveling the world, this company always encourages a balance. I really appreciate that I never have to put my life on pause -- it’s a freedom that makes this company so wonderful.


Customer Acquisition Specialist

How has your career grown since starting at the company?

My career has grown tremendously since joining FabFitFun in 2015! I started as a Jr. Account Manager, and have worked my way up to Director, Strategic Merchandising! FabFitFun helped me to not only switch teams, but also encouraged me to take courses on any skills that I wanted to improve for my new position.


Director, Strategic Merchandising

How do you make yourself accessible to the rest of the team?

I believe in casually connecting with my team on a regular basis. During lunch I will often go to one of our team rooms and eat with them, and aim to not talk about work. My hope is that this connection will encourage them to ask me when they need something. I also try to encourage direct feedback by being grateful for ANY feedback I receive.


SVP, People

What are FabFitFun, Inc. Perks + Benefits

Volunteer in local community
Partners with Nonprofits
Each of our seasonal boxes partners with a charity/nonprofit organization.
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Highly diverse management team
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Retirement & Stock Options Benefits
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Acme Co. provides employees with a flexible work schedule that includes Flexible start and end times.
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Stocked kitchen with amazing snacks that suit both looking for something healthy or a sweet treat in the afternoon. Kombucha & cold brew also on tap!
Some Meals Provided
FabFitFun offers 3 catered a meals a week at our HQ in West Hollywood. Breakfast provided on Monday, while Lunch is provided on Tuesday and Friday.
Happy Hours
Happy hours are hosted Once per month.
Paid parking available for all of our employees with a paid parking incentive for those who commute to the office and don't require a parking spot or vouchers.
Pet Friendly
Dog friendly office!
Relocation Assistance
Fitness Subsidies
You will have access to our online digital streaming platform (FabFitFun TV) that hosts a library of online fitness classes from top studies. Also hosted fitness classes every quarter in nearby gyms.
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Promote from within
Online course subscriptions available

Additional Perks + Benefits

Generous compensation package and extensive benefits. 12 weeks’ paid parental leave. Free FabFitFun subscription and tons of beauty freebies! Daily impact on personalizing the FabFitFun member experience.

More Jobs at FabFitFun, Inc.7 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Project Mgmt
Data + Analytics
Los Angeles
Project Mgmt
Los Angeles
Los Angeles
Los Angeles
Los Angeles
Data + Analytics
Los Angeles
Los Angeles
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView FabFitFun, Inc.'s full profileSee more FabFitFun, Inc. jobs