Consumer Data Architect, MarTech – Greater China & Mongolia

Key Skills

Azure, Azure CosmosDB, Data Architecture, Data security, Database, Databricks, Java Programming, NoSQL, Python Programming, Scala Programming, SPARK Programming, SQL

Job Description

As the SME of consumer data architecture, expected to optimize across multiple consumer related data flow & integration, data base and data processing across multiple solutions: frontend, CRM, CEP, CDP, Segmentation and MA with data governance experience of working on hybrid cloud of data flow such as eCommece, vending/smart cooler (IoT) in alicloud and AWS.

The position would report to the Lead of GC&M MarTech, and closely work with product leads, data analyst, solution arch, cloud arch and cyber security analyst. The role is part of the Coca Cola company’s digital and technology services team and serves the GC&M region. The mission of the MarTech domain is to analytically enable & automate brand building operations to build a competitive advantage for Coca-Cola Marketers in GC&M OU.

Key Results

• Scalable & robust data pipeline to hold marketing data (from billions of consumers that the brand touches across the region) that can hook on to multiple data sources and activation channels across offline and online channels seamlessly.
• Technically and architectural excellence of ensuring cross systems data flow and data quality.
• Analytics solutions enhancement that meets criteria for consumer data enrichment, cost, time-to-deliver and reusability.
• Actionable insights for business teams & deliver a culture of data-driven marketing.
• Compliance with company and industry best practices and standards.

Responsibilities:

• Create and maintain optimal data pipeline architecture for all consumer related data
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Contribute to the top priority MarTech data projects all the way from project initiation, chartering, enrolling team members, execution and closure
• Work with marketers, Data/ Business Analysts to understand marketing challenges, business questions, processes, and related data.
• Integrate consumer data from owned touch points/applications, from partners & third-party vendors & transactional data (sales data) across walled garden.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using China Azure ‘big data’ technologies primarily, and hybrid cloud if needed.
• Build analytics reports to provide actionable insights into customer acquisition, operational efficiency, and other key marketing performance metrics.
• Document processes and research, standards, guidelines, and best practices for teams utilizing the solutions.

Education

• University Degree or higher in Data Science, Computer Science, Information Technology, Statistics, Applied Math or related field.

Related Work Experience

• 8+ years of work experience in data engineering functions & delivering solutions to large organizations
• Experience in working on marketing data related data pipelines (consumer data) like in CDP etc will be preferred.
• Data Experience related to retail sales, eCommerce, digital media and other data sets, most commonly used in the CPG industry will be an additional advantage
• Good exposure in one or more, Big Data Technologies such as (Azure CosmosDB, Hive, HBase, Kafka, Spark, Yarn). Strong preference for Azure stack experience (Databricks, Azure functions, HDInsight cluster, Event Hub, Azure Data Factory etc). Certifications of Azure would be a plus.
• Strong working database knowledge and experience working with both relational databases and NoSQL databases and unstructured datasets, query authoring (SQL) as well as working familiarity with a variety of databases.
• Strong skills with one or more data analysis languages: Python, Java, Scala, etc.
• Knowledge about data governance and data security, experience with building processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Building scalable APIs & integrating with APIs to push data with 3rd party channels will be advantageous
• Experience with data visualization tools like PowerBI would be a plus.
• Very good verbal and written communication skills in Mandarin. Communication skills in English will be hugely advantageous
• Creative problem solver who thrives when presented with a challenge & a strong team player
• Ability to work with geographically diverse teams via collaborative technologies.

Core Competencies:

• Drives Innovative Business Improvements: Develops new insights into solutions that result in organizational improvements; promotes a work environment that fosters creative thinking, innovation and rational risk-taking.
• Balances Immediate and Long-Term Priorities: Seeks to meet critical objectives while considering the impact of those decisions and activities on the ability to achieve long-term goals.
• Delivers Results: Focuses on the critical few objectives that add the most value and channels own and others' energy to consistently deliver results that meet or exceed expectations.
• Imports and Exports Good Ideas: Relentlessly seeks, shares and adopts ideas and best practices in and outside the Company and embraces change introduced by others.
• Develops and Inspires Others: Builds and maintains relationships that motivate, guide, and/or reinforce the performance of others toward goal accomplishments. Develops self and others to improve performance in current role and to prepare for future roles; seeks and provides feedback and coaching to enhance performance.
• Lives the Values: Demonstrates the values of The Coca-Cola Company through words, actions, and by example; fosters an environment that reflects the values of the company.

What we offer:

• Iconic & Innovative Brands: Our portfolio represents over 250 products with some of the most popular brands in the world, including Coca-Cola, Costa Coffee, Innocent, Simply, Fairlife & Topo Chico. 
• Expansive & Diverse Customers: We work with a diversified group of customers which range from retail & grocery outlets, theme parks, movie theatres, restaurant. 
• Purpose Driven: Purpose driven approach that empowers our people to protect the environment and communities we serve while delivering safe & quality products.   
• Global Connections: Allows you to develop, enhance and maintain global connections that allow us to move faster and learn from others.   
• Community of Belonging: We’re an organization that believes our ability to continually grow and build the right atmosphere where people feel safe and empowered, lets you bring your best self to work.