Media Data Analyst at Lingarogroup in India

Media Data Analyst At Lingaro, we help organizations unlock the full value of their data. As a Media Data Analyst, you transform fragmented offline and digital media data into harmonized, analytics-ready datasets that enable advanced marketing analytics and measurement. You act as a critical link between raw media data and analytical solutions, ensuring data quality, consistency, and usability across multiple sources. You support advanced analytics initiatives, including Marketing Mix Modeling (MMM), by building reliable data foundations that drive confident, data-driven decisions. Tasks • Collect, compile, and integrate media data from multiple sources, including digital platforms, offline media agencies, and internal systems. • Harmonize multi-source datasets across taxonomy, granularity, and timeframes to create structured, analytics-ready data. • Clean, normalize, and de-duplicate datasets to establish a reliable single source of truth for media analytics. • Identify data gaps, inconsistencies, and KPI misalignments, and apply validation checks to ensure data accuracy and completeness. • Build and maintain automated data preparation pipelines using Python and advanced Excel capabilities such as Power Query and Pivot Tables. • Collaborate closely with media, analytics, and measurement teams to ensure data structures align with analytical and business objectives. • Clearly communicate media data concepts and metrics to both technical and non-technical stakeholders. Qualifications • 3–5 years of experience in a data-centric role within media, advertising, marketing analytics, or agency environments. • Strong Excel expertise, including Pivot Tables and Power Query for automation. • Working knowledge of Python for data manipulation and automation. • Solid understanding of offline media (e.g., TV, OOH) and digital/programmatic media. • Ability to work with and explain key media KPIs such as GRPs, impressions, and similar metrics. • Strong attention to detail, analytical thinking, and a data quality mindset. • Comfort working in cross-functional, consulting-style environments. Offer • Stable employment. On the market since 2008, 1200+ talents currently on board in 7 global sites. • “Office as an option” model. You can choose to work remotely or in the office. • Flexibility regarding working hours and your preferred form of contract. • Comprehensive online onboarding program with a “Buddy” from day 1. • Cooperation with top-tier engineers and experts. • Certificate training programs. Lingarians earn 500+ technology certificates yearly. • Upskilling support. Capability development programs, Competency Centers, knowledge sharing sessions, community webinars, 110+ training opportunities yearly. • Grow as we grow as a company. 76% of our managers are internal promotions. • A diverse, inclusive, and values-driven community. • Autonomy to choose the way you work. We trust your ideas. • Create our community together. Refer your friends to receive bonuses. • Activities to support your well-being and health. • Plenty of opportunities to donate to charities and support the environment. • Great Place to Work Certified Employer