People, Person, Computer, Electronics, LCD Screen, Laptop, Pc

Business Intelligence AnalystUnited States

ClassPass

Business Intelligence Analyst

United States

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 our 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 collection of Business Intelligence software that employees use to access data and create KPI reports and dashboards. This role reports to the Business Intelligence Manager and sits on the Analytics team, but will frequently collaborate with stakeholders from the Product & Engineering 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.

    • 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 product managers and engineers to remain at the forefront of understanding how production data is evolving with new product/feature releases
  • 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 Mixpanel including technical performance, accessibility, and metrics definition
  • Architect and build efficient business data models, optimize technical performance of database, and troubleshoot issues
  • Develop reporting standards and best practices to ensure data and key metric standardization across the company
Requirements:
  • 3+ 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
  • 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
  • Experience with Mixpanel or other event-based collection services a plus
  • 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

I'm interested

Please send me alerts for jobs like this

Not ?

Thank you. Please wait while we forward you to the application.

Similar Jobs

Business Intelligence Analyst - Operations

Grove Collaborative United States United States
The Role In this role you will make Grove's operations team even more awesome. Operations is all about serving up the WOW factor to our customers, and data gives Grove the edge it needs to keep improving. You will be the point person to identify a...

ClassPass Go Intern

ClassPass United States United States
ClassPass Go is looking for a detailed oriented and motivated candidate skilled in asset management and production. This is a great opportunity for those who are interested in pursuing a career in digital, asset management, production, or other re...

Consultant, Clinical Operations - ER Flow

Qventus United States United States
Qventus is looking for an energetic, personable and quick-learning healthcare professional to assist us in working with hospital clients to expand existing use cases, develop new modules and drive outcomes by leveraging the Qventus platform. The r...