Data Architecture – Manager

Company Overview

GroupM is WPP’s top global media investment management group. (RECMA 2010) GroupM serves as the parent company to Maxus, MEC, MediaCom, Mindshare, and Xaxis. GroupM and its agencies employ over seventeen thousand people in four hundred offices spanning eighty-one countries.
GroupM Data & Analytics is a full service analytics, data, business, and marketing consultancy. We maximize our clients’ and agencies’ marketing ROI by providing leading edge data management tools, advanced analytics, and consulting to monitor, evaluate, and optimize media investments.

Position Overview

The Data Architect Manager is expected to lead the implementation of database applications during the design, build and maintenance phases of large projects. Candidates are expected to demonstrate the following skills/experience: hands-on skills in managing large data sets, familiarity with big-data concepts, cloud computing, open-source tools, and optimization techniques, excellent oral and written communication skills, client focus and the ability to lead and encourage teamwork, and also to manage client engagements and pitches.

Responsibilities

• Initiate timeline to design, build, and deploy database applications
• Manage data architecture requirements including how many data feeds and frequency of updates
• Implement data QA process across various platforms
• Manage the retrieving, compiling, and formatting of large volumes of data
• Utilize syndicated research tools to retrieve various types of data (macroeconomic, marketing, business, etc.)
• Manage project timelines and deliverable schedules
• Guide Data architects to build SQL and/or SAS scripts to manipulate data and / or provide specific build instructions for off-shore programmers
• Manage communications between onshore and offshore implementation team during build phase. Review and manage the offshore progress on daily basis
• Ensure applications are properly maintained by working with off-shore maintenance teams to ensure all cycles are properly completed, with strong emphasis on Quality Assurance of data and settings
• Manage communications between project analysts and technical support team to obtain technical data support and enable data feed upgrades
• Work with agency partners to understand the media campaign flows and execution process of media plans
• Manage data vendors to establish data transfer process (set template, frequency and logistics)
• Lead data platform product release meetings to clients
• Design and guide analysts to implement customized media performance dashboards using Tableau
• Lead client facing deliverables and present analytical solutions and marketing performance insights to clients

Requirements

• BS in Computer Science or related technical field required. An MS is preferred.
• 5-7 years related work experience in the field of data management, marketing analytics, and technology
• Team management (onshore and offshore) and supervisor experience is required
• Experience with the full development life cycle of an application stack – from architecture through test and deployment.
• Strong skills in SQL and proven experience working with at least one of the major databases platforms (SQLServer, Oracle, DB2, MySQL, Sybase, or Postgres)
• Strong analytical skills; ability to analyze raw data, draw conclusions, and develop actionable recommendations
• Organized, detail-oriented, QA-focused
• Process-driven project management and multiple projects management experience a plus
• Prior knowledge of advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred
• Experience with key reporting solutions including Tableau, Omniscope and MicroStrategy will be highly valued
• Proficient in system architectures (translating application design to operational requirements)
• Familiarity with big-data concepts, cloud computing, open-source tools, and optimization techniques is preferred
• Experience in managing data-driven platform projects is a plus
• Client facing experience is required