Hyderabad
2 years ago
21 Applied
JOB ID:43397
Job details
Job Type
Full Time
Functional Area
Database Administrator/ Data warehousing,RnD/Engineering design
Industry
IT-Software/Software Services
Education
Not Specified
Experience Required
5 - 10 Yrs
Key Skills Required
sql database design, python or java, airflow, kafka, hadoop, hive, spark, mapreduce, sql, nosql, netezza, teradata
Other Skills Required
Job Description
This role is with the Global business services arm of Media Center of Excellence (CoE) at PepsiCo.
In this role, you will play a key role in shaping the future of media measurement strategy for PepsiCo, esp. with focus on building an understanding role of media as key Growth Driver thru ROI and related analytics. You will be a trusted advisor to marketing, Insights leaders and data science team across key markets in laying down strong data foundation through implementation of process & technology.You will be responsible for providing thought leadership and execution in the field of data foundation to set a vision for driving PepsiCo media and content effectiveness through data-driven strategy.This role is the backbone of media measurement agenda at Pepsico and is responsible for building data systems and pipelines to feed into prescriptive and predictive modeling by establishing and enhancing process around data capture, storage, quality and reliability.You will work with Media, Data en... See More
In this role, you will play a key role in shaping the future of media measurement strategy for PepsiCo, esp. with focus on building an understanding role of media as key Growth Driver thru ROI and related analytics. You will be a trusted advisor to marketing, Insights leaders and data science team across key markets in laying down strong data foundation through implementation of process & technology.You will be responsible for providing thought leadership and execution in the field of data foundation to set a vision for driving PepsiCo media and content effectiveness through data-driven strategy.This role is the backbone of media measurement agenda at Pepsico and is responsible for building data systems and pipelines to feed into prescriptive and predictive modeling by establishing and enhancing process around data capture, storage, quality and reliability.You will work with Media, Data en... See More
This role is with the Global business services arm of Media Center of Excellence (CoE) at PepsiCo.
In this role, you will play a key role in shaping the future of media measurement strategy for PepsiCo, esp. with focus on building an understanding role of media as key Growth Driver thru ROI and related analytics. You will be a trusted advisor to marketing, Insights leaders and data science team across key markets in laying down strong data foundation through implementation of process & technology.You will be responsible for providing thought leadership and execution in the field of data foundation to set a vision for driving PepsiCo media and content effectiveness through data-driven strategy.This role is the backbone of media measurement agenda at Pepsico and is responsible for building data systems and pipelines to feed into prescriptive and predictive modeling by establishing and enhancing process around data capture, storage, quality and reliability.You will work with Media, Data engineering, Data Science and IT teams globally and within AMESA sector to identify best practices in the industry and across all PepsiCo’s brands, providing support to codify and scale best in-class methods that inspire continuous improvement in marketing effectiveness and ROIs.
Functional Responsibilities
In this role, you will play a key role in shaping the future of media measurement strategy for PepsiCo, esp. with focus on building an understanding role of media as key Growth Driver thru ROI and related analytics. You will be a trusted advisor to marketing, Insights leaders and data science team across key markets in laying down strong data foundation through implementation of process & technology.You will be responsible for providing thought leadership and execution in the field of data foundation to set a vision for driving PepsiCo media and content effectiveness through data-driven strategy.This role is the backbone of media measurement agenda at Pepsico and is responsible for building data systems and pipelines to feed into prescriptive and predictive modeling by establishing and enhancing process around data capture, storage, quality and reliability.You will work with Media, Data engineering, Data Science and IT teams globally and within AMESA sector to identify best practices in the industry and across all PepsiCo’s brands, providing support to codify and scale best in-class methods that inspire continuous improvement in marketing effectiveness and ROIs.
Functional Responsibilities
- Collect, structure, analyze, organize and maintain RAW data from various data sources needed for creating predictive models in structured databases in order to ensure faster model building
- Design, build and codify data structures in efficient way to periodically feed in raw data from various internal and external sources and also manage and house model outputs for quick input to businesses;
- Build data systems and pipelines as per business needs and objectives, in this case prepare data to feed specifically to MMM and media measurement models or any descriptive or prescriptive analysis
- Actively scout new partnerships, concepts, and technologies that can be scaled across portfolio
- Promote data consistency globally to support common standards and analytics
- This role directly feeds into data science stream and needs liasoning with IT
- Partner with PepsiCo functional teams, agencies and third parties to build seamless process for acquiring, tagging, cataloging and managing all media, Nielsen and internal data periodically in structured format as needed for measurement statistical models
- Establish periodic data verification processes to ensure data accuracy
- Engage in R&D to try new data streaming and housing techniques to ensure faster and better answers to business problems
- Build new technologies and algorithms to optimize any business process around creation and maintenance of databases/data lakes running of batch processes for data updation
- Use large data sets to resolve major business and functional issues whisle improving data reliability, efficiency and quality
- Optimize processes implementing new technology and automations
- 5-7 years of experience in the field of data structures, building and managing data lakes
- Past experience in data engineering teams in consulting or ecom/telecom sector
- Experience in relational databases as well as unstructured data streams
- 5+ years of Python or Java development experience,
- Hands-on experience in SQL database design
- Experience with multiple data technologies and concepts such as Airflow, Kafka, Hadoop, Hive, Spark, MapReduce, SQL, NoSQL, and databases like Netezza, Teradata etc
- 5+ years of experience with schema design and dimensional data modeling
- Ability in managing and communicating data warehouse plans to internal clients
- Experience designing, building and maintaining data processing systems
- Experience optimizing larger applications to increase speed, scalability, and extensibility
- Knowledge of predictive modeling, machine-learning tools and techniques
- Educational Background- BE/B TECH/ MS in computer science or related technical field
- Data engineering certification (e.g IBM Certified Data Engineer) is a plus
About Company
PepsiCo is a global food and beverage leader with a product portfolio including 22 brands that generate more than $1 billion each in annual retail sales. Our main businesses – Quaker, Tropicana, Gatorade, Frito-Lay and Pepsi-Cola make hundreds of enjoyable foods and beverages that are loved throughout the world.
At PepsiCo, you get the best of both worlds: an entrepreneur’s mindset plus reach and resources. Our collaborative culture and worldwide presence generate a stream of new opportunities to define the future and propel your life’s work. Bring your unique perspective. Bring curiosity. Bring ingenuity, and drive. We’ll give you a platform to be daring on a global scale.
Recommended Companies
Recommended Events
