Senior BI Engineer

| Greater LA Area

FabFitFun is known in the marketplace for a fantastic community (over 1 million members), curated quarterly subscription box plus a companion video content service (both live and recorded). Our business is booming, and we are scaling our Engineering, Product, Data Science and BI Teams to keep up with this hyper growth. Accordingly, we are seeking a 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.

Our ideal candidate will be detail-oriented, a strong communicator, incredibly curious, and have a passion for data and analytics that will enable data-driven decisions.

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
  • Unlimited PTO and generous holiday schedule
  • 12 weeks’ paid parental leave
  • Free FabFitFun subscription
  • Paid parking
  • Catered meals 3x/week
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • MySQLDatabases
    • PostgreSQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • AsanaManagement
    • WrikeManagement
    • SalesforceCRM
    • IterableEmail

Location

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.

What are FabFitFun, Inc. Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
Company Equity
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
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.
Parking
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!
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.

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.53 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Sales
Content
Product
new
Los Angeles
Operations
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Operations
new
Los Angeles
Developer
new
Los Angeles
Marketing
new
Los Angeles
Data + Analytics
new
Los Angeles
Developer
new
Los Angeles
Design + UX
new
Los Angeles
Design + UX
new
Los Angeles
Finance
new
Los Angeles
Marketing
new
Los Angeles
Data + Analytics
new
Los Angeles
Internships
new
Los Angeles
Finance
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Finance
new
Los Angeles
Developer
new
Los Angeles
Developer
new
Los Angeles
Marketing
new
Los Angeles
Marketing
new
Los Angeles
Finance
new
Los Angeles
Finance
new
Los Angeles
Finance
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Data + Analytics
new
Los Angeles
Marketing
new
Los Angeles
Product
new
Los Angeles
Developer
new
Los Angeles
Internships
new
Los Angeles
Internships
new
Los Angeles
Finance
new
Los Angeles
Developer
new
Los Angeles
Operations
new
Los Angeles
Data + Analytics
new
Los Angeles
Operations
new
Los Angeles
Content
new
Los Angeles
Finance
new
Los Angeles
Design + UX
new
Los Angeles
Developer
new
Los Angeles
Data + Analytics
new
Los Angeles
HR
new
Los Angeles