Role Overview

Maintain and distribute weekly/monthly streaming performance dashboards (DAU, MAU, stickiness, logged-in rate, avg. session time) for biweekly stakeholder meetings
Meet with key stakeholders to define target metrics for their teams and reverse-engineer solutions using available pipeline data
Support ad-hoc data requests from leadership as they arise
Monitor and maintain ETL connectors across marketing and social platforms (Facebook Pages, Instagram Business, YouTube Analytics, Google Ads, Tiktok, and more)
Administer automated data transfer jobs in BigQuery, including scheduling management and backfill resolution and maintenance for if/when they break
Serve as subject-matter-expert on data pipeline architecture across cloud data platforms, including data lineage, source systems, and reporting caveats
Partner with revenue operations, social, and marketing teams on performance data audits and dashboard maintenance
Own subscription reporting structures, auditing existing pipelines and developing new ones to support streaming platform analytics
Maintain and enhance custom scripts and queries as business needs evolve (scheduled in GBQ)
Provide cross-functional project management for technical and data initiatives across teams
Pull and reconcile web/app analytics data (GA4) with video platform metrics (JW Player) for subscriber and audience analysis
Develop and maintain DAU/MAU reporting methodology, including documenting data limitations and ensuring appropriate caveats in all stakeholder reporting
Field stakeholder questions on viewing patterns across devices and platforms (Roku, CTV, mobile, web) using combined analytics sources
Coordinate with engineering partners on data sync issues between cloud platforms
Push updated pipeline outputs from BigQuery into downstream data platforms as needed
Troubleshoot and resolve cross-cloud data transfer issues, ensuring outputs are configured correctly to maintain pipeline reliability

Requirements

5+ years of experience in data analytics, business intelligence, data engineering, or a related field.
Strong proficiency in SQL, including experience writing and optimizing complex queries in large-scale data environments.
Hands-on experience with cloud-based data warehouses, preferably Google BigQuery.
Experience maintaining and troubleshooting ETL/ELT pipelines and automated data workflows.
Working knowledge of digital analytics platforms, including Google Analytics 4 (GA4).
Experience integrating and analyzing data from multiple sources, including advertising, social media, subscription, and web analytics platforms.
Proven ability to develop executive-level dashboards, reports, and performance metrics.
Experience documenting data definitions, methodologies, and reporting caveats for business stakeholders.
Strong project management and organizational skills, with the ability to manage multiple priorities simultaneously.
Excellent communication skills and ability to translate technical concepts into actionable business insights.
Ability to work independently with minimal supervision and quickly learn new systems and business processes.

Tech Stack

BigQuery
Cloud
ETL
Roku
SQL

Benefits

Equity employer
Equal Opportunity Employer (EEO)
Paid time off
Remote work flexibility
Professional development opportunities

Teton Ridge

Open Positions (1)

Engineering

Data Engineering, Analytics Contractor