Business Intelligence Manager

Do you live and breathe data? Does spending your day working on and training people on SQL, LookML, and Looker sound like fun? Let's chat!

 

01About Frame.io

Frame.io is changing the future of how videos are made by helping over 1 million creative professionals seamlessly collaborate from all over the world.

We’re backed by Accel, SignalFire, FirstMark, Jared Leto, and a host of other amazing investors. Our market-leading product is used and loved by companies such as Turner, Disney, NASA, Snapchat, BBC, BuzzFeed, TED, Adobe, Udemy, and many more.

We’re in an exciting period of growth and are on the hunt for talented and passionate individuals who share our vision for helping visual content creators produce their best work.

 

02About the Role

Frame.io is seeking an eager business intelligence manager to support our data-driven culture and to drive insights across the organization. As a software company serving more than 100,000 users every month, we have seemingly limitless product, marketing, and revenue data from which new growth opportunities can be unlocked.

As our business intelligence manager, your role will be to ensure we support the growth, marketing, product, finance, and customer service teams with the ability to glean key insights for their functional areas. This means continuing to build out our main self-service data tool, Looker, and investing in training data champions from each team who can help you scale your impact.

So what does that look like on a daily basis? Glad you asked! Let's take a look:

You arrive at the office in the morning and check to make sure there are no new errors in Looker from any of the work you or others from across the team committed yesterday. Looks like everything is running smoothly, nice!

The engineering team recently made some critical updates to user roles and permissions available in Frame.io, so you need to make an update to several key views in our Looker instance reflecting the change. You push the updates, test some critical dashboards, and then send a communication to the full company to make sure everyone is aware of the update.

A fresh batch of new hires across sales and support started earlier today. Before lunch, you meet with them for an hour to review the general UI and navigation of Looker, so they're ready for a deeper-dive with their functional teams later that week.

After lunch, you want to spend some time preparing material for the next data champion training that's taking place tomorrow. The data champion program (which meets bi-weekly) has been running well since it started 2 months ago, and tomorrow's training moves on to some more advanced topics including window functions and how to join multiple views together in a Looker model.

Late that afternoon, the data champion from the product team lets you know they’re having some trouble pulling together a conversion analysis given the large volume of click data, so you jump into our data pipeline tool, DataCoral, to create a few materialized views (just a few quick SQL queries is all it takes) of the underlying data required for the analysis. You advise them of the update, so they’re unblocked for their analysis the next day.

Sounds like a fun day, right? If so, let's chat.

 

03Requirements

  • 4+ years of professional experience in data analysis/business intelligence
  • Expert knowledge of SQL
  • Expert knowledge of Looker (including writing LookML)
  • Experience with Python (nice to have)
  • Helpful - always willing to walk others through a complex SQL query or teach Looker to a new hire
  • Self-motivated to constantly push our analytics infrastructure forward and help all teams adopt a data-driven mindset
  • Organized and resourceful - you'll leverage process to scale your impact

 

04Responsibilities

  • Continue to build and maintain our Looker instance to support a data-driven culture
  • Train data champions from across the organization on SQL and LookML
  • Train end users to self-serve data requests with Looker
  • Execute complex data requests

 

05Benefits

  • Competitive salary and equity
  • Medical, Dental, & Vision Insurance
  • OneMedical membership
  • Daily catered lunch & fully stocked kitchen with cold brew on tap
  • Unlimited PTO
  • Volunteering paid time off
  • Work From Anywhere Week
  • Pre-tax commuter benefit
  • Discounted gym membership
  • Classpass discount
  • Free Citi-Bike membership
  • Paid parental leave
  • Flexible Spending Account
  • Influence in a small, fast-paced team

Our philosophy is simple. At Frame.io, we believe that working with people of different backgrounds and perspectives allows us to elevate each other and helps us build a better product for our users.

We’re proud to be an equal opportunity employer, and are committed to providing all employees with a work environment that celebrates individuality and remains free from any form of discrimination and harassment. We base our employment decisions on the needs of our business, job requirements, and applicants' qualifications. In other words, we only care that you’re the best person for the job.

Not what you're looking for?

Search our other open roles