General information

Agency: UM

Job Function: Data & Analytics

Location: New York, United States

Job Ref#: 10604

Description & Requirements

Position Summary

We are looking for a Senior Analyst, Data Engineering to join our Engineering Team at Universal McCann. A successful candidate should be a data minded, hands-on individuals with a technical academic background, entrepreneurial spirit and interest in media and marketing.  You will be critical in hands-on data process management of our data ecosystem and to drive high client satisfaction. Curiosity and passion for data management and technologies is a must!
This position will be working across many key accounts that our agency covers, including J&J, Spotify, CVS, Sony, and more. 
Primary day to day tasks will include building data ETLs, working with teams to establish raw data templates, reinforcing templatized data collection, and managing communication with client data teams/3rd parties agencies leveraging the data. Regular data quality checks including comparison, reformatting and researching new potential sources will be an integral part of the job as well. 
Given the technical nature of the role, prior experience working with etls,  python, sql and excel is a must. Any background working with media metrics and rules is also a strong plus.

Key Responsibilities

  • Responsible for collecting, ingesting, auditing, processing, and the automation of all data feeds:
    • Candidate must have experience using SQL Server, T-SQL, SSIS and VB/C#
    • Experience in the following is a plus: Python
  • Work with cross-functional internal teams to establish data reporting templates and routines. This will involve onboarding and assessment of requirements and reviewing steps on site.
  • Work with team leads to establish operational/data requirements and help ensure adherence.
  • Collaborate and provide quality assurance, process optimizations and work with data from multiple partners, clients and systems for analysis and reporting.
  • Candidate will lead ETL and automated data processing buildouts for key data sources across major clients 
  • Become a subject matter expert of data management and capabilities.
  • Help manage Tableau data feeds and dashboard refreshes. Understand visualization platforms and how reporting/dashboard tools work.
  • Interest in analytics with emphasis on Marketing Mix Analysis.
  • Ability to work independently or collaboratively with strong time management and organizational skills.
  • Strong written and verbal communication skills (professional and technical). This role will involve working with multiple teams and clients in person.

Desired Skills & Experience

  • Bachelor’s Degree or above in: Information Systems, Computer Science, Data Science, Business Management, Statistics, Mathematics, or other related field.
Work Experience:
  • At least 2+ years of experience in data specific function: Python experience is a must.
  • Strong Technical Skills in SQL, VBA, Python, Tableau, Excel
  • Experience working with media data or agency experience is a strong plus

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

About Us

A full-service media agency, UM strives to Futureproof our clients’ businesses through our relentless pursuit of better science, art and outcomes. Founded in 1999, UM is made up of entrepreneurially-minded strategists, planners, researchers, investment experts, decision scientists, account executives, and content and activation specialists—over 4,800 employees across 130 offices in over 100 countries around the world. A part of IPG Mediabrands, UM’s global headquarters are in New York, with seven additional US offices in Birmingham, Chicago, Dallas, Detroit, Los Angeles, Miami, and San Francisco. UM's vision to Futureproof our clients for today, tomorrow, and beyond wouldn’t be possible without our Better People.

UM’s culture is an inclusive one, where people belong and are encouraged to bring their full selves to the office, and where personal and professional growth are a priority of every member of the team. UM’s Executive Leadership Team is dedicated to building a culture that permeates every element of the company, from work flexibility, to career planning and regular talent reviews, to an active culture club. They proudly uphold the following values:

Courage: Our courage to take risks drives our ability to set new industry standards.

Curiosity: Our relentless curiosity drives relentless innovation.

Commitment: Our commitment to uncovering better opportunities for our clients and our community is at the heart of everything we do.

Community: We pride ourselves on fostering a community where everyone can belong while actively giving back to the communities in which we live.

Caring: We care about being a diverse agency where everyone feels motivated and supported.

Candor: Our candor through open and constructive dialogue ensures better outcomes for our people and our clients.

As a company, UM is constantly pushing to improve, under their Better Science, Better Art, Better Outcomes banner, striving to set the bar in the ever-evolving media landscape. Their efforts have yielded a number of new business wins recently including Aetna, American Express, Columbia Sportswear, Gallo Wine, Henkel, and Rocket Mortgage.

All U.S. Mediabrands employees must be fully vaccinated against COVID-19 or have an approved accommodation.