Analyst, Data & Analytics - Y&R Chicago - She Runs It

Analyst, Data & Analytics – Y&R Chicago

By She Runs It

Analyst - Data & Analytics

Company: Y&R
Location: Chicago, IL

VMLY&R is looking for a talented and exceptional Data Analyst to deliver value by leveraging the multitude of data available across our partnership. The Analyst will focus on reporting and analysis through the sales funnel, with a secondary emphasis on advanced analysis of survey results. You will work with lead generation and conversion data across various marketing channels, as well as survey and qualitative data, sourced both from the client and from other partners, so you will need to show a keen willingness to learn about new data and systems. All reporting will be done using Business Objects 4.x/Tableau and all data analysis will be done using SQL, and the suitable candidate will have knowledge of various tools including Tableau Desktop and the Business Objects Enterprise Suite to build reports and set up best practices within that reporting environment. We are looking for an individual with pro-active communication, a positive attitude and a willingness to learn about our clients’ businesses. By effectively applying customer analysis and insight processes across the various data sources, our target candidate sees this as an opportunity to hone their existing skills while gaining consultative experience by analyzing large transactional data sets and creating concise and actionable insights.


  • Use clients’ raw marketing data and business intelligence tools such as SQL, Tableau, Business Objects 4.x, SAS, Excel and PowerPoint to help them better understand their lead generation and conversion effort
  • Make data-based recommendations to improve/optimize marketing channels and clients’ lead generation goals
  • Develop and build a variety of reports for internal and external clients, primarily using Tableau, Business Objects 4.x and Excel, but also with other software packages as directed
  • Develop, catalog and maintain Business Objects Universes to support various reporting initiatives
  • Build, validate and develop reporting tables as needed within the SQL reporting environment to build and optimize report performance
  • Work together with the client and internal account teams on data, reporting and analytical issues, such as data tracking, report validation, segmentation, customer profile development and marketing ROI
  • Develop and provide written and verbal output on reports and presentations
  • Manage and resolve key data issues involving quality, consistency and thoroughness of data for reporting and analytical purposes
  • Contribute at every step from reading in the data received from the customer, rolling it up, analyzing the results, preparing the PowerPoint deck and presenting


  • Bachelor’s degree in Marketing, Analytics or a related field
  • 2+ years’ experience with Tableau, Business Objects, SQL, or any other reporting or database software
  •  2+ years of database marketing, business intelligence and analytics experience using data management and reporting best practices
  • Must be able to get deep in the details to understand what the information is saying and yet see the big picture and make strategic recommendations
  • Self-starter and pro-active requiring minimal supervision
  • Strong oral and written communication skills
  • Experience working with BO Central Management Console and administration is a plus
  • Experience with business intelligence tools (Tableau, PowerBI & Cognos) a plus

Experience with digital analytics tools (Google Analytics, Adobe Analytics, Test & Target) a plus

Soft Skills (top 5):

  • PASSIONATELY INVENTIVE: Well rounded, with emotional intelligence and clear SME areas
  • CONSTANTLY STRIVING: Small business owner mentality
  • RELENTLESSLY CURIOUS: Always learning and questioning what he/she can do more
  • ABUNDANTLY GENEROUS: Good attitude under stress and pressure, pleasant to work with
  • COLLECTIVELY PURPOSEFUL: Recognizes others, helps when possible, looks to contribute to a broader goal
Apply Now