Senior Analyst, Business Intelligence

lgads; India; On-site; INR 1,200,000 - 3,000,000; Full time

Job summary

LG Ad Solutions seeks a Senior Analyst - Business Intelligence to drive enterprise BI initiatives across Sales, Product, Finance, and Operations. You will own Tableau platforms, develop scalable dashboards, and partner with global teams to standardize KPIs and reporting.

You will write optimized SQL and Python/PySpark, transform ad tech data into actionable insights, and mentor junior analysts while coordinating with Product and Data Engineering to deliver high-impact BI solutions.

Qualifications

• 4+ years in BI, Analytics, or Data Strategy, ideally spanning both business insights and operational use cases in ad tech, digital media, or SaaS.
• 3+ years of hands-on Tableau Desktop and Tableau Server/Cloud experience, including publishing, permissions, row-level security, and scheduling.
• Strong SQL skills: complex joins, window functions, CTEs on large datasets.
• Proficiency with Databricks and Python/PySpark for data wrangling and automation.

Responsibilities

• Tableau Platform Ownership: manage content on Tableau Server/Cloud, projects, permissions, row-level security, and sharing with external partners.
• Own data sources, extracts, refresh schedules, and tune workbook performance for large datasets.
• Reconcile dashboard figures against source systems and partner reports to ensure accuracy.
• Design and document best practices for dashboard design, naming, calculated fields, and version control.
• Mentor junior analysts and lead Tableau knowledge-sharing sessions.
• Operational Intelligence & Analytics: build enterprise dashboards, forecasts, and deep-dive analyses to support revenue, partner insights, and content monetization.
• Design and maintain reporting dashboards and anomaly detection for ad delivery and KPIs.
• Write efficient SQL and Python/PySpark on Databricks to prepare, join, and validate data at scale.
• Handle ad-hoc analysis requests and present findings clearly to technical and non-technical audiences.
• Translate operational data into business rules and insights for quick action by Operations and Content teams.
• Collaborate with Product and Data Engineering on pipeline requirements to meet BI and operational use cases.
• Stakeholder & Partner Management: act as primary BI partner for Operations and global stakeholders.
• Support cross-functional partners and external Content Partners with tailored BI insights.
• Partner with external teams globally to ensure unified KPI definitions and reporting.
• Build strong relationships so BI outputs earn trust and adoption.

Skills

BI & Analytics

Tableau

SQL

Python/PySpark

Tools

Databricks

Tableau Desktop/Server

Python

Job description

LG Ad Solutions

LG Ad Solutions is a global leader in connected TV (CTV) and cross-screen advertising. We pride ourselves on delivering state-of-the-art advertising solutions that integrate seamlessly with today's ever-evolving digital media landscape.

The Opportunity:

Our Business Intelligence team turns large-scale advertising, revenue, and viewership data into the insights that leaders, operations teams, and content partners use to run the business.

We are seeking a Senior Analyst - Business Intelligence to drive high-impact analytics that bridge enterprise BI with operational execution. As a senior individual contributor, you will be the go-to expert for business and operational insights, supporting the Sales, Product, Finance, and Operations teams. You will also play a key role in maintaining strong relationships with external teams and premium content providers globally, ensuring alignment on business intelligence, operational efficiency, and reporting standards.

This role is designed for someone who can operate independently, own critical BI initiatives end to end, and bring deep, hands‑on expertise in building and managing enterprise‑level Tableau environments. You will shape how intelligence is embedded across the company.

Responsibilities:

Tableau Platform Ownership

• Manage content on Tableau Server/Cloud: projects, permissions, row-level security, and sharing with external partners.
• Own data sources, extracts, and refresh schedules, and tune workbook performance for large datasets.
• Reconcile dashboard figures against source systems and partner reports so every number can be trusted.
• Set and document best practices for dashboard design, naming, calculated fields, and version control.
• Mentor junior analysts and run Tableau knowledge‑sharing sessions.

Operational Intelligence & Analytics

• Build enterprise dashboards, forecasts, and deep-dive analyses to support revenue, partner insights, and content monetization.
• Design and maintain reporting dashboards and anomaly detection for ad delivery and operational KPIs.
• Write efficient SQL and Python/PySpark on Databricks to prepare, join, and validate data at scale.
• Handle ad-hoc analysis requests and present findings clearly to both technical and non-technical audiences.
• Translate operational data into business rules, thresholds, and insights that Operations and Content teams can act on quickly.
• Collaborate with Product and Data Engineering on pipeline requirements, ensuring BI and operational use cases are met.

Stakeholder & Partner Management

• Act as the primary BI partner for Operations and global stakeholders, delivering insights that shape execution and monetization strategies.
• Support cross-functional partners (Sales, Product, Finance, Operations) and external Content Partners with tailored BI insights.
• Partner with external teams globally to ensure unified KPI definitions, consistent reporting, and alignment on data usage.
• Build strong working relationships with global external stakeholders and Content Partners so BI outputs earn trust and adoption.

Requirements:

• 4+ years in BI, Analytics, or Data Strategy, ideally spanning both business insights and operational use cases in ad tech, digital media, or SaaS.
• 3+ years of hands‑on Tableau Desktop and Tableau Server/Cloud experience, including publishing, permissions, row‑level security, and scheduling.
• Expert Tableau skills: LOD expressions, table calculations, parameters, dashboard actions, and performance and extract optimization.
• Advanced SQL (complex joins, window functions, CTEs) on large datasets.
• Strong working knowledge of Databricks and Python/PySpark for data wrangling and automation.
• Strong executive communication and storytelling skills; able to present to global stakeholders.
• Proven ability to influence senior leaders as an individual contributor and manage relationships with global teams and external partners.

Preferred:

• Experience with real‑time or operational intelligence frameworks, particularly in advertising or content monetization.
• Familiarity with CTV/OTT and programmatic advertising concepts (SSP/DSP, impressions, fill rate, revenue share).
• Tableau certification (Desktop Specialist or Certified Data Analyst).
• Exposure to forecasting or time‑series reporting.