Job Details - Find Your Perfect Career Opportunity

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

• Strong 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