Senior Data Analyst, Data Management & Visualization

Business Overview

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world's most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at

Position Overview

The Senior Analyst, Data Science will be responsible for driving key technology and modeling developments associated with marketing analytics in the media sector. This person will use sophisticated data science techniques to conduct statistical analysis against large volumes of data. The ideal candidate must be comfortable solving business problems by exploring large datasets, proactively communicate ideas and opportunities, and will contribute to the growth and development of an analytics team.

Responsibilities
• Manipulate & architect large data sets to analyze our clients' businesses across multiple dimensions (sales, brand equity, search interest, website visits, social media, advertising activities, etc.)
• Develop and maintain automation tools and ETL workflows with coding
• Build data flows and develop attribution models with multiple large data sources
• Contribute to the team's AI Infrastructure development
• Create effective data visualization to illustrate critical insights and analysis
• Generate audience, campaign and market insights to affect improvements toward clients' business and media goals
• Collaborate with research, ad-operation, programmatic, verification and investment teams to improve procedures and performance
• Contribute to the department's overall capabilities and understanding of media and communications channels

Required Skills and Experience
• Experience in working with large datasets
• Knowledge of modelling techniques including Regression, Exponential Smoothing, ARIMA, Decision Tree, and/or Random Forest
• Data scripting/transformation and management experience
• Data visualization/dashboards experience (Tableau/Power BI/Datorama)
• Proficiency in SQL, R & Python
• Experience working with Analytical software and systems such as Tableau, Tableau Prep Flow, Alteryx, AWS, and/or Big Query
• Strong Expertise in Excel (Complex formula & data automation skills)
• Strong client reporting ownership experience

Desired Skills and Experience
• 1-3 years' experience required in Analytics
• Excel VBA coding preferred
• Strong analytical, critical thinking, and problem-solving skills
• Media Agency or Media Technology Background preferred
• AI Driven/automation experience preferred

Wage and Benefits


We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family.


The salary range for this position is posted below. Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position, market considerations, budgetary considerations, tenure and standing with the Company (applicable to current employees), as well as the employee's/applicant's skill set, level of experience, and qualifications.


Employment Transparency


It is our policy to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, veteran status, disability, or any other basis prohibited by applicable federal, state, or local law.


Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.


The employer will make reasonable accommodations in compliance with the American with Disabilities Act of 1990. The job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and other job functions are subject to modification. Reasonable accommodations may be provided to enable individuals with disabilities to perform the essential functions.


For applicants to jobs in the United States: In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position, please email View email address on click.appcast.io.


Salary Range

$75,000-$85,000 USD