Business Analyst – Reporting & Dashboards

Location: Pune | Experience: 3–5 years | Team: Operations

About DeltaX

DeltaX is a data-driven digital advertising platform built for agencies and advertisers to optimally buy, track, attribute and report ad campaigns across search, social media, display RTB, mobile, video and other media channels. Founded in 2012, DeltaX is a pioneer in the advertising technology industry. It leverages deep learning to break down complex data sets so digital marketers and advertisers can understand consumer behaviour, frame better outreach strategies and get the best out of their digital media investments. DeltaX works with 1,000+ advertisers and has teams in Singapore, Bengaluru, Pune and New York.

About the Role

Advertisers choose DeltaX because it brings every channel's data into one place. We're looking for a Business Analyst who turns that cross-channel advertising data into reporting clients and internal teams actually rely on. You will own reporting requirements end-to-end — understanding what a client or team needs to know, modelling the data with SQL, and building clear, trustworthy dashboards in BI tools — and act as the go-to analyst for campaign performance questions across Client Success, Campaign Management and Product.

Key Responsibilities

• Gather reporting requirements from clients, Client Success and Campaign teams, and translate them into clear metric definitions, data models and dashboard specs
• Write and optimise SQL to extract, join and transform campaign, spend, conversion and attribution data from multiple ad platforms and sources
• Build and maintain dashboards and recurring reports in BI tools (Looker Studio, Power BI, Tableau, Metabase or similar)
• Own data accuracy: reconcile numbers across platforms (Google Ads, Meta, DSPs, analytics/attribution tools), investigate discrepancies and document known caveats
• Analyse campaign performance (CTR, CPC, CPA, ROAS, conversion funnels) and surface insights and anomalies to account teams
• Standardise KPI definitions, report templates and reporting cadences across accounts
• Partner with Product and Engineering on data requirements, new integrations and improvements to the platform's native reporting
• Automate manual reporting workflows to reduce turnaround time

What You'll Need

• 3–5 years of experience as a Business / Data / Reporting Analyst, ideally in digital marketing, AdTech, MarTech, e-commerce or an agency
• Strong SQL skills (joins, window functions, CTEs, aggregations) on real-world, messy datasets
• Hands-on experience building dashboards in at least one BI tool (Looker Studio, Power BI, Tableau, Metabase, etc.)
• Solid understanding of digital marketing data and metrics across search, social and programmatic channels, including attribution concepts
• Advanced Excel / Google Sheets
• Ability to work directly with business stakeholders, ask the right questions and turn ambiguous asks into precise requirements
• Strong attention to detail and a habit of validating numbers before they reach a client
• Nice to have: Python for data work, Google Analytics / GA4, BigQuery or another cloud warehouse, ad platform APIs