Site Manufacturing Data Engineer

Job Description

P&G is the largest consumer packaged goods company in the world. We have operations in over 75 countries, with 65 trusted brands that improve lives for 5 billion consumers worldwide. This brings many advantages, including the opportunity for our employees to enjoy a diverse and rewarding lifelong career filled with new and exciting challenges.

AUBURN PLANT

Our Auburn site is located about 40 minutes from Portland - Maine's largest city - and is an integral production node within our Feminine Care business unit. Here we manufacture most of P&G's tampon products for worldwide distribution. At Auburn we model our approach to work after several core values: culture of safety - nothing we do is worth getting hurt - utmost emphasis on quality, as well as placing confidence and trust in our people and systems.

The Auburn plant was founded in 1968 as part of Tambrands, Inc. before being acquired by P&G in 1997. Our site has almost 600 full‑time employees split between technicians, engineers, and support personnel working in a variety of operating or support departments.

The Site Manufacturing Data Engineer is a key role that drives effective connection between the ICA/OT systems and other plant/company digital systems. This includes identifying high‑value data in the PLC, HMI and other OT systems, and implementing and configuring the data pipeline to MDF, Edge‑to‑Cloud, AI Factory, and other higher‑level data systems.

The Site Manufacturing Data Engineer reports to Site Digital Leader and works closely with the Site Data Asset Manager, other Digital Platforms Team resources, and site/department ICA resources. This role requires a blend of both IT and OT technical expertise, and a passion for continuous improvement in a dynamic manufacturing environment.

The Site Manufacturing Data Engineer requires Basic skill for all applicable site ICA/OT and automation technologies including Rockwell, Siemens (if applicable), Factory Talk and/or Aveva, Engineering systems (Studio, System Platform, etc), with preference for Basic skills in applicable warehouse technologies. This role may not include direct modifications to department control systems but requires ability to communicate using ICA/OT terminology and specifically describe data and required components/programming needed to access it including potential for implementing new tags/routines/interfaces.

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 0-2 years of Data Engineer experience
• Fundamental knowledge of networking concepts, including OT 4.0, servers/virtualization, relevant databases, and process historians.
• Proven experience in Python/PySpark and SQL/Spark
  
  SQL programming skills.
• Proficiency in English, with strong communication skills.
• Proven ability to execute tasks with excellence, establish priorities, and develop effective plans. Willingness to provide guidance and coaching to ICA resources, site digital teams, and data customers.
• Strong capability to work independently and effectively within a highly matrixed organization, demonstrating a passion for fulfilling customers’ data pipeline needs while balancing multiple priorities.

• Familiarity with Big Data and ETL processes, with preference for experience in Spark and Databricks.
• Experience in implementing projects and solutions in cloud environments, preferably Azure or GCP (AWS is also acceptable).
• Basic skills in data architecture frameworks, data engineering, and data modeling principles.
• Knowledge of AAS, DAX, and Power
  
  BI front end.
• Familiarity with Agile SCRUM and Dev Ops methodologies.

Compensation for roles at P&G varies depending on a wide array of equal opportunity factors including but not limited to the specific office location, role, degree/credentials, relevant skills, and level of experience. At P&G compensation decisions are dependent on the facts and circumstances of each case. Total rewards at P&G include salary + bonus (if applicable) + benefits. Your recruiter may be able to share more about our total rewards offerings and the specific salary range for…