Data Engineer, Analytics
New York, NY

Job Description

OVERVIEW:

GroupM Data & Analytics Services (DAS) 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.

The Data and Analytics organization in GroupM is responsible for managing and analyzing massive amounts of data as well as supporting the whole organization in delivering value from data. We focus on supporting operating our global technology stack with four key layers of Data Marketplace, Data Management, Analytics Workbench and Application Marketplace. These products are hosted on a variety of infrastructure options including but not limited to local servers, public and cloud-based solutions that enable a suit of data-driven media services.

YOUR IMPACT:

* Support development and deployment of GroupM products and services across multiple cloud environments
* 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
* Act as a consultant and subject matter expert for internal stakeholders in GroupM Data & Analytics, GroupM Engineering and agency data science and tech leads
* Develop and deploy automated scripts in BigQuery and other Google 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 customized query to generate automatic periodic reports
* Build applications writing SQL scripts to manipulate data and / or writing specific instructions for an off-shore programmer to write the scripts

YOUR QUALIFICATIONS:

Essential:

* Bachelor's degree in Computer Science, Engineering, Mathematics or other technical field is highly preferred
* 5+ years of overall experience with Data Engineering
* Minimum 2 years of hands-on experience with Google Cloud Platform
* Good communication and written skills
* Strong expertise with Data Architecture fundamentals, database design and programming, ETL and custom query development
* Experience of the following GCP Services: Cloud Storage, DataProc, Dataflow, CloudSQL, BigQuery
* Experience with building data pipes landing large files into GCP for processing, developing/ cleansing data for AI/ML purposes
* Experience using the Linux Command Line, especially in conjunction with GCP
* Use of Data Profiling Tools, ETL and Data Management Tools
* Data warehousing/data modeling experience, with strong understanding of semantic and physical data models
* Knowledge of Agile methodology
* Experience with the full development life cycle of an application stack - from architecture through test and deployment.
* Able to deliver a broad range of data engagements in areas such as Data Architecture, Data Integration, Data Analytics, Data Lineage, 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 source code management systems

Desired:

* Prior knowledge of advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred

ABOUT GROUPM:

GroupM is the leading global media investment management operation serving as the parent company to WPP media agencies including Mindshare, MEC, MediaCom, and Maxus, each global operations in their own right with leading market positions. GroupM's primary purpose is to maximize performance of WPP's media agencies by operating as leader and collaborator in trading, content creation, sports, digital, finance, proprietary tool development and other business-critical capabilities. GroupM's focus is to deliver unrivaled marketplace advantage to its clients, stakeholders and people. Discover more about GroupM at www.groupm.com.

Take A Virtual Office Tour: https://roundme.com/tour/368027

GroupM and all its affiliates embrace and celebrate diversity, inclusivity, and equal opportunity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We are a worldwide media agency network that represents global clients. The more inclusive we are, the more great work we can create together.