Data Engineer, Marketing Sciences

Data, Analytics & Insight Bogota, Colombia


Description

Position at Mindshare

ABOUT THE TEAM:
Our Marketing Sciences teams collect and analyze both quantitative and qualitative data to create vivid, compelling and actionable insights for our clients. The group encompasses Mindshare’s experts in data strategy, analytics, data visualization, data quality, and technology. We are an integral part in supporting the planning teams as they allocate media budgets and optimize effective plans for their accounts.

We're looking for a Data Engineer who can:

  • Steadily and consistently perform routine activities
  • Use a systematic approach to organizing work
  • Present instructions in a methodical, step-by-step manner
  • Respect established rules and processes
  • Use a deliberate, methodical approach to solving problems
  • Develop efficient approaches that improve performance and maintain quality
  • Develop strict, rigid routines
  • Closely follow a specific plan for how things will be done


3 Months

  • Effectively perform the ETL process, the goal being error free data sets. Use a combination of Python, Alteryx, SQL and HIVE to cut, query and QA

6 Months

  • Create your own workflows in Alteryx, unsupervised, and publish an app. [eg: automation of metadata]
  • Tech support for proprietary software which takes the output from media mix models, and generates forecasts with multiple dimensions (budgets, sales)
  • Code maintenance and development work with the back-end tables in Python/Django, SQL

12 Months

  • Enhance the Alteryx published app ecosystem through the pro-active identification and fix of problems

 

BEST THINGS ABOUT THE JOB:

  • Access to infinite data. Opportunities to work creatively and tell stories with highly varied data.
  • High quality, large international clients.

 

ABOUT MINDSHARE:

We were born in Asia in 1997, a WPP start-up with a desire to change the media world. Now we are a global network with 116 offices in 86 countries and billings of $16.5bn. We are the largest agency in GroupM, WPP’s Media Investment Management arm, which is the #1 media holding group globally with billings of $45.1bn (Source: COMvergence 2018). We aim to be our clients’ lead business partner and to grow their business through speed, teamwork and provocation.
 


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 greater work we can create together.