Lead Business Intelligence Analyst
Company:Encora
Location:Brazil
Languages:English
Seniority level:Lead, 6+ years
Experience:6+ years
Skills:
AWSPythonSQLBusiness IntelligenceData AnalysisETLGitNumpySnowflakeAirflowPandasMentoring
Requirements:
6+ years in BI/Data Analytics (media/CTV/streaming or ad-supported required). Expert SQL on modern warehouses (Redshift/Snowflake/BigQuery). Strong BI chops (Superset/Tableau/Looker/Mode), currently using Superset. Fluency in monetization metrics (ARPU, CPM/eCPM, RPH, fill-rate, auction stages). Familiarity with streaming/app lifecycle data and high-volume event streams. Excellent communication skills. Program/project mindset: prioritization, stakeholder alignment, on-time delivery.
Responsibilities:
Build and maintain layered analytical models across device lifecycle, app usage, and monetization. Reconcile data from multiple systems and track discrepancies. Create entity-centric models for health, attribution, and longitudinal behavior. Analyze auction funnels end-to-end and diagnose drop-offs. Monitor core KPIs with anomaly detection and investigation. Develop cohorting, time-series, and survival analyses. Implement anomaly detection and alerting on core revenue/usage KPIs. Design scalable KPI dashboards in Apache Superset. Establish a governed metrics layer/semantic definitions. Align on schemas, SLAs, and data contracts. Build performant rollups/aggregate tables and materialized views. Add tests, documentation, and lineage to models.
