FMS Reporting Engineer at CHEP

POSITION PURPOSE

• Provide global Factory Management System (FMS) reports and facilitate FMS projects. This role will also develop new process reliability reporting tools and deliver specialized security features and procedures alongside value documenting.  

MAJOR / KEY ACCOUNTABILITIES

• Interface and support projects with FMS team to ensure alignment with major initiatives in Factory Management Systems and Process Reliability. 
• Utilize reporting (SQL) tools, and production monitoring methodologies (such as AVEVA/Wonderware, Control Logix) to report on process flows and generate reports of service centers performance.
• Determine reporting process improvements to improve development performance year over year.
• Enable processes and reports to provide proper validation of data during system commissioning.

MEASURES

• Successful delivery of assigned FMS reporting projects on time.

SCOPE

• Utilize standard SQL reports using accepted corporate approach

AUTHORITY / DECISION MAKING

• Interaction with team and line manager for guidance.

CHALLENGES

• Successful delivery of assigned FMS reporting projects within aggressive timing. 
• Expectation to support global help ticket system when needed based on time zone.

KEY CONTACTS

• Engineering, Operations & IT

QUALIFICATIONS

• A bachelor’s degree in Computer Science, Information Technology, Telecommunications, Electronics & Electrical or related field. 
• Proficient in SQL (Writing complex stored procedures), Microsoft SQL Server and SQL Server Reporting Services (SSRS)
• Extensive knowledge of data validation generated from industrial systems
• Experience with ASP.NET and JavaScript
• Experience with Power BI and data analysis
• Data analyst

Desirable:

• Familiar with SQL Server, SQL Agent and PowerShell
• VB and C# programming
• Background in cloud services 
• Background in mobile application development
• Familiarity with Blazor
• AVEVA/Wonderware exposure / experience
• PLC background and industrial equipment process understanding

EXPERIENCE

• 3-5 years working experience in SQL reporting preferably in manufacturing environment
• Proficiencies in Microsoft Technologies
• Proven experience in production monitoring and factory management systems (FMS)
• Proven capability in ensuring performance, security and availability of databases and reports

SKILL AND KNOWLEDGE

• Skilled in optimizing large, complicated database structure
• Knowledge of best practices when dealing with relational databases
• Capable of troubleshooting common database issues
• Interest in becoming a content expert in industrial reporting databases and warehouses.

Preferred Education

• Bachelors - Information Technology
• Preferred Level of Work Experience
• 3 - 5 years