Application Analyst in Franklin Township, NJ at Open Systems Technologies

Date Posted: 1/14/2020

Job Snapshot

Job Description

Our client is seeking an Application Analyst to join their team in Somerset, NJ.


  • Support the development and maintenance of multiple enterprise applications, including the M3 ERP system, with focus on manufacturing plant support
  • Develop and maintain interfaces and data integrations between applications to include ERP, manufacturing execution systems and machine PLC data
  • Develop business intelligence reporting to support business requirements, including possible creation of KPI dashboards
  • Maintain data sources, ETL processes, user interfaces, and outputs
  • Support initiatives for process automation and new application introduction
  • Train end users as needed and provide related technical assistance (potential on-call support)
  • Create process documentation
  • Assist with database administration


  • A Bachelor’s degree in Computer Science, Business, Finance, or other quantitative field
  • 1-3+ years of relevant working experience
  • Experience with ERP systems, preferably with a manufacturing focus, and other business applications with emphasis on data extraction and reporting; Experience with manufacturing execution systems (MES) such as Red Zone and machine data interfaces (PLCs) a plus
  • Relational database experience (MS SQL Server preferred) with ability to create T-SQL queries and procedures with the necessary complexity to extract and present data in an accurate and meaningful format; ETL experience such as SSIS is a plus
  • Understanding of data warehousing and business intelligence processes and concepts
  • Experience with Crystal Reports or other reporting/BI tools (e.g. Tableau), MS Office applications, and Power BI a plus
  • Experience with process automation and scripting
  • Understanding of manufacturing and business processes, including supply chain management, purchasing, inventory, production, and finance with the ability to transform business requirements into technical solutions
  • Strong written and verbal communication, interpersonal, organizational, time-management, and problem-solving skills
  • Proactive, self-motivated, and a quick learner
Job keywords: