Springfield Tech Council

CSI Syteline Developer - Remote Position

CSI Syteline Developer - Remote Position

Dimensions: 

  • Maximizing the effectiveness and efficiency related to:
    • Direct labor resources to access information and record data transactions necessary for safety, financial reporting, job status/performance visibility, and continuous process improvements (efficiency and quality).
    • Indirect and overhead administrative labor for all production/business support functions and analytics
  • Business process and IT support sustainability and scalability.

Essential Responsibilities: 

  • Responsible for design, development, maintenance for Infor CSI / Syteline ERP and related business systems following best practices, while maintaining system and data integrity within CNH Reman and integration with external entities.
  • Responsible for evaluation of business process requirements and providing guidance/recommendation based on the application of standard enterprise system processes as priority over any customization or manual systems that would adversely affect the system/integration integrity or the scalability/sustainability of the process and IT support.
  • Responsible for collaborating with the users to develop and maintain accurate business process documentation and related user instructions for all business activities related to enterprise systems, databases, and information exchanged with external entities and for the period review of the processes/documentation to ensure accuracy, conformance to best practices, and that any changes are reviewed to insure the efficiency,  system/integration integrity and the scalability/sustainability of the process and IT support .
  • When customization is required, responsible for using programming tools and techniques which are compatible with enterprise software/database upgrade processes and conform to best practices for development, testing, promotion, and deployment.
  • Responsible for acting as liaison between user/enterprise and vendor support on any issues that arise and communication of same to all members of the IT team.
  • Responsible for Leading/Participating in application development, upgrade projects, testing, documentation of test results, collaboration with stake holders during the development process, documentation of project through project management and inserting comments within the revised code, develop work instructions, perform user acceptance testing, and change management of projects.

Job Specifications

Impact:  

  • User efficiency in performing business transactions and accessing transaction-based information.
  • Maintaining integration of business processes, resulting in consistent basis for decisions, data integrity, and enterprise efficiency.
  • Maintaining business process sustainability and scalability facilitates growth.
  • Design and develops data transformation using T-SQL, SSRS, SSIS and Mongoose programming languages. 
  • Develop, implement, analyze and optimize SQL queries/stored procedures.
  • Analyze existing SQL queries/stored procedures for performance improvements.
  • Assisting in implementing automated testing platforms.
  • Supports implementations of enhancements and fixes by providing coding knowledge
  • Develops support tools.
  • Assist less experienced peers and may act as a team lead.
  • Train department personnel and develop training materials and procedures
  • Keeps stake holders informed of all enhancements, troubleshooting, and fixes; assists the stake holder in determining if and how system enhancements may improve process flow and business function.
  • Creates required technical documentation.
  • Design, create and maintain databases and tables structures based on business requirements
  • Translate use cases into functional applications/automated processes
  • Analyzes and implements ETL development solutions to meet the business needs. May use tools such as the following: MS Visual Studio, SQL Server, SSIS, Mongoose.
  • Consults with analysts and technical staff, determines needs and designs ETL solutions for more complex problems. Suggest alternate approaches to meet user needs.
  • Responsible for troubleshooting, debugging ETL and creating unit tests.
  • Creates technical documentation.
  • Conducts tasks and assignments as directed while looking for efficiencies.
  • Conducts code reviews and acts as a resource to others to resolve problems.
  • Other duties as assigned.

Communication:  List the types of individuals this position regularly communicates with, both internally and externally (i.e. customers, suppliers, regulatory agencies), and describe the nature of the communication (i.e. information exchange, influence and negotiate).

  • Must communicate with users, management, and IT staff to define and insure that system solutions:
    • Meet or exceed the business requirements defined for the project.
    • Ensure efficiency, system/integration integrity, and the scalability/sustainability of the process and IT support.
  • Must communicate with Finance to ensure that necessary fiscal/audit controls are maintained.
  • Must Communicate with Safety department to ensure all OSHA 1910 standards are followed
  • Must Communicate with Quality department to ensure all ISO standards are followed

Experience:

Required:

  • Bachelor’s Degree in computer science or related field with emphasis on application technology, business, or industrial technology OR with hands-on programming and/or cross functional business process analysis experience that exceeds the normal minimum requirement for this position.   
  • Minimum of 7 years of experience as a programmer/systems analyst configuring, customizing, or extending/integrating commercial applications.
    • 5 years Software Development
    • 5 years Infor CloudSuite Industrial (CSI) Syteline Development
  • 5 years SQL Server experience
    • 4 years Developing business reports with Mongoose Reporting & DataViews
  • C# Programming Language (.Net, Visual Studio, etc.)
  • Strong development and analytical SQL report writing and database skills
  • Ability to understand and analyze commercial cross functional integrated business systems
  • Strong written and communication skills
  • Ability and willingness to work in an environment providing extended support (some second shift, some weekend/year-end)
  • Ability and willingness to assist other BA’s in acquiring/developing similar SQL skills
  • Minimum of 3 years of experience supporting integrated business processes across Finance, Cost Accounting, and Supply Chain functions.
  • Minimum of 2 year developing/supporting business intelligence (BI) applications, SQL Server Analytic services or similar, or demonstrated skill/experience developing complex enterprise reporting packages and tools (e.g. SSRS, Crystal, etc.).
  • Ability to think critically to comprehend and document complex system requirements.
  • Demonstrated programming expertise with Windows based languages/scripts/tools, SQL application side services, and event driven applications.
  • Ability to organize, plan, and prioritize work to achieve personal and company goals.
  • Walking, standing, stooping, bending, lifting, reaching. Requiring hours of service that would average at least 30 hours of service per week
  • Minimum GED or High School diploma. 
  • Overtime
  • Must be able to read MSDS sheet.

 Preferred Experience:

  • Infor CloudSuite Industrial (CSI) ERP Software (Syteline) forms, tables and IDO’s.
  • Understanding of T-SQL Queries, Stored Procedures, DataViews, Triggers, Functions and Constraints. 
  • ERP Supply Chain experience
  • EDI Integration (SSIS)
  • Experience with data analytics and reporting solutions using Microsoft’s Business Intelligence suite of products (SSIS, SSAS, SSRS, etc)
  • Minimum of 5 years of experience in manufacturing environments using standard supply chain, cost accounting, and general accounting processes. 

Skills:

Required:

  • Strong knowledge and experience with SQL Queries & Stored Procedures
  • SQL Statement and Constructs
  • Microsoft SQL Server
  • Microsoft SQL Server Management Studio (SSMS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Mongoose Reporting & DataViews

Preferred Skills:

  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Two and Multi-Dimensional Data Modeling (SQL and Cube)
  • Microsoft SharePoint

Apply online at: https://theapplicantmanager.com/jobs?pos=k6723&fs=1.0em

Additional Info

Job Type : Full-Time

Powered By GrowthZone