Database Architect
Description
You will build custom audience segments for clients in the AWS (Amazon Web Services) environment to support look-alike modeling, activation via a DMP through to media deployment using programmatic channels.
Reporting of the role
This role reports into a senior Data & Analytics lead globally and regionally.
3 best things about the job:
- Opportunity to work on an advanced proprietary audience analytics platform and be at the forefront of the ad-tech revolution.
- A role where you will be helping client teams construct multiple custom audience segments leveraging data from multiple sources.
- A fantastic chance to build industry know-how and opportunity to work side-by-side with a global research, product and services team at GroupM.
Measures of success –
In three months, you would have:
- Gained a thorough understanding of the Live Audience data platform (a proprietary GroupM Data & Analytics product) in order to build audience segments.
- Worked closely with the Client Business Lead to define the Live Audience data requirements for a client engagement.
- Engaged other members of the global/regional Data & Analytics team to discuss segmentation, modeling and activation data requirements.
In six months, you would have:
- Successfully delivered Live Audience segments to support modelling, activation and deployment for the specific client.
- Adapted the Live Audience data architecture and internal processes to local data sources and client requirements.
- Established an efficient process, with the help of the wider GroupM Data & Analytics team, to enhance and maintain the audience data sources in Live Audience.
In 12 months, you would have:
- Become the expert locally on the data architecture and data management processes in order to effectively and independently troubleshoot and maintain an optimal solution.
- Effectively supported the local data and analytics team to identify new audience segments for other client engagement opportunities.
- Built a deeper knowledge on local available data sources, including new data opportunities, in order to enrich the Live Audience data platform.
Responsibilities of the role:
- Lead and own the build of Audience segments on AWS, provide the necessary data management process to support look-alike modelling, activation via a DMP and deployment through programmatic, custom audience, etc.
- Collaborate with the global data and analytics team to re-use/adapt the Live Audience data architecture to support the local environment and data sources.
- Adapt and update audience segments as indicated by measurement / performance findings.
- Design and execute necessary queries on the platform to build datasets needed for visualization.
- Participate in workshops (when necessary) to introduce Live Audience data architecture, data management and audience segmentation processes.
- Establish an efficient process to deliver Live Audience segments for clients in China with the help of the local/regional/global Data & Analytics team.
What you will need:
- A good degree in Statistics, Mathematics, Computer Science or Engineering.
- 5+ years of working experience in big data technology and cloud-based data architecture.
- Working knowledge of Amazon AWS EMR and experience working with Hadoop (Hive, Pig) on AWS and/or Redshift on AWS.
- Strong experience with SQL queries on HP Vertica, building projections, resource pools and other Vertica configuration settings.
- Good experience in data architecture and general database implementation details in order to troubleshoot and implement solutions optimally.
- Excellent problem-solving, organizational and analytical skills, with the ability to manage multiple work priorities.
- Entrepreneurial drive and demonstrated ability to achieve stretch goals in an innovative and fast-paced environment.
- Ability to work collaboratively with multi-cultural business partners and stakeholders, and strong team player.
- Strong written and oral communication skills in English and Mandarin (ideal).
About GroupM
GroupM is the leading global media investment management company serving as the parent to WPP media agencies including Mindshare, MEC, MediaCom, Maxus, and Essence, as well as the programmatic digital media platform, Xaxis, each global operations in their own right with leading market positions. GroupM’s primary purpose is to maximize performance of WPP’s media agencies by operating as leader and collaborator in trading, content creation, sports, digital, finance, proprietary tool development and other business-critical capabilities. GroupM’s focus is to deliver unrivaled marketplace advantage to its clients, stakeholders and people.
China market overview
China is now the second largest media market, and the world’s most vibrant digital market, growing at double the rate of the US. In 2013, China surpassed the US in e-commerce, and China leads the world in mobile with over 600m smartphone connections. The pace of change and the scale of China’s emerging consumer market are unparalleled in any other market. Global CEOs are looking to China to drive growth, and brands are rushing to keep pace. If you want a future in media and communications, there is clearly no place more vibrant, challenging and exciting than China, where opportunities for you to innovate and grow are unparalleled.