Senior Data Analyst

Responsibilities

• Manipulate and architect large data sets to analyze client businesses across multiple dimensions
• Develop and maintain automation tools and ETL workflows using coding
• Build data flows and develop attribution models with multiple large data sources
• Contribute to the development of AI Infrastructure
• Create effective data visualizations to illustrate critical insights and analysis
• Generate audience, campaign, and market insights to improve client business and media goals
• Collaborate with research, ad-operation, programmatic, and investment teams

Requirements

• Experience working with large datasets
• Knowledge of modeling techniques including Regression, Exponential Smoothing, ARIMA, Decision Tree, and/or Random Forest
• Data scripting, transformation, and management experience
• Experience with data visualization tools like Tableau, Power BI, or Datorama
• Proficiency in SQL, R, and Python
• Experience with analytical software such as Alteryx, AWS, or Big Query
• Strong expertise in Excel including complex formulas and data automation
• Experience with client reporting ownership

Preferred Qualifications

• 1-3 years of experience in Analytics
• Excel VBA coding skills
• Media Agency or Media Technology background
• Experience with AI-driven automation

About the Company

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG), managing over $47 billion in marketing investment globally across its agency networks and specialty business units.