Data Management Engineer

Cornerstone:

As an automation company we are faced every day with solving our customers’ most challenging manufacturing problems. Those customers are increasingly turning to digital solutions to leverage their current investments for improving efficiency, throughput, and ROI. Our Data Integration Engineering team is at the forefront of the digital transformation the manufacturing industry is going through. Our focus on business results for our customers allows us to be the technical experts that add value and become indispensable.

At Cornerstone you will find a purpose and mission for your work. Not only will you have significant personal and technical growth, but you will also be helping customers achieve results related to their objectives, which can include the production of life-saving medicines, sustainable products, achieving energy efficiency gains, and chemical, food, and other industrial manufacturing.

We offer excellent career development opportunities through training, mentoring, team-oriented work, and personal growth in leadership paths. We have technical, management, and sales career paths available to our associates. We also offer an excellent work-life balance between providing services to our customers and backing each other up in times of high demand.

Come join our exciting team and develop your career with us as a Data Management Engineer at Cornerstone!

Job Description:

We are looking for a Data Management Engineer who can be a customer facing individual, capable of executing projects in the Manufacturing Level 3 and 4 spaces – starting with the boundary between computer automation and IT systems and continuing up through and including the cloud and enterprise level. This individual will be responsible for coordinating with customer site contacts and implementing solutions in a challenging real-time process environment. The Data Management Engineer must be able to understand, troubleshoot, and resolve issues.

The Data Management Engineer, as a use case developer, will work with a variety of data management software platforms, leveraging the necessary programming interfaces for the development of solutions to meet the customer requirements. This responsibility includes building data flows use cases between OT (operational technology) and IT system layers - exposing data from the OT layer to users within the IT landscape (passing data up through layers in the Purdue Model). This work will be performed both in the office and at customer sites, applying software and data management expertise to deploy and support data management in new and existing industrial automation solutions.

Project execution tasks include the installation and configuration of complete solutions that may include Centralized Data Management, Reporting, Interfaces to Automation and ERP systems, Data Visualization and Dashboards. This ranges from the initial server installation to the configuration of data systems with interfaces to a wide variety of possible 3rd party data sources. This position will utilize various skills with the Windows Operating System, network configuration, and software development.

The candidate will be responsible for implementing the configuration and/or the custom software components necessary to meet the project requirements. On-site customer visits will occur to commission the solutions and to facilitate startup and training activities.

Skills:

• Project delivery with data systems, and the delivery of projects on time and within budget.
• Working knowledge and experience with Microsoft Windows Server Operating Systems.
• Working knowledge and experience with data management systems, including AVEVA PI, AspenTech InfoPlus.21, AspenTech Inmation, dataPARC PARCview & PARCserver.
• Experience with Kafka, JSON, and MQTT.
• Experience with the Lua programming language or equivalent languages, such as Python and JavaScript.
• Expertise in databases, such as SQL and MongoDB, and visualization tools, such as Power BI, Tableau, and other API’s.
• Experience with computer programming and debugging, including VB/C#, SQL, web development, or other modern languages.
• Experience with OT communication protocols (OPC Classic & OPC UA, TCP, Modbus).
• Familiarity with concepts such as networks, databases, servers, communications, and information security, with a proven track record of successful participation in software development.
• An entrepreneurial work ethic, a passion for customer service, and ability to work independently or collaboratively within a team.
• Initiative and follow through to completion.
• Continuous learning and commitment to improvement.
• Knowledge of network administration and server troubleshooting.
• Beneficial: Understanding of Distributed Control Systems and PLC’s.

Requirements:

• Bachelor of Science in Engineering or Computer Science
• Ability to travel up to 10% within our 4-state area (Indiana, Kentucky, Ohio, Michigan).
• This position is based in Indianapolis.
• 5+ years of experience