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.

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 Role

‍

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), FactoryTalk 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.

‍

‍

Job Qualifications

Required:

‍

• 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/SparkSQL 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.

‍

​Preferred:

‍

• 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 PowerBI front end.
• Familiarity with Agile SCRUM and DevOps methodologies.

‍