Sr. Data Engineer

Data, Analytics & Insight New York, New York


Description

ABOUT US:

GroupM Data & Analytics Services is a Marketing Science, Technology, and Consulting group specializing in fact-based business strategies and assessment. We provide expertise in data management, advanced analytics, technology deployment, and marketing effectiveness with one clear remit: help clients achieve significant and lasting improvements in marketing effectiveness and profitability.

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/Python scripts to manipulate data and/or writing specific instructions for an off-shore programmers to write the scripts

YOUR QUALIFICATIONS:

  • Bachelor’s degree in Computer Science, Engineering, Mathematics or other technical field is highly preferred
  • Good written and verbal communication skills
  • Strong expertise with Data Architecture fundamentals, database design and programming, ETL and custom query development
  • Experience with the following GCP Services: Cloud Storage, DataProc, Dataflow, CloudSQL, BigQuery
  • Experience with building data pipes landing large files into Azure/GCP/AWS for processing, developing/ cleansing data for AI/ML purposes
  • Experience using the Linux Command Line
  • Experience with source code management systems
  • 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
  • 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
  • Prior knowledge of advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred

ABOUT GROUPM:

At the heart of the world’s leading media agency network is a future-facing product company, building the tools to make media work for everyone. In partnership with the globe’s leading clients, agency teams, media companies and technology platforms, we’re using our privileged position to help our customers ascend to vantage points unique in our industry.  

Our teams bring together agile product management, cutting edge data science and enterprise scale engineering to build products that will shape the next decade of data driven marketing. We believe consumer privacy, client confidentiality, brand growth and user experience are essential to performance and the sustainability of the advertising ecosystem and have assembled a global team with diverse skills and experience to help shape that future.  

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.