Business Intelligence Analyst

New York, NY

Full Time

Business Intelligence

Entry Level

Book of the Month is looking for an ambitious, detail-oriented Business Intelligence Analyst to join our growing data analytics team. Our user-base generates millions of rows of data daily, and the BI Analyst will be responsible for transforming this information into analytic solutions that facilitate informed business decisions. This person will be responsible for data querying, analysis and reporting that supports all teams across the company. This is a great opportunity for an analytics enthusiast with strong SQL skills to deliver insights that impact all parts of the business, including finance, operations, marketing, editorial and customer experience.

What you’ll do…

Conduct ad-hoc analyses to provide historic, current and predictive trends in KPIs
Write complex SQL queries to clean and transform user data into datasets ready for reporting
Create and improve existing Tableau reports and dashboards to promote business insights
Collaborate with teams across the company to define KPIs and create reporting solutions for new projects
Take an active role in translating analytical findings into concrete strategic recommendations for teams across the business

What you should have…

2+ years of experience using SQL to query and analyze data
Experience building reports and dashboards in Tableau
Experience with Snowflake, Amazon Redshift or MySQL databases is a plus.
Strong critical thinking and problem-solving abilities
Passion for digging deep into complex datasets to find hidden relationships and patterns
Excellent collaboration skills with a team-player mentality
Ability to multi-task in a fast-paced environment

Minimum Requirements:

BS/MS in computer science, statistics, or a related major
Experience working with Tableau
Advanced proficiency in SQL

Base Salary: $70,000 - $90,000

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".*

Let's say we ran 2 ads on Facebook: A and B. Ad A spent $50k, had a CPC of $2 and conversion rate of 1.6%. Ad B spent $60k, had a CPC of $2.50 and conversion rate of 1.8%.

1. Which ad generated more conversions and by how many?
2. Which ad is more effective?*

Please download a free copy of bs-code if you don't already have it. Given the following tables, write simple SQL code that answers the below question. Save the file and upload it below.

Customers: customer_id (integer), enroll_date (timestamp), email (text), is_active (boolean)
Notes: one row per customer

Shopping_cart: customer_id (integer), added_date (timestamp), purchase_date (timestamp), book_id (integer)
Notes: one row per shopping cart item per customer

Books: book_id (integer), title (text), author (text)
Notes: one row per book

QUESTIONS:
1. Find and return each customer with zero or three books in their shopping cart.
2. For every author, show how many total units of his/her books are in a cart.*

Submit Application