R&D Data Engineering Specialist

Overview

Vitro is the largest glass manufacturer in the Western Hemisphere and the largest glass producer in North America.  Vitro’s glass products can be found in some of the most iconic vehicles on the road, in countless buildings and homes around the world, and in billions of glass containers produced every year.  With more than 14,000 employees worldwide, we have expanded our global footprint and cemented our leadership role in the industries in which we operate. 

Vitro Architectural Glass manufactures a broad range of industry-leading, energy-efficient products such as Solarban®, Sungate® and Starphire Ultra-Clear® glasses.  Throughout our storied history, collaboration and innovation have been central to our advancements. Today, the key to our success continues to lie in the strength of our partnerships. With a foundation formed on trust, teamwork and shared excitement, the possibilities for impactful innovations in glass are truly endless.

With manufacturing facilities throughout the U.S. and Mexico, Vitro Architectural Glass is committed to sustainable manufacturing processes and products.  Vitro also operates one of the world’s largest glass research and development facilities in Pittsburgh, PA and has four residential glass fabrication plants in Canada.

To find out more, please visit our website: Vitro Architectural Glass | Vitro Architectural Glass (vitroglazings.com)

Data Engineering Specialist 

We are seeking a qualified Data Engineering Specialist to join our Research & Development team at the Glass Technology Center in our Harmar, PA location, just outside of Pittsburgh PA.  The Data Engineering Specialist's general function is to build and maintain Vitro Data and Analytics Platform, develop tools and applications in support of R&D and non-R&D customers

Responsibilities: 

• Works in a safe manner and strictly adheres to all laboratory and manufacturing safety protocols
• Acquire, consolidate and validate large datasets from multiple sources through data platform/system such as SQL, AVEVA PI, and Azure Cloud, etc.
• Perform data transformation and processing thru coding
• Document data variables from different on-prem data sources and in Cloud, transformation, and merge rules
• Mange, orchestrate and troubleshoot data flows in Cloud
• Work with AVEVA PI systems: build and manage PI Views, build AF structures
• Assist in compilation of research reports and communication of research findings in project meetings
• Travel to manufacturing plants for project launch and execution may be required

Qualifications:

• B.S. STEM major (Engineering, Computer Science, or other relevant fields) requires 2+ years relevant experience 
• M.S. entry level with directly applicable degree, otherwise M.S. will also require 1+ year(s) relevant experience 
• Written and verbal communication skills along with human relations competency are essential.
• Strong aptitude and willingness to continually learn and expand skill sets
• Dedication to timely and detailed follow-through
• Skilled in programming with languages including Python, PySpark, and C# .NET
• Experience with relational databases and SQL scripting
• Experience with Excel including scripting and automation

Additional Desirable Skills:

• Knowledge of AVEVA PI
• Knowledge of Microsoft Azure
• Knowledge of Spark
• Knowledge of Apache Kafka
• Fundamental knowledge in statistics and engineering
• Knowledge of glass making and vacuum coating processes

Working Conditions:

The primary location for this position will be at the Vitro Glass Technology Center in Harmar, PA.  This position may on occasion need to travel to manufacturing facilities in the U.S. and Mexico to provide support.

This role will be primarily daylight hours with the occasional need to travel (roughly 5-10%) to manufacturing sites. Some weekend/evening hours may be required if data system server or streaming issues occur during weekend or evening hours and need urgent recovery.