Description Position at GroupM Choreograph ABOUT US GroupM Nexus brings together 9,000 practitioners globally across ad ops, addressable content & TV, AI, commerce, programmatic, search and social, among others, to deliver transformational outcomes across digital channels and platforms and create exciting new career paths for our people. GroupM Nexus is the world's largest performance engine that integrates paid, owned, and earned to deliver true business outcomes for our clients.Role Summary & Impact The Manager, Data & Analytics will focus on building and automating campaign insights and data-driven optimizations for programmatic media campaigns. The manager works with data scientists to create custom algorithms and data insights/visualization that will support internal and external teams to drive performance. This role requires excellent technical skills and experience in data matching, analytical and machine learning applications, data mining, reporting, and dashboarding. Through the insights created the individual will contribute significantly to the strategy across various aspects of campaign planning, set-up, optimization, and insights. Key Responsibilities
- Lead the development and deployment of GroupM products and services across multiple cloud environments
- Gather, store and maintain big data sets for all digital marketing channels. Data sources include Ad Server, DSP, DMP, Ad Verification
- Collaborate with a cross-functional team of client leads, application developers, operations engineers and architects to translate complex product requirements into technical specs and design requirements
- Optimize performance and cost-efficiency of cloud-based processes across multiple cloud environments (AWS, Azure, GCP)
- Maintain a high degree of knowledge in cloud data architecture and ETL best practices especially across Google Cloud Platform products and services
- Develop and deploy automated scripts in Google, Azure or AWS cloud services to be used by other teams to increase productivity
- Facilitate architectural discussions and initiatives to ensure cloud-based products are optimally deployed with maximum availability of design features
- Formulate and execute robust UAT protocols to identify and address latent errors in product functions
- Design, build and deploy ETL and data management processes with reliable error/exception handling and rollback framework
- Provide production support for data load jobs and develop a customized query to generate automatic periodic reports
- Build applications writing SQL/Python scripts to manipulate data and/or writing specific instructions for off-shore programmers to write the scripts
- Supervise, train and mentor experienced and junior analysts & engineers
- Manage project timelines and deliverable schedules and share concerns about deliverables, timelines, and issues with project managers and director
Requirements
- Degree in Computer Science, Engineering or related technical field required
- 3-5 years of related work experience in the field of data engineering, marketing analytics, data science, and technology consultative environments
- Excellent client-facing, communication, and writing skills
- Expertise with Data Architecture fundamentals, database design, and programming, ETL and custom query development
- Strong skills in SQL/ Python and proven experience working with at least one of the major databases platforms required
- Experience with building data pipes into Azure/GCP/AWS for Data Profiling Tools, ETL and Data Management Tools
- Experience processing, developing/ cleansing data for AI/ML purposes required
- 2-3 years of experience with the following GCP or equivalent cloud services: Cloud Storage, DataProc, Dataflow, CloudSQL, BigQuery
- Experience using the Linux Command Line
- Experience with source code management systems
- Data warehousing/data modeling experience, with a strong understanding of semantic and physical data models
- Experience with SCRUM or Agile methodology and project management tools
- Able to deliver a broad range of data engagements in areas such as Data Architecture, Data Integration, Data Analytics, Data Governance, Data Quality and BI Reporting
- Understanding of data analysis techniques and how they can be applied in the marketing context beneficial
- Experience with the full development life cycle of an application stack - from architecture through test and deployment preferred
- Knowledge of the advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred
- GCP Data Engineer cloud certification or equivalent preferred
Life at GroupMOur passion for shaping the next era of media includes investing in our employees to help them do their best work, and we're just as committed to employee growth as we are to responsible media investment. GroupM employees can tap into the global GroupM & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include competitive medical, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days. GroupM is WPP's media investment group and the world's leading media investment company with a mission to shape the next era of media where advertising works better for people. The company is responsible for more than $60 billion in annual media investment, as measured by the independent research bureau COMvergence. Through its global agencies Mindshare, Wavemaker, EssenceMediacom, and mSix&Partners, and cross-channel performance (GroupM Nexus), data (Choreograph), entertainment (GroupM Motion Entertainment) and investment solutions, GroupM leverages a unique combination of global scale, expertise, and innovation to generate sustained value for clients wherever they do business. Discover more at www.groupm.com.GroupM provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.GroupM is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with GroupM, please send an e-mail to [email protected] or call (212) ###-#### and let us know the nature of your request and your contact information. The base salary for this position at the time of this posting may range from $60,000 to $140,000. Individual compensation varies based on job-related factors, including business needs, experience, level of responsibility and qualifications. We offer a competitive benefits package, please visit for more details.