Manager, Analytics

at  EssenceMediaCom

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.

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.

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.