Innovative Portfolio Companies


Gusto (formerly ZenPayroll)
Business Intelligence Architect

The Finance, Business Operations, and Strategy (FBOS) is a truly valued business partner providing meaningful insights and foundation to scale and accelerate Gusto. You'll be part of defending and protecting Gusto, our customers and all stakeholders. The Business Intelligence Architect is responsible for managing the development and enhancement of data warehouse and reporting systems. As the critical part of this team, you will plan, prioritize and manage business intelligence needs across various business groups such as Marketing, Sales, Finance, and Customer Experience.

Here’s what you’ll do day-to-day:

  • Work with business stakeholders to standardize definitions for corporate KPI’s and implement the KPI’s in warehouse
  • Create/maintain corporate and departmental/product dashboards with multiple level of "slice and dice"
  • Track impact impact on EDW and core KPI’s around new product launches and ensure product analytics readiness
  • Support and administer BI Tools
  • Design and develop the end to end solution for the deployment of dashboards and reports to various stakeholders
  • Work directly with the business teams to rapidly prototype analytics solutions based upon business requirements
  • Architect data pipelines and ETL processes to connect with various data sources
  • Design and maintain enterprise data warehouse models

Here’s what we're looking for:

  • 7+ years of experience in designing and implementing Data Warehouse solutions, including Dimensional modeling, ETL, and Business Intelligence Semantic Layer
  • 7+ years experience in SQL with relational databases including but not limited to SQL Server, Oracle,  MySql
  • Excellent leadership skills, written/verbal communication skills, and ability to work within a collaborative team-oriented environment
  • Experience with BI tools including but not limited to Tableau, Looker, Domo, Qlik
  • Business acumen and analytical problem solving skills
  • Big data and cloud infrastructure expertise

About Gusto

Our customers come from all walks of life and so do we. We hire people from a wide variety of backgrounds, not just because it’s the right thing to do, but because it makes our company stronger. If you share our values and our enthusiasm for small businesses, you will find a home at Gusto.

Gusto’s mission is to create a world where work empowers a better life. By making complicated, impersonal business tasks simple and personal, Gusto is reimagining HR, payroll, and benefits for over 60,000 companies nationwide. Gusto has offices in San Francisco and Denver and the company’s investors include Google Capital, General Catalyst, Kleiner Perkins Caufield & Byers, as well as the founders of Instagram, Stripe, Nest, PayPal, Yelp, Dropbox, and Eventbrite, among others.

Job Location(s):
San Francisco, CA, US
Apply Now