Business Intelligence Manager at Frame.io
New York City, NY, US

About Frame.io

At Frame.io, we’re powering the future of creative collaboration. Over 700,000 video professionals use Frame.io to seamlessly share media and gather timestamped feedback from team members and clients. Simply put, we help companies create better video, together.

Frame.io is backed by Accel, SignalFire, FirstMark, Jared Leto and a host of other phenomenal investors. We've built a highly functional and market-leading product used and loved by companies such as Turner, Disney, NASA, Snapchat, BBC, BuzzFeed, TED, Adobe, Udemy, and many more.

We’re still in the early days of transforming the way the world makes video, and we're on the hunt for talented individuals to help us achieve our vision.

 

About 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 let's you know he's 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 him of the update, so he's unblocked for his analysis the next day.

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

 

Requirements

  • 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

 

Responsibilities

  • 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

 

Benefits

  • 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

At Frame.io, we believe that learning from different backgrounds and perspectives will allow us to elevate each other and help us build a better product for our users.

We are proud to be committed to equal employment opportunity, regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status.