Lead Business Intelligence Analyst

Mexico City - Mexico

Monthly Salary: Not Disclosed

Posted on: 15 hours ago

Vacancies: 1 Vacancy

Job Summary

Important Information

Experience: 6 years

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 rawevent streams and operational datasets into reliable actionable insights that shape companystrategy. Youll own complex SQL pipelines design KPI frameworks and deliver dashboardused 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 andmonetization (RPH ARPU eCPM fill-rate retention).
Reconcile data from multiple operational product and revenue systems; surface andtrack 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 accelerateroot-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) forexecutives and operators; enable self-serve exploration.
Establish a governed metrics layer/semantic definitions to keep one source of truthacross teams.
Use templating/parameterization to make dashboards reusable by region app deviceclass cohort etc.
Align on schemas SLAs and data contracts; improve pipeline reliability and queryperformance.
Build performant rollups/aggregate tables (daily/weekly/hourly) and materialized viewsfor high-traffic queries; set sensible refresh cadences.
Add tests documentation and lineage so models are trustworthy and maintainable.

Qualifications and Skills

6 years in BI/Data Analytics (media/CTV/streaming or ad-supported required) owninghigh-impact dashboards and analyses.
Expert SQL on modern warehouses (Redshift/Snowflake/BigQuery); comfortable withmulti-CTE patterns window functions tuning and semi-structured JSON/SUPERparsing.
Strong BI chops (Superset/Tableau/Looker/Mode) with an eye for clarity performanceand reuse. We currently use Superset for our visualizations.
Fluency in monetization metrics (ARPU CPM/eCPM RPH fill-rate auction stages) andattribution nuances.
Familiarity with streaming/app lifecycle data (sessions playback retention cohorts) andhigh-volume event streams.
Excellent communicator: crisp problem framing clear data stories and pragmaticrecommendations.
Program/project mindset: prioritization stakeholder alignment on-time delivery.

Nice to Have

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

About Encora

Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services Product Engineering & Application Modernization Data & Analytics Digital Experience & Design Services DevSecOps Cybersecurity Quality Engineering AI & LLM Engineering among others.

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

Required Experience:

Important InformationExperience: 6 yearsJob Mode: Full-timeWork Mode: Work from homeJob SummaryAs a Lead BI Analyst youll be a key driver of our analytics foundation. You will transform rawevent streams and operational datasets into reliable actionable insights that shape companystrategy. Youll own ...

Important Information

Experience: 6 years

Job Mode: Full-time

Work Mode: Work from home

Job Summary

Responsibilities and Duties

Build and maintain layered analytical models across device lifecycle app usage andmonetization (RPH ARPU eCPM fill-rate retention).
Reconcile data from multiple operational product and revenue systems; surface andtrack 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 accelerateroot-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) forexecutives and operators; enable self-serve exploration.
Establish a governed metrics layer/semantic definitions to keep one source of truthacross teams.
Use templating/parameterization to make dashboards reusable by region app deviceclass cohort etc.
Align on schemas SLAs and data contracts; improve pipeline reliability and queryperformance.
Build performant rollups/aggregate tables (daily/weekly/hourly) and materialized viewsfor high-traffic queries; set sensible refresh cadences.
Add tests documentation and lineage so models are trustworthy and maintainable.

Qualifications and Skills

6 years in BI/Data Analytics (media/CTV/streaming or ad-supported required) owninghigh-impact dashboards and analyses.
Expert SQL on modern warehouses (Redshift/Snowflake/BigQuery); comfortable withmulti-CTE patterns window functions tuning and semi-structured JSON/SUPERparsing.
Strong BI chops (Superset/Tableau/Looker/Mode) with an eye for clarity performanceand reuse. We currently use Superset for our visualizations.
Fluency in monetization metrics (ARPU CPM/eCPM RPH fill-rate auction stages) andattribution nuances.
Familiarity with streaming/app lifecycle data (sessions playback retention cohorts) andhigh-volume event streams.
Excellent communicator: crisp problem framing clear data stories and pragmaticrecommendations.
Program/project mindset: prioritization stakeholder alignment on-time delivery.

Nice to Have

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

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

Required Experience:

Key Skills

Business Intelligence
Cognos
SQL
Power BI
QlikView
Data Visualization
ssrs
Tableau
SSIS
Data Modeling
Data Warehouse
Data Analysis Skills

Apply Now

About Company

Encora

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.

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click