Senior Data Engineer

Job Description

About EssenceEssence, part of GroupM, is a global data and measurement-driven media agency whose mission is to make brands more valuable to the world. Clients include Google, Flipkart, NBCUniversal, LOr al and the Financial Times. The agency is more than 2,000 people strong, manages $4.5B in annualized media spend, and deploys campaigns in 121 markets via 22 offices in APAC, EMEA and the Americas. Visit essenceglobal.com for more information and follow us on Twitter at @essenceglobal.About the roleOur Global Analytics Hub is the backbone of our 120+ person strong analytics practice globally. The Analytics Hub functions as a center of excellence in creating efficiencies and driving standardization across all Essence Analytics teams in North America, Europe, and APAC. The Hub is involved in multiple areas of the business including media campaign analytics, tool development & automation and is critical to the continued success of Essence s Global Analytics offering.Essence is known for its use of data and rigorous experiment-based best practices to measure and quantify the success of digital media. Over the years, we have run hundreds of studies and led several research and analytics projects to understand what makes digital advertising successful.This role is a member of Global Analytics Hub that works on multiple analytics projects across the globe and oversees building a predictive planning engine capable of leveraging all the data we ve aggregated over the years. Reporting to the Sr. Director of Analytics and based out in Gurgaon, you will be instrumental in the creation and evolution of this vital initiative. This role requires heavy lifting on data engineering to specifically manage all the data flowing into the engine from varied sources. If you have a heart for big data and its management, this role is for you!Some of the things wed like you to do

• Data management
• Building pipelines from different data sources to prepare core dataset for the engine to work on
• Data prep and cleanup (missing data, outlier detection, duplications) from internet scale digital advertisement/survey response data
• Data integration (merge, join, subset)
• Insight generation
• Methodology writeups, interpretation of results
• Applications and generalization (Use cases, automation, and scalability evaluation)
• POVs, 1-pager, vendor evaluation and assessment
• Technical programming
• Coding languages (Python is must, R is good to have) and Google tools (Big Query, Airflow, GCP)
• Comfortable with data retrieval and processing with SQL and NoSQL
• Solid understanding of relational and non-relational database technology, data pipeline
• Understanding of code version management system

A bit about yourself

• A degree in Engineering (Computer science is a plus) or equivalent field
• At least 2 years of industry experience in a data-focused role
• Experience with managing multiple large data sources (structured or not)
• Ability to use the data to create a story and help create new analytical products or change an existing product in a way that improves company goals and metrics.
• Knowledge of the data science lifecycle - acquiring data from different sources, exploratory data analysis, scheduling tasks, creating, and optimizing modes including validation and interpretation, and finally onward communication of results in a clear and succinct fashion.
• Hands-on Experience with programming languages (SQL, Python ), statistical software packages (R, Python SciPy) would be a plus.
• Baseline understanding of all the five core competencies: programming, statistics, machine learning, data munging, and data visualization.
• Ability to communicate your findings effectively to non-technical audiences.
• Preferred: Knowledge of popular ad serving technologies and supporting analytical and research tools (Doubleclick, Atlas, comScore, Compete, etc.)

What you can expect from Essence:Essence s mission is to make advertising more valuable to the world. We do this by employing the world s very best talent to solve some of the toughest challenges of today s digital marketing landscape. It s important that we hire people whose values reflect those of our own: genuine, results-focused, daring and insightful. As an Essence employee, we promise you a workplace that invests in your career, cares for you and is fun and engaging. We believe these factors create a workplace where you can be yourself and do amazing work.,

Keyskills :
content managementemailsqlanalyticsapachecenter of excellenceexploratory data analysisbig dataad servingdata sciencedata mungingdata analysismachine learningdata engineeringcampaign analytics