Business System Analyst

GEM Plastics; Eastanollee (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

ASI Group is seeking a Business Systems Analyst to support the cMES platform and other ASI business systems. The role acts as the liaison between business, engineering, and vendors, gathering requirements, troubleshooting production issues, and supporting integrations across platforms.

Strong SQL skills and ability to translate business needs into technical solutions are essential. Reporting to the Director, Production Applications, the role may require occasional plant-floor presence for

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Business, or related field; or equivalent experience.
• 4+ years MS SQL Server experience, ability to write and troubleshoot queries.
• Experience with manufacturing/MES platforms and data models.
• Strong communication and collaboration skills across teams.
• Experience with system integrations/APIs and data flows.

Responsibilities

• Serve as a business analyst for the cMES platform, translating needs into clear requirements and specifications.
• Build and optimize MS SQL code; develop stored procedures, views, triggers, and jobs.
• Troubleshoot production issues; coordinate with Engineering and vendors for timely resolution.
• Maintain integrations between cMES and ERP/design systems; ensure data flows across platforms.
• Develop and execute test plans and UAT for system changes and upgrades.
• Document business processes, workflows, configurations, and support procedures.

Skills

MS SQL Server

SQL queries

Requirements gathering

Troubleshooting

Communication

System integration

HTML programming

Education

Bachelor's degree in Information Systems/CS/Business

Tools

MS SQL Server Management Studio

Epicor Kinetic

Job description

ASI Group is seeking a Business Systems Analyst to support our cMES (manufacturing execution system) platform and other ASI business systems. This role serves as the day-to-day analytical and technical liaison between the business, our engineering team, and third-party vendors gathering requirements, troubleshooting production issues, and supporting the integrations that connect cMES to our broader systems environment. The ideal candidate combines a strong SQL background with hands-on troubleshooting skills and the ability to translate business needs into workable technical solutions. Reporting to the Director, Production Applications, this position may require occasional presence on the plant floor to support troubleshooting and end-user needs, along with standard office/remote collaboration with engineering and vendor teams.

KEY DUTIES AND RESPONSIBILITIES

• Serve as a business analyst supporting the cMES platform, partnering with plant operations, engineering, and other business stakeholders to understand needs and translate them into clear requirements and functional specifications.
• Builds the MS SQL code that implements approved requirements and customizations.
• Write, review, and optimize SQL queries to investigate data issues, validate system behavior, support reporting, and assist with root-cause analysis. Develop stored procedures, views, triggers and jobs to standards.
• Troubleshoot and resolve cMES production issues, escalating and coordinating with Engineering and third-party vendors as needed to drive timely resolution.
• Support and maintain integrations between cMES and adjacent systems (e.g., ERP, design/engineering systems, and other manufacturing applications), ensuring data flows correctly across platforms.
• Partner with the engineering team on system configuration changes, enhancements, and new integration projects, from requirements through testing and go-live.
• Coordinate with external vendors on support tickets, upgrades, and implementation of new cMES functionality.
• Develop and execute test plans, including user acceptance testing (UAT), for system changes, patches, and upgrades.
• Monitor system performance and data integrity, proactively identifying and addressing issues before they impact the business. Optimize queries and data models for shop-floor performance.
• Document business processes, system workflows, configurations, support procedures and customizations for the knowledge base.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Business, or a related field, or equivalent combination of education and experience.
• Prior experience as a Business Analyst, Systems Analyst, or similar role supporting manufacturing, ERP, and/or MES platforms. Manufacturing data model knowledge.
• Strong (4+ years) MS SQL Server background, with demonstrated ability to write and troubleshoot queries against relational databases. A good understand HTML programming is also preferred.
• Proven ability to troubleshoot and resolve complex, cross-system technical issues.
• Strong systems integration experience or familiarity with APIs, data feeds, middleware, or similar approaches to connecting enterprise systems.
• Excellent communication and collaboration skills, with the ability to work effectively across engineering teams, external vendors, and business resources at all levels.
• Strong analytical, problem-solving, and documentation skills with close attention to detail.
• Ability to manage multiple priorities and deadlines in a fast-paced manufacturing environment.

Preferred Skills

• Direct experience with cMES or other manufacturing execution systems (MES).
• Experience with Epicor Kinetic or other ERP platforms.
• Background in a manufacturing, industrial, or plant-floor environment.
• Familiarity with reporting/data visualization tools.

Management reserves the right to assign or reassign duties and responsibilities to this job at any time. ASI‑Southeast provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.