Telly, Inc.
Lead Business Intelligence Analyst
About Us
Our revolutionary dual-screen TV is delivered to consumers for free, powered by a new kind of advertising platform that creates value for both viewers and brands. At the heart of this experience is cutting-edge software that transforms traditional TV into a smart, interactive hub for entertainment, communication, and commerce. The Business Intelligence (BI) team sits at the center of data-driven decision making, designing models and dashboards that connect device lifecycle events, monetization performance, and customer engagement. We partner closely with Product, Operations, Sales, and Engineering to drive clarity, accountability, and growth.
The Role
As a Lead BI Analyst, you’ll be a key driver of our analytics foundation. You will transform raw event streams and operational datasets into reliable, actionable insights that shape company strategy. You’ll own complex SQL pipelines, design KPI frameworks, and deliver dashboards used daily by leadership. Beyond technical skills, you’ll help structure how the BI function scales — codifying best practices, mentoring analysts, and collaborating cross-functionally.
What You’ll Do
Data Modeling & Analysis
- Build and maintain layered analytical models across device lifecycle, app usage, and monetization (RPH, ARPU, eCPM, fill-rate, retention).
- Reconcile data from multiple operational, product, and revenue systems; surface and track discrepancies.
- Create entity-centric models for health, attribution, and longitudinal behavior.
- Analyze auction funnels end-to-end (requests → bids → wins → impressions → revenue) and diagnose drop-offs.
- Monitor core KPIs with anomaly detection and investigation playbooks to accelerate root-cause analysis.
- Develop cohorting, time-series, and survival analyses for growth, churn, and LTV.
- Implement anomaly detection and alerting on core revenue/usage KPIs.
Dashboarding & Reporting
- Design scalable KPI dashboards in Apache Superset (daily/weekly/monthly) for executives and operators; enable self-serve exploration.
- Establish a governed metrics layer/semantic definitions to keep “one source of truth” across teams.
- Use templating/parameterization to make dashboards reusable by region, app, device class, cohort, etc.
Stakeholder Partnership
- Act as a thought partner to AdOps, Product & Engineering, Sales, and Operations—turning noisy signals into clear recommendations.
- Prepare concise, executive-ready narratives (dashboards, memos, Town Hall content) with takeaways and next steps.
Data Engineering Collaboration
- Align on schemas, SLAs, and data contracts; improve pipeline reliability and query performance.
- Build performant rollups/aggregate tables (daily/weekly/hourly) and materialized views for high-traffic queries; set sensible refresh cadences.
- Add tests, documentation, and lineage so models are trustworthy and maintainable.
Project Leadership
- Drive special studies (e.g., frequency & reach efficiency, identity/household dedupe, geo/DMA lifts, referral and cohort health).
- Shape analytics roadmap, structure JIRA epics, and mentor analysts in rigorous, iterative workflows.
What We’re Looking For
Core Qualifications
- 5+ years in BI/Data Analytics (media/CTV/streaming or ad-supported required), owning high-impact dashboards and analyses.
- Expert SQL on modern warehouses (Redshift/Snowflake/BigQuery); comfortable with multi-CTE patterns, window functions, tuning, and semi-structured JSON/SUPER parsing.
- Strong BI chops (Superset/Tableau/Looker/Mode) with an eye for clarity, performance, and reuse. We currently use Superset for our visualizations.
- Fluency in monetization metrics (ARPU, CPM/eCPM, RPH, fill-rate, auction stages) and attribution nuances.
- Familiarity with streaming/app lifecycle data (sessions, playback, retention, cohorts) and high-volume event streams.
- Excellent communicator: crisp problem framing, clear data stories, and pragmatic recommendations.
- Program/project mindset: prioritization, stakeholder alignment, on-time delivery.
Why Join Us
- Shape the BI function at the ground level — your work will directly inform executive decisions.
- Work on one of the most unique data environments in the industry (hardware + ads + and dual screen user behavior).
- Collaborate with a fast-moving, high-impact team obsessed with data-driven growth.
- Competitive compensation, benefits, and advancement opportunities.