Lead Business Intelligence Analyst

Encora; Teletrabalho; BRL 120.000 - 160.000; Tempo integral

Resumo da oferta

A leading digital engineering firm is seeking a Lead BI Analyst to drive analytics initiatives. This role involves transforming raw data into actionable insights, designing KPI frameworks, and developing scalable dashboards using Apache Superset. You will collaborate cross-functionally, ensuring data reliability and driving best practices within the BI function. Ideal candidates will have over 6 years in BI or Data Analytics, strong SQL skills, and familiarity with monetization metrics. This is a full-time work-from-home position.

Qualificações

• 6 years in BI/Data Analytics, preferably in media/CTV/streaming.
• Expertise in SQL with modern data warehouses.
• Strong understanding of monetization metrics.
• Excellent communication and project management skills.

Responsabilidades

• Transform raw event streams into actionable insights.
• Design and implement scalable KPI dashboards.
• Develop analytical models for business metrics.
• Monitor core KPIs and perform root-cause analysis.

Conhecimentos

BI/Data Analytics

Expert SQL

Visualizations tools (Superset/Tableau/Looker)

Monetization metrics knowledge

Excellent communication skills

Project management mindset

Ferramentas

Apache Superset

Python

Dbt

Descrição da oferta de emprego

Important Information

Location:Brazil
Job Mode:Full-time
Work Mode:Work from home

Job Summary

As a Lead BI Analyst youll 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. Youll own complex SQL pipelines design KPI frameworks and deliver dashboard used daily by leadership. Beyond technical skills youll 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.

Essential Skills

• 6 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.

Highly Desirable Skills

• Experience using and setting up an ask-the-data experience with natural language AI tools helping stakeholders get quick reliable insights without deep SQL knowledge in a self-service manner;
• Python/R for analytics (pandas NumPy) notebooks and lightweight ETL.
• Dbt for model governance; Airflow/Prefect for orchestration; Git-based workflows and CI for analytics.
• Experience with ad tech & measurement (OpenRTB SSAI MMPs household graphs privacy/consent frameworks).
• Time-series forecasting anomaly detection and causal inference methods;
• Metric layer tools (e.g. dbt Semantic Layer LookML Cube/MetricFlow) and documentation/lineage tools.
• Spark/PySpark for scale; familiarity with cost/perf tuning in cloud data stacks.

About Encora

Encora is the preferred digital engineering and modernization partner of some of the worlds leading enterprises and digital native companies. With over 9000 experts in 47 offices and innovation labs worldwide Encoras technology practices include Product Engineering & Development Cloud Services Quality Engineering DevSecOps Data & Analytics Digital Experience Cybersecurity and AI & LLM Engineering.

At Encora we hire professionals based solely on their skills and qualifications and do not discriminate based on age disability religion gender sexual orientation socioeconomic status or nationality.