IT Business Analyst

Primary Responsibilities

• Data & Reporting (SQL focus): Write and maintain complex SQL queries, views, and stored procedures to support financial and manufacturing reporting.
• System Administration: Act as the primary internal administrator for ERP systems, managing user permissions, troubleshooting transaction errors, and ensuring system stability.
• Implementation & Lifecycle Support: Collaborate with external consultants during implementation projects by performing data mapping, validation, and migration from legacy SQL tables.
• Ecosystem Integration: Evaluate, test, and support the integration of third-party applications (e.g., EDI, WMS, or Payroll) into the core ERP environment.
• Data Stewardship: Manage and maintain legacy data archives to ensure historical records remain accessible and accurate following system upgrades or migrations.
• Process Improvement: Analyze manufacturing workflows (Inventory, BOMs, Production) to identify inefficiencies and propose system-based solutions.
• Testing & QA: Lead internal User Acceptance Testing (UAT) for all system updates, patches, and new module deployments.
• Training: Develop and maintain technical documentation and "How-To" guides for end-users across the production floor and office.

Qualifications

• 3+ years in an IT Analyst or Systems Analyst role, preferably within a manufacturing or distribution setting.
• Advanced SQL skills are a must (joining tables, writing scripts, and understanding relational database schemas).
• Functional experience with an ERP system (GP, NetSuite, or similar); the ability to understand how data flows from the shop floor to the General Ledger.
• Exceptional ability to troubleshoot data discrepancies and "connect the dots" between business processes and software logic.
• Bachelor’s degree in Information Systems, Computer Science, Finance, or a related field.

Education

The English proficiency required is limited to what is necessary to perform these tasks safely and effectively. The work environment is not climate-controlled and may be hot or cold depending on seasonal weather conditions.