BI Data Modeller, Marketing

Req #: 1702111
Location: Mumbai, Maharashtra IN
Other Locations:
Job Category: Information Technology & Services
Job Description


Mondelēz India Foods Ltd. (Formerly Cadbury India Ltd) is a part ofMondelēz International, Inc. (NASDAQ: MDLZ) family of companies, whichcomprises the global snacking and food brands of the former Kraft Foods Inc.following the spin-off of its North American grocery operations in October2012. Kraft Foods acquired Cadbury Plc in 2010. The combination of Kraft FoodsandCadbury created a globalpowerhouse in snacks, confectionery and convenient meals. Kraft Foods had twovery different portfolios which would benefit from being run separately. Hence Kraft Foods split in to two companies on October 1, 2012, with focusedportfolios:

Mondelēz International: A global snacking business

Kraft Foods: A North American grocery and beverage business

Our Belief is “The power of big.and small”


We are a company thatrecognizes the power of big but we also respect the importance of small.Our belief is central to ourunique strengths, core to our untapped potential, and crucial to ourcompetitive advantage. We have the scale and resources of a $36 billion global powerhouse butwith the speed, creativity and agility of a startup company.  We celebrate the power of big in ourstrategy globe with ideas like power brands, global innovation platforms, andbeing open and inclusive. But we also embrace the power of small byfostering an entrepreneurial spirit, acting like owners and keeping it simple. Itis the promise of what you can expect from working at MDLZ as well as what willbe expected from you.

With annualrevenues of approximately $36 billion,Mondelēz International is the world’s largest maker of chocolate, biscuits andcandy, and the second-largest maker of gum. 

Our 15 Global power brands that drive 70% ofour growth includ

Biscuits:Oreo, TUC, Club Social, Chips Ahoy!, belVita, Barn

Gum and Candy:Trident, Halls, Chiclets, Cadbury Éclairs, Stride

Chocolate:Cadbury Dairy Milk, Milka, Lacta, Toblerone 

Describe the broad function and scope of the position:

  • Depicts the data flow within and between systems in a particular functional area.
  • Works with key business representatives to model the data needed for the respective domain.
  • Develops, manages and updates the data models, including physical and logical models of the data warehouse, data mart and staging area and sometimes the operational data store and data source systems
  • Design and Development of needed Data Architecture for Marketing domain and ensures enterprise data is structured for ease of use
  • Governs the Data Flow & Model and Layering concept for their domain and ensure consistent and harmonized application
  • Develops and maintains an integrated, subject-oriented, predominantly conceptual and logical data model that represents essential data produced and consumed across the enterprise for a domain
  • Provides data architecture support and expertise to all major enterprise projects
  • Develops process for capturing and maintaining metadata from all data market place components
  • Ensures safeguarding the data model consistency, the data flows process structure and the data integrity
  • Level 3 support of all processes and solutions within a domain
  • Defines Archiving and housekeeping approach and ensures consistent use

Experience and Skills Required

  • Deep understanding of Marketing  and related processes in CPG or FMCG and  industry
  • Deep understanding of data within their domain (master data, data facts, KPI's, etc.) including Markets, Consumers, Brand, Categories, Products, Channels, Volume/Value, Market Share, promotion, modern trade, E-Commerce, etc. and related business challenges
  • Strong relational and dimensional Data modeling and information classification hands-on expertise
  • Understanding of the differences between relational and object modeling
  • Deep knowledge and hands-on experience with Multi-dimensional modeling, star and snowflake schemas and normalization/ /de-normalization
  • Deep experience with Hadoop and Non-SAP based data modeling
  • Hands-on experience in Data Harmonization, Slowly Changing Dimensions - Type I & II, etc.
  • Understanding of meta-models, taxonomies and ontology’s, as well as the challenges of applying structured techniques (data modeling) to less-structured sources
  • Experienced with Data Architecture for structured, semi-structured and unstructured data
  • Exposure to Hadoop technologies like Hive, HBase, Oozie , Pig, Sqoop, Spark
  • Awareness of ELT processes through hadoop
  • Development of user defined functions (udf) using java, python, shell scripts (Good to Have)
  • Experience of modeling using high volume data from 3rd party Data providers (like Nielson, Kantar, Ipsos, etc.) and from SAP
  • Familiarity with MDM, business intelligence, and data warehouse
  • Deep knowledge in designing & developing data flows and enabling process chains on Hadoop based technologies
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning
  • Drive for Results
  • Problem Solving Planning
  • Creativity
  • Listening
  • Perseverance
  • Informing
  • Peer Relationships
  • Integrity and Trust
  • Business Acumen
Link for schema