Senior Analyst, Reporting & Visualization

Business Overview 

We are IPG Mediabrands, a client-first, consulting-led, community-driven group of media and marketing specialists around the world on a mission to ensure our clients win in the marketplace. Through our portfolio of brands, and culture of collaboration, we offer the media and marketing capabilities it takes to invest smarter and grow our client’s businesses now and in the future. Through our diverse community of people and leaders, we offer teams of experts who thrive in a culture of excellence and equity. Through our commitment to brand values and media responsibility, we offer leadership to help our clients always act in the best interests of the communities they serve.  

Position Summary

We are looking for a Senior Analyst specializing in data visualization and dashboards to join the Analytics team within Client Solutions at BPN- Part of Initiative/Mediabrands. A successful candidate will have fluency in using statistical analysis to answer questions about data sets with a strong UX/UI point of view on how to develop compelling visuals.
Curiosity, creativity and a wide variety of skills in media, technology, and data are critical success factors. 

Responsibilities

• Extract data and write SQL queries for underlying databases.
• Fluency using statistics and visualizations to answer questions about data sets.
• Work with multivariate and/or “large” datasets using conventional statistical techniques.
• Develop compelling visual stories effectively for business stakeholders.
• Communicate meaningful insights from large data sets.
• Build, maintain, and support rich and interactive graphical representations of data (reports, dashboards)
• Assist analytics team members in creating the right data and visualization solutions for their requirements which will involve rapidly transforming raw data into actionable information using ETL, analytics and visualization tools and techniques.

Required Skills & Experience

• Expert in Tableau visualizations (with a portfolio of visuals you can share)
• Intermediate level experience in SQL
• 2+ years of programming and/or automation development work
• Knowledge of ETL processes, specifically extracting media data from various sources (transforming it to fit analytics and operational Knowledge of digital data types (1st , 2nd , 3rd party data), and marketing and advertising technologies/partners needs
• Basic understanding of database structures, theories, principles, and practices
• Experience with at least one of the following cloud computing platforms: Amazon Web Services (AWS), Google Cloud Platform (GCP), or Microsoft Azure

Desired Skills & Experience

• Experience with advertising technologies or operations (media planning, buying, reporting) is a plus
• Experience working with data from digital channels (DCM, Meta, X, AdWords, Bing, etc.) is a plus
• Programming Experience in Python and/or C++, with a strong understanding of object-oriented programming
• Excellent written and oral communication skills including presentation experience to large and diverse audiences.
• Exceptionally self-motivated and directed.
• Experience advocating and driving product adoption and usage.
• Superior analytical, evaluative, and problem-solving abilities

We See You  

At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community.  

We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed.   

We See You at IPG Mediabrands. 

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. To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days. 

We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award. 

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