Data Analyst - Media

Role Overview: You are a highly motivated and detail-oriented Data Analyst with 1+ years of experience, joining the AdTech analytics team. Your responsibility involves working with large-scale advertising and digital media datasets, building data pipelines, querying and transforming data using GCP tools, and delivering insights through visualization platforms like Looker Studio, Looker, Tableau, etc. Key Responsibilities: - Analyze AdTech data (e.g., ads.txt, programmatic delivery, campaign performance, revenue metrics) to support business decisions. - Design, develop, and maintain scalable data pipelines using GCP-native tools (e.g., Cloud Functions, Dataflow, Composer). - Write and optimize complex SQL queries in BigQuery for data extraction and transformation. - Build and maintain dashboards and reports in Looker Studio to visualize KPIs and campaign performance. - Collaborate with cross-functional teams to gather requirements and deliver analytics solutions. - Monitor data integrity, identify anomalies, and work on data quality improvements. - Provide actionable insights and recommendations based on data analysis and trends. Qualification Required: - 1+ years of experience in a data analytics or business intelligence role. - Hands-on experience with AdTech datasets and understanding of digital advertising concepts. - Strong proficiency in SQL, particularly with Google BigQuery. - Experience building and managing data pipelines using Google Cloud Platform (GCP) tools. - Proficiency in Looker Studio. - Strong problem-solving skills and attention to detail. - Excellent communication skills with the ability to explain technical topics to non-technical stakeholders. Role Overview: You are a highly motivated and detail-oriented Data Analyst with 1+ years of experience, joining the AdTech analytics team. Your responsibility involves working with large-scale advertising and digital media datasets, building data pipelines, querying and transforming data using GCP tools, and delivering insights through visualization platforms like Looker Studio, Looker, Tableau, etc. Key Responsibilities: - Analyze AdTech data (e.g., ads.txt, programmatic delivery, campaign performance, revenue metrics) to support business decisions. - Design, develop, and maintain scalable data pipelines using GCP-native tools (e.g., Cloud Functions, Dataflow, Composer). - Write and optimize complex SQL queries in BigQuery for data extraction and transformation. - Build and maintain dashboards and reports in Looker Studio to visualize KPIs and campaign performance. - Collaborate with cross-functional teams to gather requirements and deliver analytics solutions. - Monitor data integrity, identify anomalies, and work on data quality improvements. - Provide actionable insights and recommendations based on data analysis and trends. Qualification Required: - 1+ years of experience in a data analytics or business intelligence role. - Hands-on experience with AdTech datasets and understanding of digital advertising concepts. - Strong proficiency in SQL, particularly with Google BigQuery. - Experience building and managing data pipelines using Google Cloud Platform (GCP) tools. - Proficiency in Looker Studio. - Strong problem-solving skills and attention to detail. - Excellent communication skills with the ability to explain technical topics to non-technical stakeholders.