Business Intelligence Analyst

We’re Ookla, the company behind Speedtest, Downdetector, and an ever-expanding suite of connectivity tools. Our team is a group of people brought together through passion and inspired by possibility. We are looking for team members who enjoy solving complex problems, are motivated to challenge themselves, and are delighted with turning clever ideas into unique products.

Millions of tests are performed through our products and thousands of data points are collected globally every day. With all this usage comes countless ways to dissect and analyze our data, and plenty of exciting opportunities to optimize our monetization strategy. When you work for us, you are using Ookla data and insights to further our mission to improve connectivity for all.

Ookla is looking for a smart, motivated, and fast-learning individual to join our business intelligence team. Millions of people use our speedtest website and apps every day and rely on us to help keep their ISP and mobile networks honest. With all that usage comes countless ways to dissect, analyze, and visualize our data, providing endless opportunities to empower and inform everyone at Ookla.

The business intelligence team at Ookla is small, even with you. Our team members wear many hats - informing product direction, managing a/b tests, dissecting usage trends, spotting anomalies, building reports and dashboards for management, optimizing advertising monetization and much more.

As a business intelligence analyst, your role will require critical strategic thinking and execution chops - or most simply put, the ability and eagerness to take charge and learn fast. Additionally, we’re looking for someone who can spot bad data from a mile away, and with the drive to find out what caused it and to own fixing it. Lastly, this person will be expected to embed them themselves across the organization, learning the language and metrics of each team, synthesizing and strategizing a path for keeping them informed with our data, and seeing through the release and maintenance of team-specific dashboards and alerting systems.

We are committed to providing you a flexible work environment where individuality, fun, and talent are all valued equally. If you consider yourself innovative, adept at collaboration, and you care deeply about the work you do, we want to talk!

Expectations for Success

• Ability to strategize and execute on ideas that provide the entire organization with metrics that capture the state of the company.
• Work to strengthen connection with enterprise sales teams in an effort to optimize sales process and empower people.
• Provide additional support in fielding internal data requests.
• Help in cataloging existing key reports and dashboards and documenting new ones.

Some our teams’ most recent output, as an example of the day-to-day

• Worked with the data team to aggregate raw data collected from a feature in our mobile apps for time-series visualization to support sales and keep execs informed.
• Saw through entire a/b test of a feature change in our mobile apps: design implementation of tracking events, write queries to pull data, massage and visualize results, present internally to stakeholders.
• Assist in decision to sunset an app feature by presenting the negative impact of bad app store reviews of that feature.
• Migrate popular internal Google Data Studio reports over to Tableau, for use in a bigger reporting repository project later.
• Build high-level advertising metrics dashboard for execs, bringing together data from multiple sources.

Requirements

We are looking for the right person, not the exact list of requirements. If you believe your life experience has prepared you for similar challenges, we’d like to hear from you.

• Proficient with SQL and Google Sheets/Microsoft Excel.
  • A plus: Experience with BigQuery and/or Redshift.
• Experience with Google Data/Looker Studio, Tableau, PowerBI, or other data visualization tool.
• Basic understanding of digital marketing, SEO/ASO, and digital analytics.
• Familiarity with broadband and cellular network concepts.

Benefits

We care deeply about each other and the work we do, and our perks are just one way we demonstrate this. We offer a comprehensive benefits package, including (but not limited to):We care deeply about each other and the work we do, and our perks are just one way we demonstrate this. We offer a comprehensive benefits package, including (but not limited to):

• 401(k) matching,
• Unlimited PTO,
• Employee Stock Purchase Plan options,
• health/dental/vision insurance coverage,
• wellness benefits (Calm app, gym reimbursement, ERG groups, etc),
• Employee Assistance