Senior Analyst, Business Intelligence

Department: Global Ops

Location: Bangalore, India

Employment Type: FullTime

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.