Business Systems Analyst; ERP​/SQL

About Us

Air Innovations is a world leader in designing and building environmental process control systems for applications that can’t be addressed with standard HVAC equipment. We customize packaged solutions for temperature, humidity, filtration, pressurization, and with direct-expansion, chilled-water, or thermoelectric capabilities.

The Business Systems Analyst provides technical support and leads the improvement, implementation, and maintenance of the organization’s information systems, including ERP and SQL systems, to optimize performance, ensure security, and support business operations. This role is mainly responsible for internal support of Air Innovations ERP system, support and maintain SQL database, troubleshooting system issues, managing user access, supporting compliance efforts, implementing new technologies, and providing end-user training.

The Business Systems Analyst works closely with internal stakeholders and external vendors to implement solutions that improve operational efficiency, maintain system integrity, and ensure compliance with internal controls and audit requirements.

• Primary internal support resource for the ERP system
• Lead the development, implementation, support, and continuous improvement of the organization’s ERP system and related information systems.
• Install, configure, maintain, and support ERP applications
• Manage ERP and network user accounts, including access controls, permissions, email accounts, and phone systems.
• Troubleshoot, diagnose, and resolve ERP, hardware, software, network, and system issues in a timely manner.
• Develop, maintain, and execute SQL queries, scripts, and reports, including ERP reporting and data analysis.
• Support ERP upgrades, patches, testing, and system enhancements.
• Monitor and support system backups, maintenance, and data restoration processes for SQL and the ERP.
• Coordinate and manage external MSP IT, ERP, and telecommunications vendors and contractors.
• Support internal and external audits by ensuring systems meet compliance, security, and internal control requirements.
• Assist in developing and maintaining ERP and Business Process policies, procedures, and best practices.
• Analyze system and ERP performance, identify trends, and recommend improvements and new technologies.
• Create and maintain system documentation, process flows, and ERP user guides.
• Train end users on ERP systems, applications, and IT processes.
• Support and maintain organizational equipment including computers, laptops, printers, projectors, phone systems, and network devices.

• Bachelor’s degree in Information Systems, Information Technology, Computer Science, or related field
• Minimum of 5 years of experience supporting ERP and SQL
• Required experience supporting and administering an ERP system
• Strong experience with SQL, including writing queries, scripts, and reports
• Experience troubleshooting hardware, software, and network systems
• Experience managing user access, permissions, and security controls
• Experience working with third‑party IT and ERP vendors
• Strong analytical, troubleshooting, and problem‑solving skills
• Excellent communication and user support skills

• Knowledge of and ability to administer, configure, maintain, and troubleshoot ERP systems, including managing user access, security, and system performance.
• Knowledge of and skill in using SQL and relational databases to develop queries, scripts, and reports for data analysis and business operations.
• Knowledge of information systems infrastructure.
• Knowledge of information security principles, access controls, backup and recovery procedures, and audit and compliance requirements, and the ability to implement and support these controls.
• Skill and ability to diagnose, troubleshoot, and resolve system, ERP, hardware, software, and network issues and implement effective solutions.
• Skill in analyzing system performance, identifying trends, and recommending and implementing system and process improvements.
• Skill in creating and maintaining technical documentation, procedures, and user training materials, and the ability to effectively…