Business Intelligence Analyst

Business Intelligence

Job Location: Venice, CA

Apply Now


System1 is looking for a BI Analyst to join our Business Intelligence team. The Business Intelligence team is the horizontal layer that supports business intelligence, optimization, machine learning, and external & internal reporting. We process and report on hundreds of millions of events and user attributes per day, gathered from an extremely heterogeneous set of data streams.

As a BI Analyst in the Business Intelligence team, you will be working with engineering teams across System1 to ensure that we have the highest quality of data in and out of the platform.  Attention to detail and a desire to learn are key to this position.

Our database systems include Snowflake, Postgres, Redshift, and MS SQL server. We also utilize a range of technologies including Kinesis, Spark, and Redis.

The Role You Will Have

  • Build/maintain dashboards and reports to track key metrics for cross-functional stakeholders and executives
  • Meet with stakeholders to gather requirements and follow up to ensure data needs are being met
  • Read data from multiple data sources and transform, enrich and aggregate data for an efficient presentation in an enterprise environment
  • Provide input into the architecture, design, and implementation of a business intelligence solution
  • Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy, usability, and value
  • Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
  • Assist the BI, Data Science, and Marketing teams with data investigations.

What You Will Bring

  • Bachelor’s Degree (technical or science) preferred.
  • Strong attention to detail.
  • 3+ years working in SQL (Postgres / MySQL / MSSQL or similar) in a production environment
  • 3+ years building dashboards and reports in Tableau (preferred), SRSS or similar BI platform
  • Strong sql query skills (CTE’s, stored procedures, multi-table joins, temp tables) with large data sets
  • Strong attention to detail
  • Able to function with imperfect data (strive to do things the right way, but able to accept some compromises along the way)

What We Have To Offer

  • Free Uber/Lyft to and from work every day!
  • Collegial and collaborative team with highly intelligent and motivated coworkers
  • Cross-team lunches and demos to foster learning
  • Unlimited Paid Sick Time, Competitive PTO and Benefits package
  • Daily catered meals and fully stocked kitchen
  • Bi-weekly happy hour at various bars, restaurants, and venues across Los Angeles
  • Bi-weekly onsite happy hour
  • Catered dinner on Tuesdays and Thursdays
  • Weekly fitness class with private trainer: high intensity training, yoga, beach volleyball, beach soccer, ultimate frisbee
  • Company parties and outings: Skyzone indoor skydiving, Medieval Times, Karaoke, etc.
Apply Now