ClassPass is the world’s leading platform for studio and gym fitness. We are passionate about helping our members live a more active life – they currently book almost a million classes a month and we are just getting started.

We’re seeking a Business Intelligence Analyst to help manage the data and tools that power our business-side analytics functions. This role is responsible for architecting and maintaining the business logic underpinning our PostgreSQL analytics database, which brings together data from our production environment and third-party sources and transforms it into streamlined, nimble data tables that serve as the company’s “source of truth” for business reporting and insights. You will also assist in the management and development of our Business Intelligence software that employees use to access data and create KPI reports and dashboards. This role reports to the Business Intelligence Senior Manager and sits on the Analytics team, but will frequently collaborate with stakeholders from other teams, particularly the Marketing, Pricing & Inventory, and Accounting organizations.

Our ideal candidate:

  • Thrives in the sweet spot between business acumen and technical data prowess. In this role you’ll need to be able to work with business end users to understand their reporting needs, as well as interface with the engineers who provide technical support to our analytics database.
  • Loves to get in the weeds of data, and strives to develop detailed expertise on where data comes from, how it’s structured, and where sneaky edge cases might be hiding. You’ll need to be willing to “get your hands dirty” in the data, as you’ll be the one writing and updating the SQL logic for our major fact tables.
  • Has strong business instincts and judgment. Your job is ultimately to oversee a data model that can be easily used to drive business insights; as such, the ideal candidate has interest in our business and understands the reporting implications of data model design.
  • Has a strong command of data visualization. In addition to managing underlying source data you’ll also be responsible for building reports and dashboards that allow for the quick distillation of the most critical insights.
  • Is a structured, logical thinker who is comfortable designing and executing the transformation of occasionally messy source data into robust and usable datasets.
  • Is self-driven and thrives in a fast-paced environment. We’re a high-growth company that’s constantly iterating on our product and releasing new features and policies for our users; it’ll be your job to remain on the forefront of understanding all of these changes and what they mean for our data.

Responsibilities:

  • Work cross-functionally with our Marketing, Accounting, and other departments to develop processes, data models, and reports to improve efficiency
  • Write, QA and maintain/update SQL logic underpinning major data tables of our analytics database, which powers all business analytics and financial reporting at the company
  • Manage configuration of Financial and Marketing related data streams and definition of its metrics
  • Architect and build efficient business data models, optimize technical performance of database, and troubleshoot issues
  • Utilize BI tools to create and manage reports, dashboards, and data sources that are critical for deriving insights on the business
  • Develop reporting standards and best practices to ensure data and key metric standardization across the company

Requirements:

  • 2+ years experience in Business Intelligence or similar role that involves data modeling and/or SQL-based data transformation and analytics
  • Advanced SQL skills required (experience with PostgreSQL a plus)
  • Experience developing data models and databases at a nascent or rapidly scaling business
  • Experience working with Marketing and/or Financial reporting metrics
  • Experience using BI Tools required (Looker and/or Tableau a plus)
  • Must have interest in business-side implications of work; need to “keep up” with what’s going on with the business, feel comfortable with collaborating with business stakeholders at all levels of seniority to understand their data needs
  • Familiarity with Athena/S3 databases, BigQuery, and ETL pipelines a plus
  • Comfort and fluency working with command line a plus
  • Experience with subscription economics a plus

Apply for this Job

* Required
  
  


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at ClassPass are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 1/31/2020

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

Because we do business with the government, we must reach out to, hire, and provide equal opportunity to qualified people with disabilities1. To help us measure how well we are doing, we are asking you to tell us if you have a disability or if you ever had a disability. Completing this form is voluntary, but we hope that you will choose to fill it out. If you are applying for a job, any answer you give will be kept private and will not be used against you in any way.

If you already work for us, your answer will not be used against you in any way. Because a person may become disabled at any time, we are required to ask all of our employees to update their information every five years. You may voluntarily self-identify as having a disability on this form without fear of any punishment because you did not identify as having a disability earlier.

How do I know if I have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Blindness
  • Deafness
  • Cancer
  • Diabetes
  • Epilepsy
  • Autism
  • Cerebral palsy
  • HIV/AIDS
  • Schizophrenia
  • Muscular dystrophy
  • Bipolar disorder
  • Major depression
  • Multiple sclerosis (MS)
  • Missing limbs or partially missing limbs
  • Post-traumatic stress disorder (PTSD)
  • Obsessive compulsive disorder
  • Impairments requiring the use of a wheelchair
  • Intellectual disability (previously called mental retardation)
Reasonable Accommodation Notice

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.