Senior Data Analyst

Strategy & Insights Chicago, Illinois


Description

Position at VMLY&R

At VMLY&R, we create connected brands. We resist the usual ways of seeing, doing and thinking — harnessing creativity, technology and culture — to reimagine the entire connected consumer experience. Our goal? To create work that becomes part of people’s lives, to drive value for our clients and, in the best of cases, to impact the world.

We’re looking for a talented and exceptional Senior Data Analyst to deliver value by leveraging the multitude of data available across our partnership.

The Senior 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.

The successful candidate will:

  • 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 efforts
  • 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

As part of the WPP Group, VMLY&R offers one of the best overall compensation packages in the business.

Required Skills and Experience:

  • Bachelor’s degree in Marketing, Analytics or a related field
  • 4+ years’ experience with Tableau, Business Objects, SQL, or any other reporting or database software
  • 4+ 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

VMLY&R is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, gender identity, sexual orientation, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Need Assistance? If you require reasonable accommodation or assistance for any part of the application or hiring process, please submit your request either by fax to 816-817-0976 or by email to careers.iwd@vmlyr.com.