Important Information
Experience: +6 years
Job Mode: Full-time
Work Mode: Work from home
Job Summary
As a Lead BI Analyst (19011), 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 dashboard 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.
Responsibilities and Duties
-
- 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.
- 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.
- 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.
Qualifications
📌 Lead Business Intelligence Analyst (México)
🏢 Encora
📍 México