Self-Service Analytics Suite @ Contra

Looker is a premium business intelligence and product analytics tool part of Google Cloud. I have seen Looker implemented a variety of ways across the tech industry and have learned how to leverage Looker inside the modern data stack to achieve stunning, dividend-paying results. These experiences all converged at Contra where I, as the first data team hire:

Worked with product, finance, and engineering to define the core metrics of the business and Contra's two-sided platform marketplace

Built intermediate and analytics-ready, enriched data models ready for consumption by analysts in the data warehouse or by any BI tool. For this I take a practical approach guided by Kimball dimensional modeling philosophies

Created the LookML layer in Looker to dynamically query analytics models with various dimensions and filters, allowing non-technical users to explore the data and self-serve reports

Configured full drill-down capability so end users can investigate any metric with a click

Designed and shipped a suite of dashboards depicting our critical North Star Metrics in an intuitive way against our goals

Assembled a collection of "Lookup Summary" dashboards on a variety of objects (users, paid projects, job postings, etc) and integrated dynamic links in all identifying IDs and drilldowns such that a non-technical user can seamlessly transition from observing trends to investigating specific data points to taking action without ever raising a question to the data team