Senior Data Analyst

New York, NY

Full Time

Business Intelligence

Mid Level

Book of the Month is looking for a highly organized Senior Data Analyst to facilitate data delivery and reporting across the business. Our user base generates millions of rows of data daily, and the Senior Data Analyst will play a critical role in the way the company uses this information to make business decisions. Working across teams, you will be facilitating the orderly delivery of reports, data, and training across all parts of our business - including finance, supply chain, operations, growth marketing, product, editorial, and member experience.

About the Role:

Build and maintain a standard set of report-ready data cubes used for reporting and analysis across the company.
Document and cross-train how best to use our internal data sets to make effective analytical decisions.
Work closely with other teams such as Product, Marketing, Operations, and Finance to understand company reporting and prioritize the reporting roadmap.
Collaborate with the Product and Engineering teams to ensure new features and experiments can be effectively measured and reported on.
Right-size the Book of the Month data infrastructure and staff to meet our reporting demands.

About You:

BS in a technical or analytical discipline and 2-5 years of experience in a Data or Analytics role.
Strong Technical Skills:
- Highly proficient in writing complex SQL queries to transform raw user action data into business data.
- Experience building reports and dashboards in a BI tool.
- Experience with an OLAP database, such as Amazon Redshift, Snowflake, or Google Big Query is essential.
- Experience with Python, R, bash or similar scripting languages in a plus
Strong critical thinking and problem-solving abilities. You are passionate about revealing hidden relationships and patterns.
Strong collaboration skills. You are excited to collaborate with teams across the company to plan and execute data-driven projects that help the company make better, smarter, and faster fact-based decisions.
Ability to multitask in a fast-paced environment.

Salary Range: $120k to $180k

Apply for this position

Required*

Apply with Indeed

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Cover Letter*

LinkedIn Profile URL:*

Do you currently live in or adjacent to New York City?*

Are you seeking an in-office company where you work 4-5 days per week in the office?*

How did you hear about this job?*

What is your familiarity with Book of the Month?*

When you think about your aspirations for your next position, what does that look like in terms of work/life balance and career growth? Indicate your aspirations on a scale of 1 to 10 in which 1 is "work/life balance is super important" and 10 is "career growth is super important".*

When you think about what type of workplace environment you most enjoy, do you prefer consistency or dynamic change? Indicate your preference on a scale of 1 to 10 in which 1 is "consistency" and 10 is "dynamic change".*

A table that tracks user events has the following schema:
(user_id, event_type, event_timestamp)
Where user_id is unique to the user, event_type can be "pageview" or "click", and the timestamp is a Unix timestamp. Please provide SQL that does the following.
1. Assigns a "session_id" for each sequence of events that does not have any waits for more than 30 minutes.
2. For each session, identify how many clicks were in the session.*

Submit Application