Sr. Business Intelligence Analyst

Spigot is a global multi-platform application development company. We focus on building highly effective digital offerings that can maximize value for our advertisers, publishers, partners, and users. Spigot operates in 7 different product lines on a global landscape. We have products that include iOS applications, Android applications, Google extensions, desktop apps, digital media, and digital advertising; we also partner with top-tier companies and are currently Yahoo’s #2 partner for driving traffic. These diverse mobile and web solutions allow advertisers to optimize for a highly targeted audience reach. Combining best-in-class industry expertise and consumer interests with proprietary big-data insights, we develop and fine-tune apps that offer optimal user engagement at scale.

Our success is fueled by employee innovation, data-driven decisions, and a startup mentality. We’re talking top-tier health care benefits, free lunches, flexible work schedules, numerous company outings, coffee, drinks & snacks, ping pong, pool table, foosball tables, and an all-star group of talented professionals.

We are looking for a Sr. Business Intelligence Analyst who will have the opportunity to work on high-volume, SaaS web, and desktop applications while finding unique ways for users to interact with these products. They will be responsible for completing profit-driven analyses to provide recommendations on how to increase profits and efficiency within some of our high-performing businesses.

Where You’ll Make an Impact:

  • Tracking and analysis of Key Performance Indicators such as profit, user value, click through & conversion rates, traffic volumes, etc.
  • Development and execution of new reports (trends, opportunities, etc.) to boost the business intelligence of the team and refining information into actionable recommendations for the Product Development team members
  • Building and maintaining dashboards in Google Data Studio or other data visualization software
  • Experience working with large datasets and ETL frameworks
  • Ad-hoc queries using Google BigQuery and/or other RDBMS with the ability to write complex SQL queries
  • Data manipulation and presentation in Excel
  • Building and maintaining large data tables in Google BigQuery and/or other RDBMS

Who You Are:

  • 5+ years working as a Business Intelligence Analyst
  • Practical experience with Excel (pivot tables, vlookup, charts, etc.)
  • Experience using data visualization software
  • Advanced SQL (select/from/where clauses, data structure, joins, building and modifying tables, etc.)

Measurements of Success:

There are several key measurements of success this employee will use to benchmark performance including:

  • Improving the effectiveness of the product development team through relevant analysis, planning, and reporting
  • Growing the business through insightful reporting and analysis
  • Advancing the productivity of the team through skilled planning, research, and operational efficiencies

Apply Now

Perks of working at Spigot

shape shape

Paid Healthcare

100% company paid medical, dental, and vision insurance

shape shape

Competitive 401K

Competitive 401K matching and retirement plan

shape shape

Unlimited Vacation

Work life balance.

shape shape

Catered Lunches

Spigot provides free lunch in the office