The Data

Building the Workforce of the Future

"There cannot be equity in society without equity in data collection, curation, and decisions."

Women in Big Data Founders
Read Report

Big Data, Data Engineer

This job posting was marked by employer as filled and is probably no longer available
Procter & Gamble
October 2, 2017
Cincinnati, OH, Ohio
Job Type


Do you enjoy turning complex data into optimized data models? Would you like to develop data models that fuel our analytics? If this sounds appealing to you, we are looking for your help in improving P&G’s business results.

As a Data Engineer at P&G, you need to be a technical master. You will need to be an effective technologist, self-motivated, and able to source and develop critical data models to drive our analytics.

As a Data Engineer, you will be a practitioner of advanced data modeling and optimization of data and analytics solutions at scale. You will need to be an expert in data management (any sources of data like POS, Consumer profile, ...) and data access (Big Data Apache Hadoop, traditional Data Marts, etc.). You will need to be advanced in programming (Python, Shell scripting, Java, and SQL) and data base modeling, including familiarity with analytic algorithms and applications (like Machine learning). You will be a leader in P&G data capability building with the potential to expand into Solution Management or Data Science.

Data Engineers need to be technically capable in the following ways:

  • Willing to get your hands dirty, leveraging data types and various data models to enable a range of analytic solutions.
  • You should be adept at leveraging such technologies for managing and manipulating data, scaling data models and solutions to support the analytics for business insights.
  • 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.

Qualifications - External

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, Operations Research, or Statistics.

If you are a good fit for the Data Engineer position, you will have the following skills:

  • 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
  • 5+ years relevant industry experience

If you are an excellent fit for the Data Engineer position, you will also have:

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

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.

Just so you know:

  • 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.
Drop files here browse files ...

Related Jobs

Senior Data Scientist (REMOTE)   REMOTE, United States of America new
August 5, 2022
Data Scientist   Philadelphia, PA
July 29, 2022
Geospatial Software Engineering Lead   Philadelphia or Remote (USA or Canada), PA
July 26, 2022
Senior Partner Engineer - Android Mobile Games   San Jose, United States of America
July 20, 2022
Research Specialist (Part time, remote USA)   Philadelphia (or remote USA), PA
July 18, 2022
Are you sure you want to delete this file?