Skip Navigation

Job Description

Associate IT Data Engineer-Wrangler

As a Data Wrangler or Data Engineer at P&G, you are technical masters: you need to be effective technologists, self-motivated, and able to source and develop data models to fuel the analytics, developed by the analysts and data scientists, which improve P&G’s business results. Data Engineering is an acceleration factor behind the productivity and effectiveness of Data Science. Technical mastery and interpersonal /communication skills are therefore a must to thrive in a team. Your job is to onboard complex data, optimize data models and code into scale pipes and applications that will drive the analytics into insights. Data and Analytics roles include:

Data Wrangler - Delivers data acquisition, transformations, cleansing, conversion, compression, and loading of data into data and analytics models. Work in partnership with data science and analysts to understand use cases, data needs, and outcome objectives. As a partner, you will have project work and ad hoc requests that require agility and often fast paced response to business needs.

Technically Capable:
  • Perform data discoveries to understand data formats, source systems, file sizes, etc. Additionally, may collect data delivered in various formats or from various systems (relational databases, FTP sites, file sharing sites (e.g. Box), external hard drives, etc.)
  • Load data in numerous different compressed and uncompressed formats (gzip, zip, tar, json, csv, Excel, etc.)
  • Perform data transformations using Hive and Impala to optimize data retrieval process and performance
  • Create workflows for loading data on a scheduled basis using Oozie, shell scripting, sql, etc., basic working knowledge of database design and admin, and ability to create technical design documents.

Data Engineer - Practitioner of advanced data modeling and optimization of data and analytics solutions at scale. Expert in data management (any sources of data like POS, Consumer profile,), data access (Big Data, traditional Data Marts,), advanced in programming (Python, Shell scripting, Java, and SQL), advanced data base modeling, familiarity with analytic algorithms and applications (like Machine learning). Be a leader in P&G data capability building. Potential to expand into Solution Management or Data Science.

Technically Capable: As a P&G Data Engineer, you:
  • Will “get your hands dirty”, leveraging data types and various data models to enable a range of analytic solutions
  • Should be adept at leveraging such technologies for managing and manipulating data, scaling data models and solutions to support the analytics for business insights.
As a P&G data wrangler or Engineer you will be a part of an award winning Business Intelligence and IT community that is Global in scope, and operates across all of P&G’s core disciplines to drive business value.

IT at P&G
Information Technology (IT) at Procter & Gamble is where business, innovation and technology integrate to create a competitive advantage for P&G. Our mission is clear -- we deliver IT to help P&G win with consumers. P&G IT professionals are diverse business leaders who apply IT mastery to deliver game-changing, technology-driven business models and capabilities. Whether your role is to create an IT innovation strategy for a business, protect our critical information systems and assets, or manage a strategic supplier in our cutting-edge shared services organization, your technical mastery will be recognized and rewarded. Your passion for the industry will be further cultivated by our culture of continued learning and growth as an IT professional. A career in IT builds change leadership and influence skills, breadth of experience across multiple businesses, and depth of expertise in areas like Application & Integration, Infrastructure, Data& Analytics, and Security & Risk.

About P&G
P&G serves consumers around the world with one of the strongest portfolios of trusted, quality, leadership brands, including Always®, Ambi Pur®, Ariel®, Bounty®, Charmin®, Crest®, Dawn®, Downy®, Fairy®, Febreze®, Gain®, Gillette®, Head & Shoulders®, Lenor®, Olay®, Oral-B®, Pampers®, Pantene®, SK-II®, Tide®, Vicks®, and Whisper®. The P&G community includes operations in approximately 70 countries worldwide. Please visit for the latest news and information about P&G and its brands.

We are looking for leaders who have graduated with a BS or MS in Business/Management Information Systems and/or Computer Science/Engineering, Programming/Software Development or Operations Research or Statistics who have the following skills:

Data Wrangler & Engineer
  • Demonstrated mastery in applied big data technologies such as:
    • SQL
    • Linux
    • Shell Scripting
    • Relational databases, ER models/diagrams
    • AWS and/or Azure framework
  • Understanding of Data Mining, Data Modeling, and Data Provisioning (acquisition, transformation and sharing).
  • Strong written and verbal communication skills to influence others
  • Demonstrated use of data and BI tools
  • Demonstrated ability to handle multiple priorities
  • Ability to work collaboratively across functions
  • 0-5 years relevant industry experience

Data Engineer
  • Have working knowledge in programming languages such as Python, Java and R and packaging/build tools such as sbt, Apache Maven or Ant
  • Demonstrated skills or are familiar with Big Data technologies (Hive, Impala) and NoSQL databases
  • Proficiency of data modeling and solution scaling.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, disability status, age, sexual orientation, gender identity and expression, marital status, citizenship, HIV/AIDS status or any other legally protected factor.

Immigration sponsorship is not available for this position. Applicants for U.S. based positions are generally required to be eligible to work in the U.S. without the need for current or future sponsorship. Except in rare situations based on Procter & Gamble's sole discretion. Procter & Gamble does not sponsor candidates for permanent residency. Any exceptions would be based on the Company's specific business needs at the time and place of recruitment as well as the particular qualifications of the individual.

Procter & Gamble participates in e-verify as required by law.

Qualified individuals will not be disadvantaged based on being unemployed.

Job ID
IT 00000956
United States ,Ohio ,Cincinnati

Not sure which career areamay be right for you?

Try our fun, interactive tool - the results may surprise you.

Let's Go

Why I Joined P & G