Business Intelligence Analyst

The Role:

In your role as a Senior Business Intelligence (BI) Analyst, you will be responsible for implementing scalable analytics infrastructure from our highest value datasets, converting raw data into canonical models and insights that fuel business decision-making all the way up to the c-suite. In this role, you will have the opportunity to work with numerous cross-functional partners in Engineering, Product, and other key aspects of our business (i.e. GTM, G&A) to standardize critical metrics and build intuitive self-service products via the modern data stack (Snowflake, dbt, Looker, Hex). As Apollo continues to grow, data will be a critical anchor to influence our strategy and thus, this role will have high visibility, agency, and autonomy to expand qualitative analysis at enterprise scale. You will be reporting to the Head of Business Intelligence within the broader Revenue Operations organization.
 
 
Responsibilities:

 
Build golden, certified data tables (via dbt) to standardize instance and domain-level health, engagement, and behavioral signals critical to prioritize outbound Sales & CS tactics
 
Build source of truth dashboards (via Looker) for functional departments across our business (i.e. Sales, CS, Finance, Marketing), allowing internal customers to more intuitively understand the overall health of their business
 
Capture + catalog firm-level and department-level key performance indicators and their adjacent data products/lineage to help govern and democratize data discovery and literacy across the company
 
Innovate and champion key internal BI & Analytics development workflows and productivity initiatives aimed at optimizing efficiency, reducing cost, and heightening scalability for our overall data ecosystem
 
Help drive growth for Apollo by identifying new opportunities that will make the product more intuitive and more enjoyable to use
 
Partner with teams across Apollo to help estimate and measure the impact of our changes on growth as well as identify other levers which can drive volume sustainably
 
Improve access and visibility to our data by data visualizations - using various BI tools - Be a driving influencer on the use and application of analysis; deliver what’s needed, and show what’s possible
 
Conduct qualitative & quantitative analysis of user behavior to uncover issues or opportunities to improve our customers’ experience

 
Qualifications:

 
Experience with Looker and dbt is strongly preferred
 
Quantitative background (professional and/or academic - Math, Statistics, Economics, or Engineering)
 
+3 years of experience with SQL and relational data (preferably in MPP databases such as Snowflake)
 
Advanced SQL skills for analysis, standardizing queries, and building data infrastructure involving large-scale relational datasets

Nice-to-have: experience using Python to parse, structure, and transform data