Senior Analyst, Reporting & Visualization Full Time

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

We embrace diversity, and our responsibility to maintain an inclusive environment is core to our culture and values. We see diversity of people and experiences as fuel for creativity and innovation needed to bring about the best experiences and services. A diverse workforce means we can grow together, be better problem solvers, and bring about long-term, meaningful change where we will achieve above and beyond our business goals. We are better together..

When you join Mediabrands, you join a global community and are valued for who you are – your lived experiences, the contributions you make, and the distinct perspectives you bring. Here, what you think and who you are is just as important as what you do. As we recruit, we are dedicated to looking beyond what a resume can show. If you think you’d be a great addition to the team but don’t have the exact experience or skills, we encourage you to apply and share your unique background with us. We see you at 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 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 the policy of Mediabrands, division of the Interpublic group, 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 with Mediabrands, please email accommodation@mbww.com.

About Mediabrands

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). Mediabrands manages approximately $40 billion in marketing investment globally on behalf of its clients and provides strategic services and solutions across its award-winning, full-service agency networks UM and Initiative and through its innovative marketing specialist companies Reprise, Magna, Orion, Rapport, Healix, Mediabrands Content Studio and the IPG Media Lab. Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors. The company employs more than 13,000 marketing experts in more than 130 countries representing the full diversity of humanity. For more information, please visit our website: www.ipgmediabrands.com.

Salary Range

$75,000 — $85,000 USD