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