Sr. Data Engineer

Data, Analytics & Insight New York, New York San Francisco, California Los Angeles, California Los Angeles, California Atlanta, Georgia Seattle, Washington Chicago, Illinois


Description

Work Location: A Hybrid Work Experience

At GroupM, we believe that work is a part of life, not the other way around. To support that belief, we have recently adopted a “collaboration-led” hybrid approach to work in order to provide employees with the flexibility to do the best work of their lives no matter where they are working. This means that for roles where it makes sense, you'll spend some of your time in our incredible workspaces (when it's safe to do so) and some of your time remote. Check out this updated list of where we can hire:

  • California – LA or SF
  • Colorado – Denver
  • Florida – Miami/Fort Lauderdale
  • Georgia – Atlanta
  • Illinois – Chicago
  • Massachusetts – Boston
  • Michigan – Detroit
  • New York – New York City tri-state area (NY, NJ, CT)
  • North Carolina – Raleigh/Durham
  • Texas – Austin or Dallas/Fort Worth
  • Utah – Salt Lake City

ABOUT US

GroupM Data & Platform Analytics Services is a marketing science, technology, and consulting group specializing in fact-based business strategies and assessment. We combine adtech and martech platform strategy with data science & data engineering expertise, helping clients make smarter data-driven decisions.

YOUR IMPACT

  • Support 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
  • Stitch together data sources such as programmatic data, DSP, DMP, Ad Server and Ad Verification log-level data together using cloud functions
  • 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, 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 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

YOUR QUALIFICATIONS

  • 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

ABOUT GROUPM:
GroupM is a WPP company. WPP is the world leader in marketing communications services. Within WPP, GroupM is the consolidated media investment management operation and parent company to world-famous media agencies, such as Mediacom, Mindshare, Wavemaker and Essence. The company has offices in New York City, Boston, Chicago, Los Angeles, San Francisco, Irvine, Atlanta, Seattle and in many other major markets around the globe.


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

GroupM and all of 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.