Important Information
Location: Colombia
Work Mode: Hybrid
Job Summary
As a Lead Business Intelligence Analyst (19011), you will be responsible for designing, developing, and maintaining high-quality software solutions. You will collaborate with cross-functional teams to understand business requirements and translate them into scalable and efficient software applications. Your role will involve leading technical projects, mentoring junior engineers, and continuously improving software development practices to ensure the delivery of robust and reliable software systems.
Responsibilities and Duties
- Design and maintain scalable analytical models across device lifecycle, app usage, monetization performance, and customer engagement, ensuring data accuracy and consistency
- Own KPI frameworks and executive dashboards in Apache Superset, establishing governed metric definitions and a reliable single source of truth
- Partner cross-functionally with Product, AdOps, Sales, Operations, and Engineering to translate complex data into strategic insights and actionable recommendations
- Lead BI initiatives including data quality improvements, pipeline optimization, advanced analyses (cohorting, churn, LTV, auction funnel diagnostics), and mentorship of analysts
Qualifications and Skills
- 5+ years of experience in Business Intelligence or Data Analytics within media, CTV, streaming, or ad-supported environments
- Expert-level SQL on modern data warehouses such as Redshift, Snowflake, or BigQuery, including complex CTEs, window functions, performance tuning, and semi-structured data parsing
- Strong experience building scalable dashboards in BI tools such as Apache Superset, Tableau, Looker, or Mode, with focus on clarity, performance, and reusability
- Deep understanding of monetization metrics including ARPU, CPM/eCPM, RPH, fill-rate, auction funnel stages, and attribution models
- Experience working with high-volume event data, streaming/app lifecycle metrics, retention analysis, cohorting, and longitudinal behavioral models
- Proven ability to design anomaly detection frameworks, KPI monitoring systems, and root-cause investigation workflows
- Strong stakeholder communication skills with the ability to translate data into executive-ready narratives and strategic recommendations
- Experience collaborating with Data Engineering on schemas, SLAs, data contracts, rollups, materialized views, and performance optimization
- Program and project leadership mindset with experience prioritizing initiatives, structuring roadmaps, and mentoring analysts
- Nice to have experience with Python or R for analytics, dbt and orchestration tools, ad tech ecosystems, metric layer tools, forecasting methods, and large-scale cloud data performance tuning
- If you'd like, I can also prepare a shorter, more executive-style version for LinkedIn or a more enterprise-facing version for client presentation.
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.
Top Skills
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries. With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
