Business Systems Analyst

Tailor Your Resume for this Job

We are seeking a Business Systems Analyst with mandatory expertise in VAI S2K ERP and Infor M3, along with data migration experience, to support and optimize our manufacturing, distribution, and financial operations. The ideal candidate will analyze business processes, implement system improvements, and collaborate with stakeholders to enhance efficiency.

Key Responsibilities

• Analyze, design, and implement VAI S2K ERP and Infor M3 solutions for manufacturing, distribution, and financial workflows.
• Lead data migration efforts, ensuring accuracy, integrity, and seamless transition between systems.
• Develop and execute complex SQL scripts, including consolidated queries for data extraction, transformation, and loading (ETL).
• Formulate and implement data migration strategies, ensuring minimal downtime and optimal performance.
• Work extensively with VAI S2K and Infor M3 master tables and transaction tables to ensure accurate data handling and system integrity.
• Gather and document business requirements, ensuring alignment with ERP system capabilities and business needs.
• Conduct and support User Acceptance Testing (UAT) to validate system functionality and ensure smooth implementation.
• Build and publish Power BI reports, transforming raw data into actionable insights for business decision-making.
• Utilize IBM DB2 database, ensuring efficient data management, optimization, and troubleshooting.
• Develop, maintain, and integrate Java applications to support ERP functionalities and business processes.
• Develop and maintain IBM RPG applications, ensuring seamless integration with ERP systems.
• Collaborate with cross-functional teams to identify system requirements and improvements.
• Provide technical support, troubleshooting, and training for end-users.
• Develop reports and dashboards to enhance business decision-making.
• Ensure system integrity, security, and compliance with industry standards.

Qualifications

• Experience: Mandatory minimum 2 years of hands-on experience with VAI S2K ERP, Infor M3, IBM DB2 database, IBM RPG, Java applications, data migration, business requirements gathering, and UAT testing in manufacturing, distribution, and financial environments.
• Education: Bachelor’s degree in Computer Science (mandatory).
• Skills: Strong analytical, problem-solving, and communication skills.
• Technical Knowledge:
• High-level expertise in SQL, including writing complex consolidated queries for data manipulation and migration.
• Ability to formulate and execute migration strategies for seamless data transitions.
• Deep familiarity with VAI S2K and Infor M3 master tables and transaction tables for efficient data management.
• Experience with ERP integrations, SQL databases, reporting tools, and data migration best practices.
• Proficiency in Power BI, including the ability to build and publish reports for business intelligence and analytics.
• Hands-on experience with IBM DB2 database, including optimization, troubleshooting, and data management.
• Hands-on experience with Vertex Cloud, integration with VAI and Infor M3.
• Familiarity with Java applications, including development, maintenance, and integration with ERP systems.
• Expertise in IBM RPG, including development, maintenance, and integration with business applications.
• Ability to gather and document business requirements to ensure ERP solutions align with operational needs.
• Experience conducting and supporting UAT testing to validate system functionality and ensure smooth implementation.

Job Type: Full-time

Work Location: In person