Lead Business Intelligence Analyst
Share
Job Location:
Monthly Salary:
Posted on:
10 hours ago
Vacancies:
1 Vacancy
Job Summary
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.
Required Experience:
IC
Key Skills
- Business Intelligence
- Cognos
- SQL
- Power BI
- QlikView
- Data Visualization
- ssrs
- Tableau
- SSIS
- Data Modeling
- Data Warehouse
- Data Analysis Skills
About Company
As Encora Inc. expands its footprint in Latin America, its acquisition of Nearsoft provides our clients with a unique chance to Nearshore on a global scale.
