Job Description
This role is with the PFNA Data & Digital Solutions team within PFNA IT.
PFNA Data Analyst:
In this role, you will play a key role in advancing PFNA data solutions & capabilities. You will execute data-related initiatives in one or more functional domains (finance, sales, marketing, supply chain) that take raw data and transform it into actionable insights.
You will be a hands-on player that moves data from raw source systems to our PFNA integrated data fabric, and then makes it accessible for business users to explore. You will be responsible for building data systems and pipelines to feed into prescriptive and predictive modeling initiatives by establishing and enhancing processes around data capture, storage, accessibility, transformation and reliability.
You will work with PFNA IT and business professionals across multiple functions to drive and support the PFNA transformation to an insights-driven culture. You will identify opportunities for more streamlined and automated approaches to solve business problems with data/digital solutions and advocate for their adoption.
You will help manage and mentor other PFNA IT associates working in the data & digital space in support of the above goals.
Qualifications/Requirements
BE/B TECH/ MS in computer science or related technical field
Experience:
* 3 years of experience in the field of data structures, building and managing data lakes
* Past experience in data engineering teams in consulting or other industries. CPG industry experience a plus.
* Experience in relational databases as well as unstructured data streams
* 3+ years of Python or Java development experience,
* Hands-on experience in SQL database design
* Experience with multiple data technologies and concepts such as Hive, Spark, SQL, Kafka, Sqoop, Infoworks, along with traditional relational database technologies such as Teradata, Oracle, SQL Server, etc
* Experience with data lake ETL & query technologies such as Denodo, Presto, Databricks
* 3+ years of experience with schema design and dimensional data modeling
* Experience designing, building and maintaining data processing systems
* Knowledge of predictive modeling, machine-learning tools and techniques
* Data engineering certification (e.g IBM Certified Data Engineer) is a plus
* Proven self-starter who can move projects forward by filling in the gaps on Agile teams, from leading a design session to doing some test automation, to mentoring a teammate struggling with a new technology
* Experience in dealing with big as well as thick data(syndicated data like Nielsen and survey-based)
* Expert in new-age data platforms, understanding of relational as well as unstructured data, experience in data lake architecture and creation
* Proactively identify and manage escalation of potential issues, offering ideas for solutions.
* Experience with specific AWS technologies (such as Glue, S3, Redshift, EMR, and Kinesis) a plus
* Hands-on with Machine learning concepts & skills Regularization, Gradient-based optimization Hyper-parameter tuning, models like Random Forest
* Familiarity with Scala, Java or C++ is an asset
* Experience with data in sales, finance or supply chain a plus
AF-Tech
Relocation Eligible: Not Eligible for Relocation
Job Type: Regular
Purchase, NY
PepsiCo, Inc. operates as a food and beverage company worldwide. The company’s Frito-Lay North America segment offers branded dips; Cheetos cheese-flavored snacks; and Doritos tortilla, Fritos corn, Lay’s potato, Ruffles potato, and Tostitos tortilla chips. Its Quaker Foods North America segment provides cereals, rice, pasta, mixes and syrups, granola bars, grits, oat squares, oatmeal, rice cakes, simply granola, and side dishes under the Aunt Jemima, Cap’n crunch, Life, Quaker Chewy, Quaker, and Rice-A-Roni brands.
The company’s North America Beverages segment offers beverage concentrates, fountain syrups, and finished goods under the Aquafina, Diet Mountain Dew, Diet Pepsi, Gatorade, Mountain Dew, Pepsi, Propel, Sierra Mist, and Tropicana brands; and ready-to-drink tea, coffee, and juices. Its Latin America segment provides snack foods under the Cheetos, Doritos, Emperador, Lay’s, Marias Gamesa, Rosquinhas Mabel, Ruffles, Sabritas, Saladitas, and Tostitos brands; Quaker-branded cereals and snacks; and beverage concentrates, fountain syrups, and finished goods under the 7UP, Diet Pepsi, Gatorade, H2oh!, Manzanita Sol, Mirinda, Pepsi, Pepsi Black, and Toddy.
The company’s Europe Sub-Saharan Africa segment offers snack food under the Cheetos, Chipita, Doritos, Lay’s, Ruffles, and Walkers; Quaker-branded cereals and snacks; beverage concentrates, fountain syrups, and finished goods under the 7UP, Diet Pepsi, Mirinda, Pepsi, Pepsi Max, and Tropicana; ready-to-drink tea products; and dairy products under the Agusha, Chudo, and Domik v Derevne brands. Its Asia, Middle East and North Africa segment provides snack foods under the Cheetos, Chipsy, Doritos, Kurkure, and Lay’s brands; cereals and snacks under the Quaker brand; beverage concentrates, fountain syrups, and finished goods under the 7UP, Aquafina, Mirinda, Mountain Dew, Pepsi, Sting, and Tropicana brands; and ready-to-drink tea products. The company was founded in 1898 and is headquartered in Purchase, New York.