Media Business Intelligence Manager

Saatchi & Saatchi has grown from a start-up advertising agency in London in 1970 to a global creative communications company headquartered in New York with 114 offices in 67 countries and over 6500 employees.

Saatchi & Saatchi is part of the Publicis Groupe, the world’s third-largest communications group. We are a full-service, integrated communications network, and we work with 6 of the top 10 and over half of the top 50 global advertisers.

We’re in the business of getting people to fall in love with our client's products and services. We have an unshakeable spirit and unbeatable attitude from day one at Saatchi & Saatchi that Nothing is Impossible. We believe in creating ideas that can live anywhere and firmly believe that everyone matters. And we think that, when we work as a team, nothing is impossible.

As the agency of record for 9 Toyota Dealership Associations (TDAs) across the country, the Saatchi & Saatchi TDA Group is responsible for communicating local, regional and provincial Toyota vehicle programs to a diverse, multi-cultural consumer base through Broadcast, Radio, Digital, Social Media and OOH experiences.

Each TDA has a Board of Directors that sets the total budget spend for their region over a given year, and shapes and approves communication for that region. They work with the Regional Manager of that Toyota region.

The Saatchi TDA Group works with 9 TDA Boards: Greater New York, Tri-State, Upstate New York, Connecticut, Chicago, Portland, In-land, Denver, & Kansas City. These regions are diverse in their needs. Some markets are truck-strong, others, sedan-focused. When demand and supply weigh in, this can get even more complex. There are geographic and seasonal nuances involved in most of the customer’s needs, which impacts the communication to their unique audiences.

Always aligned to the Toyota brand and to each client’s unique value proposition, the team works to deliver sharp business results—while reaching the right target with the right message at the right time.

Our culture values authenticity, transparency, and collaboration, while setting the bar high in the work we do. If you bring inventive thinking, boundless enthusiasm, and tireless energy—with a passion for client service that fuels us into the future, this might be just the fit.

As a business intelligence manager, your primary objective in this role is to analyze and report the effectiveness of our automotive client’s media investment, network of websites, and more.

Success for this position is measured by the ability to automate data processes and ensure flawless execution, maintain the accuracy and consistency of data, innovate processes and teams via industry changes and new tools, deliver high-quality reporting in a timely fashion and with little to no supervision, and present the material both internally and externally.

The right candidate will have hands-on experience working with ETL technologies, data visualization, and reporting technologies (Domo experience a must), and be proficient in driving insights from large complex data sets. Media analytics experience is required.

Roles and Responsibilities include:

• Ensure data integrity, regularly monitoring 50+ data sources, ETL, hosting, and business intelligence platforms
• Troubleshoot data as needed working in close partnership with media and/or ad ops teams
• Identifying opportunities to automate analyses and create processes for efficiencies.
• Performing analysis for advertising across channels such as broadcast, search, social, online display, and mobile.
• Analyzing and presenting (written and verbal) key learning, insights, and optimization recommendations to clients.
• Able to work with ad ops and web dev partners, possessing a working knowledge of tag management systems including Ensighten and Google Tag Manager as well as other popular ways to implement tracking technology into digital experiences (websites and mobile apps)
• Establishing & maintaining benchmarks for overarching media strategies and key campaign initiatives.
• Training regional and support teams to be self-sufficient in basic report interpretation and standard analysis.
• Bringing analytical rigor and precision to all reporting deliverables.

• 
  Experience in developing business intelligence platforms such as Tableau, Domo, Birst, Qlik, or Datorama
• Domo experience required
• Experience with digital and media data and knowledge of the common KPIs.
• Strong knowledge of ETL processes and best practices, and experience with an ETL tools such as Alteryx, Informatica, or Power Query.
• Hands-on data experience, inclusive of some media-related data
• Complete mastery of Google Campaign Manager
• Complete mastery of Microsoft Excel including creating pivot tables and programming macros
• Intermediate to an advanced working knowledge of SQL queries.
• Experience in working with databases and data warehouses.
• Familiarity with best practices for data visualization.
• Strong written and verbal presentation skills: can clearly articulate in-depth media theories, concepts, and visions.
• Strong attention to detail and ability to prioritize tasks, multitask and manage time effectively.
• Problem-solving skills - Ability to identify gaps and provide solutions.
• Critical thinking skills - Capable of generating consistent and accurate reporting results tying back to program/campaign objectives.
• Bachelor's degree in Mathematics, Statistics, Economics, Business, Marketing, or other quantitative disciplines; MBA or graduate degree in a quantitative field is a plus.

All your information will be kept confidential according to EEO guidelines.