We are looking for a detail-oriented Data Analyst with hands-on experience in SQL, Python, and Business Intelligence tools to transform complex media data into meaningful insights. The ideal candidate should have experience working with paid media platforms, building client-facing dashboards, and delivering accurate, scalable reporting solutions. You will work closely with analytics, media activation, and client teams to ensure high-quality reporting and actionable business insights.

Key Responsibilities

Reporting & Dashboarding

- Build and maintain interactive client-facing dashboards using modern BI tools
- Develop weekly, monthly, and ad-hoc performance reports for assigned client accounts
- Design scalable reporting frameworks that can be maintained and enhanced over time
- Document data logic, calculated metrics, and reporting methodologies to ensure transparency and auditability

Data Engineering & Analytics

- Write, optimize, and maintain SQL queries to extract, clean, and transform data from cloud data warehouses
- Support the development and enhancement of centralized reporting pipelines
- Use Python for data transformation, automation, and analytical tasks where required
- Perform data validation and quality assurance to ensure reporting accuracy before delivery

.Media Data Analysis

- Analyze performance data across major digital advertising platforms, including Paid Search, Paid Social, Programmatic, and other digital channels
- Understand attribution models, conversion tracking, platform reporting differences, and media performance metrics
- Collaborate with media and strategy teams to ensure reporting accurately reflects campaign performance
- Stay updated with platform reporting changes, API enhancements, and measurement methodologies





Client Collaboration

- Participate in client meetings and reporting discussions
- Clearly explain reporting methodologies, data sources, and performance trends to both technical and non-technical stakeholders
- Identify meaningful trends, anomalies, and optimization opportunities from campaign data

Required Skills

- 2–3 years of experience in Data Analytics, Business Intelligence, or Reporting
- Strong proficiency in SQL, including joins, aggregations, window functions, and query optimization
- Hands-on experience with Python for data analysis, automation, or data wrangling
- Experience building dashboards using BI tools such as Power BI, Tableau, Looker, or similar platforms
- Experience working with paid media data from platforms such as Google Ads, Meta Ads, LinkedIn Ads, DV360, The Trade Desk, or similar
- Strong understanding of digital marketing metrics
- Excellent analytical, problem-solving, and data validation skills
- Strong communication skills with the ability to present complex data in a simple and meaningful way

Preferred Qualifications

- Experience working in a Media Agency, AdTech company, Digital Marketing Analytics, or Marketing Technology environment
- Familiarity with cloud data warehouses such as Snowflake, BigQuery, Redshift, or Azure Synapse
- Experience working with APIs and automated reporting solutions is an added advantage
- Knowledge of Agile methodologies and collaboration tools such as Jira and Confluence

What We're Looking For
- Robust attention to detail and ownership of data quality
- Ability to independently troubleshoot data discrepancies
- A proactive mindset with a passion for transforming data into actionable business insights
- Excellent collaboration and stakeholder management skills

📌 Data Engineer/Analyst | SQL, Python , DBT/ Alteryx & Power BI | Remote | 3-8 Yrs | Media Agency (Bengaluru)
🏢 Bandhan Technologies
📍 Bengaluru