Location: New York,NY, USA
Position at GroupM Choreograph
EssenceMediacom is a new breed of media agency. Grounded in analytics & insights and powered by data & technology, we believe in the power of media and creative to drive breakthroughs for the world's best brands. We help clients understand the modern marketing paradox and discover the breakthroughs brands need to win with their consumers. We are designed for the new communications economy - built on data & technology, built for people & algorithms, built around diverse schools of thought, built to test & learn at scale, and, crucially, built to evolve.
Role Summary & Impact
In this role, you will be responsible for building and automating campaign insights and data-driven optimizations for programmatic media campaigns. You will work with Data Scientists to create custom algorithms and data insights/visualization that support internal and external teams to drive performance.
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 script.
Requirements
* Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field. OR equivalent professional work experience.
* 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.
Life at GroupM
Our 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 GroupM Leave Administration at [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.