Business Intelligence Analyst

Classpath New York , NY 10007

Posted 3 months ago

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

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Analyst

The Trade Desk

Posted 1 week ago

VIEW JOBS 8/14/2019 12:00:00 AM 2019-11-12T00:00 WHO WE ARE: Founded by the pioneers of real-time bidding (RTB), The Trade Desk has become the fastest growing demand-side platform (DSP) in the industry by offering agencies and their advertisers a best-in-class technology platform that focuses on delivering meaningful and relevant engagement with consumers. With integrations into every major advertising exchange, we handle 10 million queries per second and growing – that's more page views and queries than Facebook, Google Search, and Google's entire network of websites combined – all serviced in single-digit-ms response times. Are you interested in working with big data? Do you want to push the edges of scale and responsiveness? It doesn't get much bigger or faster than this! Recently named one of the top 10 most promising companies in America by Forbes Magazine and one of the "Best Places To Work" in the nation by Outdoor Magazine, The Trade Desk offers a culture of "relaxed intensity" – one that comes from working alongside one of the most talented teams in our industry, and leading in a race that is ours to lose. WHO WE ARE LOOKING FOR: The Global BI team works closely with a broad range of teams including Client Services / Product / Engineering / Finance / Marketing to provide business intelligence reporting, address complex questions and help identify key metrics to drive data-driven decision making. We're looking for someone who is enthusiastic about new technology, has not only the existing technical skills to be successful but also the acumen to learn even more; you'll never run out of things to learn here! You're comfortable being a mediator between business and technology teams, helping both reach solutions on high-priority technical issues. There is plenty of room for advancement in this role within the department or otherwise within our company that is a meritocracy. The Senior Business Intelligence Analyst will report to the Business Intelligence Regional Lead and own BI service delivery and special projects from start to completion. Ultimately, your technical expertise and understanding of operating KPIs will help our Senior Management team identify key growth opportunities. WHAT YOU WILL BE DOING: * You will manage and resolve ad hoc Business Intelligence requests, developing new tools to automate repetitive tasks * You will use predictive modeling techniques to drive business growth and generate accurate revenue forecasts * You will support the business with time-critical data analysis and improve business operations by using cutting edge operational research and modelling methods * You will maintain the integrity of company data and put checks in place to ensure accuracy * You will apply a broad range of analytical techniques to identify business critical trends and insights by exploiting big data * You will create dashboards and reports to allow teams to easily explore data pertinent to their ongoing operations * You will serve as a subject matter expert for data analysis methods and tools, as well as data visualisation best practices WHAT YOU BRING TO THE TABLE: * A quantitatively focused education (minimum BSc in Statistics, Economics, Computer Science etc.) with 7+ years professional experience in Business Intelligence, Business / Data Analyst roles * You're a SQL pro and have a deep hands-on expertise with relational databases and data warehouse methodologies * You have experience with multiple programming languages (Python, R etc.) * You have experience with big data technologies (Qubole, Spark, HIVE, Hadoop etc.) * You have a solid understanding of statistical techniques, strong problem-solving skills as well as the ability to drive actionable insights from massive data sets * You can design clean and intuitive dashboards in Tableau and have outstanding Excel skills * You are comfortable collaborating in a fast-paced environment with teams spread across the globe * You have experience in a customer / client facing role working directly with business stakeholders * You have excellent written, verbal and presentation skills * You can prioritise and meet deadlines The Trade Desk does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of The Trade Desk. The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. The Trade Desk New York NY

Business Intelligence Analyst

Classpath